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
-
1.Performance Metrics5m 51sUP NEXT
-
2.Performance Baseline3m 38s
-
3.Performance Monitor7m 51s
-
4.Dynamic Management Objects6m 55s
-
5.Troubleshooting Performance Issues6m
-
6.Azure SQL Database Performance6m 55s
-
7.Live Query Statistics4m 38s
-
8.Activity Monitor6m 57s
-
9.Task Manager3m 21s
-
10.DBCC Commands6m 19s
-
11.System Stored Procedures5m 41s
-
12.Exercise: Monitor Performance Using Monitoring Tools6m 17s
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.