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

Learn how to easily query SQL Server for instance configuration information to help identify misconfigurations that can affect performance. This course is applicable to anyone who is responsible for a SQL Server instance, with most topics also applicable to SQL Server 2012 and earlier versions.


  • +

    Course Syllabus

    Introduction
    - 11m 1s

    —Introduction 1m 26s
    —How can you Find Performance Problems? 2m 20s
    —DMV Queries to the Rescue! 1m 28s
    —DMV Diagnostic Query History 1m 30s
    —Why use DMV Diagnostic Queries? 1m 0s
    —Diagnostic and Corrective Process 1m 4s
    —Instance-Level Configuration Queries 0m 52s
    —Summary 0m 41s
    —Course Structure 0m 36s
    Instance-Level Configuration Queries Part 1
    - 31m 2s

    —Introduction 1m 2s
    —Getting the Product Version 1m 58s
    —Demo: Getting the Product Version 1m 44s
    —When Was SQL Server Installed? 0m 43s
    —Demo: When Was SQL Server Installed? 0m 47s
    —Getting Useful Server Properties 0m 57s
    —Demo: Getting Useful Server Properties 1m 8s
    —Getting SQL Server Agent Job Information 0m 51s
    —Demo: Getting SQL Server Agent Job Information 1m 23s
    —Getting SQL Server Agent Alert Information 1m 31s
    —Demo: Getting SQL Server Agent Alert Information 1m 16s
    —Global Trace Flag Information 1m 35s
    —Demo: Global Trace Flag Information 0m 53s
    —Getting Information About Windows 0m 43s
    —Demo: Getting Information About Windows 1m 44s
    —SQL Server Services Information 0m 50s
    —Demo: SQL Server Services Information 1m 9s
    —SQL Server NUMA Node Information 0m 54s
    —Demo: SQL Server NUMA Node Information 1m 20s
    —Getting Hardware Information 1m 25s
    —Demo: Getting Hardware Information 1m 44s
    —Getting the Server Model Number 1m 10s
    —Demo: Getting the Server Model Number 1m 0s
    —Getting the Processor Description 0m 54s
    —Demo: Getting the Processor Description 0m 51s
    —Summary and What is Next 1m 16s
    Instance-Level Configuration Queries Part 2
    - 25m 45s


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