آموزش DMV در sql server 2014

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. Topics: Pluralsight SQL Server 2014 DMV Diagnostic Queries Part 1 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 Pluralsight SQL Server 2014 DMV Diagnostic Queries Part 1Instance-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 Pluralsight SQL Server 2014 DMV Diagnostic Queries Part 1Instance-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