THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » monitoring » DMVs   (RSS)
  • Your Transaction is in Jeopardy -- and You Can't Even Know It!

    If you're reading this, please take one minute out of your day and vote for the following Connect item: https://connect.microsoft.com/SQLServer/feedback/details/444030/sys-dm-tran-active-transactions-transaction-state-not-updated-when-an-attention-event-occurs If you're really interested, take three minutes: run the steps to reproduce the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 26, 2012
  • 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
  • Who is Active? v8.82 - Harder, Better, Faster, Stronger

    I've had a lot of great feedback since my last ''official'' Who is Active? release--v8.40, back in March--and since then I've made 42 distinct changes, bringing us all the way to v8.82. My versioning scheme is quite simple: one change, one increment, with occasional numbers skipped or major version incrementation if I do a really major change. ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on August 20, 2009
  • Working with SQLFool's Index Defrag Script

    Last week I decided to play with SQLFool's Automated Index Defrag Script and found it very usable and worthwhile.  Terrific work Michelle!  The script rivals Ola Hallengren's broader maintenance scripts that I use often. On smaller databases it ran quite quickly and with the correct and desired effects.  On larger databases, due to ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 13, 2009
  • Who is Active? v8.40 - Now With Delta Power!

    NOTE: v8.40 is outdated at this time. Please try v9.57, which you can find here.   It has been only a month and a half since I posted the last version of Who is Active? (v7.30), but in that time I've made a huge number of changes, fixes, and enhancements. The new version, v8.40, is faster, more robust, and includes a few exciting ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 30, 2009
  • Who is Active? v7.30

    Who is Active? is a comprehensive DMV-based monitoring script, designed to tell you at a glance what processes are active on your SQL Server and what they're up to. It has a number of optional features so that you can get results quickly, or monitor deeply, depending on your needs when you happen to be using the script. Today I'm happy to present ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on February 18, 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement