Monitoring Queries
SQL 2016
| Intermediate
- 9 Videos | 59m 52s
- Includes Assessment
- Earns a Badge
An enterprise database infrastructure has a lot of moving pieces, and it's crucial that they be monitored. Explore SQL Server database queries, including the Query Store, Extended Events, SQL Trace, and troubleshooting server health.
WHAT YOU WILL LEARN
-
describe the purpose of the Query Store, its features, and configuration optionsdescribe scenarios for using the Query Storedescribe the features, benefits, and architecture of performance monitoring with Extended Eventscreate an Extended Events sessionrecognize how Extended Events can be used to troubleshoot performance issues
-
describe the features, benefits, and architecture of SQL Tracedescribe the uses of SQL Traceidentify issues with execution plansmonitor database activity in SQL Server 2016
IN THIS COURSE
-
1.The Query Store7m 42sUP NEXT
-
2.Query Store Usage6m 7s
-
3.Monitoring Performance Using Extended Events5m 16s
-
4.Creating an Extended Events Session8m 23s
-
5.Troubleshooting with Extended Events7m 3s
-
6.SQL Trace6m 10s
-
7.Using SQL Trace6m 16s
-
8.Identifying Execution Plan Issues7m 26s
-
9.Exercise: Monitoring Activity in SQL Server 20165m 27s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.