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 options
describe scenarios for using the Query Store
describe the features, benefits, and architecture of performance monitoring with Extended Events
create an Extended Events session
recognize how Extended Events can be used to troubleshoot performance issues -
describe the features, benefits, and architecture of SQL Trace
describe the uses of SQL Trace
identify issues with execution plans
monitor database activity in SQL Server 2016
IN THIS COURSE
-
7m 42sAfter completing this video, you will be able to describe the purpose of the Query Store, its features, and its configuration options. FREE ACCESS
-
6m 7sAfter completing this video, you will be able to describe scenarios for using the Query Store. FREE ACCESS
-
3. Monitoring Performance Using Extended Events5m 16sAfter completing this video, you will be able to describe the features, benefits, and architecture of performance monitoring with Extended Events. FREE ACCESS
-
4. Creating an Extended Events Session8m 23sIn this video, you will learn how to create an Extended Events session. FREE ACCESS
-
5. Troubleshooting with Extended Events7m 3sAfter completing this video, you will be able to recognize how Extended Events can be used to troubleshoot performance issues. FREE ACCESS
-
6. SQL Trace6m 10sAfter completing this video, you will be able to describe the features, benefits, and architecture of SQL Server Trace. FREE ACCESS
-
7. Using SQL Trace6m 16sUpon completion of this video, you will be able to describe the uses of SQL Trace. FREE ACCESS
-
8. Identifying Execution Plan Issues7m 26sFind out how to identify issues with execution plans. FREE ACCESS
-
9. Exercise: Monitoring Activity in SQL Server 20165m 27sLearn how to monitor database activity in SQL Server 2016. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
