Sunday, April 24, 2016

DMV Queries From my Pluralsight Course "What Every Developer Should Know About SQL Server Performance"

I've actually broken these queries up into separate blog posts, so here are the links to the individual posts where you will find the queries.

Exposing SQL Server DMV Data to Developers and other non-DBA Users

Using DMV's to Find SQL Server Connection and Session Info

Which Statements Are Currently Running in my SQL Server Database

Finding the Most Expensive, Longest Running Queries in SQL Server

Analyzing Index Usage in SQL Server
(Contains queries for both missing indexes and index usage stats)

5 comments:

  1. I agree, your course was one of the best I have seen in a long time.

    ReplyDelete
  2. Excellent Blog
    Thank you for sharing this post. I wonder to visit your Blog and to gain informative knowledge.
    mobile app training institutes
    iphone training institute in bangalore

    ReplyDelete
  3. My suggestion would be to make url easy to open from pdf files. As of now I had a big challenge for opening proper url

    ReplyDelete