THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance » DMVs   (RSS)
  • A Warning to Those Using sys.dm_exec_query_stats

    The sys.dm_exec_query_stats view is one of my favorite DMVs. It has replaced a large chunk of what I used to use SQL Trace for--pulling metrics about what queries are running and how often--and it makes this kind of data collection painless and automatic. What's not to love? But use cases for the view are a topic for another post. Today I want to ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 22, 2010
  • Who is Active? v9.57: Fast, Comprehensive DMV Collection - What's Really Happening on Your Server?

     UPDATE, April 28 2011: Who is Active v9.57 is outdated. Please use v11.00 instead.     Happy December, SQLblog readers! My gift to you, just in time for the holidays: The newest ''official'' release of your favorite SQL Server activity monitoring stored procedure.   Click here to download Who is Active? ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on December 3, 2009
  • The Hidden Costs of INSERT EXEC

    INSERT and EXEC: relational brothers in arms, helping you get your data and then put it somewhere. But like all brothers, their relationship has its ups and downs and sometimes you need to look just below the surface to see the real issues. In this post I will cover hidden penalties that a decision--seemingly purely aesthetic--can bring to ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 25, 2009
  • A Gift of Script for 2009: Who is Active, Redux

    Last year on December 31 I posted part of a larger monitoring script that I had been working on for a few months. I received lots of great feedback on the little script in both the comments and from people I was working with, and over the course of the last year I estimate that I have invested at least a couple of hundred hours in the script. The ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on December 31, 2008
Privacy Statement