Pluralsight SQL Server 2014 DMV Diagnostic Queries Part 1
It is very common for SQL Server instances to be configured incorrectly in one or more ways, and this often has a detrimental effect on workload performance. This course will describe and demonstrate more than 20 DMV queries you can use to easily examine SQL Server instance configuration information and identify problems. This course is perfect for anyone who is responsible for a SQL Server instance, with most topics also applicable to SQL Server 2012 and earlier versions.
 Introduction | 00:11:01 |
| Introduction | 01:26 |
| How can you Find Performance Problems? | 02:20 |
| DMV Queries to the Rescue! | 01:28 |
| DMV Diagnostic Query History | 01:30 |
| Why use DMV Diagnostic Queries? | 01:00 |
| Diagnostic and Corrective Process | 01:04 |
| Instance-Level Configuration Queries | 00:52 |
| Summary | 00:41 |
| Course Structure | 00:36 |
 Instance-Level Configuration Queries Part 1 | 00:31:02 |
| Introduction | 01:02 |
| Getting the Product Version | 01:58 |
| Demo: Getting the Product Version | 01:44 |
| When Was SQL Server Installed? | 00:43 |
| Demo: When Was SQL Server Installed? | 00:47 |
| Getting Useful Server Properties | 00:57 |
| Demo: Getting Useful Server Properties | 01:08 |
| Getting SQL Server Agent Job Information | 00:51 |
| Demo: Getting SQL Server Agent Job Information | 01:23 |
| Getting SQL Server Agent Alert Information | 01:31 |
| Demo: Getting SQL Server Agent Alert Information | 01:16 |
| Global Trace Flag Information | 01:35 |
| Demo: Global Trace Flag Information | 00:53 |
| Getting Information About Windows | 00:43 |
| Demo: Getting Information About Windows | 01:44 |
| SQL Server Services Information | 00:50 |
| Demo: SQL Server Services Information | 01:09 |
| SQL Server NUMA Node Information | 00:54 |
| Demo: SQL Server NUMA Node Information | 01:20 |
| Getting Hardware Information | 01:25 |
| Demo: Getting Hardware Information | 01:44 |
| Getting the Server Model Number | 01:10 |
| Demo: Getting the Server Model Number | 01:00 |
| Getting the Processor Description | 00:54 |
| Demo: Getting the Processor Description | 00:51 |
| Summary and What is Next | 01:16 |
| Instance-Level Configuration Queries Part 2 | 00:25:45 |
| Introduction | 00:49 |
| SQL Server Failover Cluster Log Properties | 00:45 |
| Demo: SQL Server Failover Cluster Log Properties | 00:57 |
| OS Cluster Properties | 00:50 |
| Demo: OS Cluster Properties | 00:29 |
| Cluster Node Properties | 00:44 |
| Demo: Cluster Node Properties | 00:45 |
| Failover Cluster Node with AlwaysOn AG | 00:56 |
| Demo: Failover Cluster Node with AlwaysOn AG | 00:39 |
| Instance Configuration Values | 00:56 |
| Demo: Instance Configuration Values | 02:39 |
| Buffer Pool Extension Properties | 01:18 |
| Demo: Buffer Pool Extension Properties | 01:36 |
| Buffer Pool Extension Usage | 01:03 |
| Demo: Buffer Pool Extension Usage | 01:04 |
| TCP Listener States | 00:45 |
| Demo: TCP Listener States | 00:52 |
| Memory Dump Information | 00:59 |
| Demo: Memory Dump Information | 00:48 |
| Database Filenames and Paths | 00:58 |
| Demo: Database Filenames and Paths | 02:13 |
| Volume Information | 01:12 |
| Demo: Volume Information | 01:21 |
| Course Summary | 00:58 |