Performance Metrics
SQL Server 2016
| Intermediate
- 12 videos | 1h 10m 21s
- Includes Assessment
- Earns a Badge
SQL Server 2016 provides a comprehensive set of tools for monitoring and tuning to ensure optimal performance. Examine performance metrics and monitoring, and the various logging tools available with SQL Server.
WHAT YOU WILL LEARN
-
Describe performance metricsEstablish a server performance baselineDemonstrate how to use perfmonDemonstrate how to use dynamic management objectsCompare baseline metrics to observed metrics in order to troubleshoot performance issuesMonitor azure sql database performance
-
Demonstrate how to enable and view live query statisticsUse the activity monitor in sql server 2016Demonstrate how to use the task manager windows monitoring toolDemonstrate how execute database consistency checker commandsUse system stored procedures for monitoring tasksUsing various tools to monitor performance
IN THIS COURSE
-
5m 51sAfter watching this video, you will be able to describe performance metrics. FREE ACCESS
-
3m 38sIn this video, you will learn how to establish a server performance baseline. FREE ACCESS
-
7m 51sIn this video, you will learn how to use Performance Monitor. FREE ACCESS
-
6m 55sIn this video, you will learn how to use dynamic management objects. FREE ACCESS
-
6mLearn how to compare baseline metrics to observed metrics in order to troubleshoot performance issues. FREE ACCESS
-
6m 55sLearn how to monitor performance of Azure SQL Database. FREE ACCESS
-
4m 38sIn this video, you will learn how to enable and view live query statistics. FREE ACCESS
-
6m 57sTo find out how to use the activity monitor in SQL Server 2016, consult the documentation or ask a qualified person. FREE ACCESS
-
3m 21sIn this video, you will learn how to use the task manager windows monitoring tool. FREE ACCESS
-
6m 19sIn this video, you will learn how to execute database consistency checker commands. FREE ACCESS
-
5m 41sLearn how to use system stored procedures for monitoring purposes. FREE ACCESS
-
6m 17sDuring this video, you will learn how to use various tools to monitor performance. 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.YOU MIGHT ALSO LIKE
Channel
Database Performance Tuning