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 metrics
establish a server performance baseline
demonstrate how to use perfmon
demonstrate how to use dynamic management objects
compare baseline metrics to observed metrics in order to troubleshoot performance issues
monitor Azure SQL Database performance -
demonstrate how to enable and view live query statistics
use the activity monitor in SQL Server 2016
demonstrate how to use the task manager windows monitoring tool
demonstrate how execute database consistency checker commands
use system stored procedures for monitoring tasks
using 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.
