MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server 2014 DMV Diagnostic Queries - Part 1

Course Summary

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


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ How can you Find Performance Problems?
        ◦ DMV Queries to the Rescue!
        ◦ DMV Diagnostic Query History
        ◦ Why use DMV Diagnostic Queries?
        ◦ Diagnostic and Corrective Process
        ◦ Instance-Level Configuration Queries
        ◦ Summary
        ◦ Course Structure
    ● Instance-Level Configuration Queries Part 1
        ◦ Introduction
        ◦ Getting the Product Version
        ◦ Demo: Getting the Product Version
        ◦ When Was SQL Server Installed?
        ◦ Demo: When Was SQL Server Installed?
        ◦ Getting Useful Server Properties
        ◦ Demo: Getting Useful Server Properties
        ◦ Getting SQL Server Agent Job Information
        ◦ Demo: Getting SQL Server Agent Job Information
        ◦ Getting SQL Server Agent Alert Information
        ◦ Demo: Getting SQL Server Agent Alert Information
        ◦ Global Trace Flag Information
        ◦ Demo: Global Trace Flag Information
        ◦ Getting Information About Windows
        ◦ Demo: Getting Information About Windows
        ◦ SQL Server Services Information
        ◦ Demo: SQL Server Services Information
        ◦ SQL Server NUMA Node Information
        ◦ Demo: SQL Server NUMA Node Information
        ◦ Getting Hardware Information
        ◦ Demo: Getting Hardware Information
        ◦ Getting the Server Model Number
        ◦ Demo: Getting the Server Model Number
        ◦ Getting the Processor Description
        ◦ Demo: Getting the Processor Description
        ◦ Summary and What is Next
    ● Instance-Level Configuration Queries Part 2
        ◦ Introduction
        ◦ SQL Server Failover Cluster Log Properties
        ◦ Demo: SQL Server Failover Cluster Log Properties
        ◦ OS Cluster Properties
        ◦ Demo: OS Cluster Properties
        ◦ Cluster Node Properties
        ◦ Demo: Cluster Node Properties
        ◦ Failover Cluster Node with AlwaysOn AG
        ◦ Demo: Failover Cluster Node with AlwaysOn AG
        ◦ Instance Configuration Values
        ◦ Demo: Instance Configuration Values
        ◦ Buffer Pool Extension Properties
        ◦ Demo: Buffer Pool Extension Properties
        ◦ Buffer Pool Extension Usage
        ◦ Demo: Buffer Pool Extension Usage
        ◦ TCP Listener States
        ◦ Demo: TCP Listener States
        ◦ Memory Dump Information
        ◦ Demo: Memory Dump Information
        ◦ Database Filenames and Paths
        ◦ Demo: Database Filenames and Paths
        ◦ Volume Information
        ◦ Demo: Volume Information
        ◦ Course Summary

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top