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 » sp_whoisactive   (RSS)
Showing page 1 of 4 (37 total posts)
  • sp_whoisactive: The Big Fixes!

    Four and a half years have flown by since I released sp_whoisactive version 11.11. It's been a pretty solid and stable release, but a few bug reports and requests have trickled in. I've been thinking about sp_whoisactive v.Next -- a version that will take advantage of some newer SQL Server DMVs and maybe programmability features, but in the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 18, 2016
  • sp_whoisactive for Azure SQL Database - Attempt #2

    Over a year ago now I announced a rough port of sp_whoisactive to Azure SQL Database. This worked thanks to Microsoft finally aligning the Azure DMVs to the box product DMVs...until Microsoft decided to rip out one of the key DMVs, sys.dm_os_sys_info and its ms_ticks column. This column is the key to unlocking various metrics in some of the other ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 14, 2016
  • sp_whoisactive and Azure SQL Database

    I've received a number of requests over the past couple of years for an Azure-specific version of sp_whoisactive. Given the combination of a lack of interesting DMVs available in Azure and my general lack of interest in all things Azure related, creating a modified version of the proc has not exactly been a top priority. Luckily, now I don't have ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 10, 2015
  • Released: Who is Active v11.11

    It's been several months since the last Who is Active fix, so I thought I'd call this one out specifically via a blog post. v11.11 contains a few minor fixes and enhancements, which you can read about on the download page. This will (I believe) be the last release that is compatible with SQL Server 2005 and 2008. v11.xx has been quite a stable ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 22, 2012
  • Twenty Nine Days of Activity Monitoring (A Month of Activity Monitoring, Part 30 of 30)

    This post is part 30 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the Who is Active documentation. Pop quiz: What happens when you promise to write 30 posts on a ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 30, 2011
  • Access for All! (A Month of Activity Monitoring, Part 29 of 30)

    This post is part 29 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the Who is Active documentation. Early in the month I discussed basic security requirements for ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 29, 2011
  • Who is Active's Hidden Gems (A Month of Activity Monitoring, Part 28 of 30)

    This post is part 28 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the Who is Active documentation. Over the past month this series has covered a lot of ground. ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 28, 2011
  • Who is Active v11.00 (A Month of Activity Monitoring, Part 27 of 30)

    This post is part 27 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the Who is Active documentation. Thanks to your feedback over the past month, I’ve managed to ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 27, 2011
  • Who is Active? v11.00

    Who is Active? is a comprehensive server activity stored procedure based on the SQL Server 2005 and 2008 dynamic management views (DMVs). Think of it as sp_who2 on a hefty dose of anabolic steroids. Features supported by Who is Active? include: Server activity collection, including data about currently running T-SQL, server resources ...
    Posted to Release Builds (FileGallery) by adam machanic on April 27, 2011
  • Delta Force (A Month of Activity Monitoring, Part 26 of 30)

    This post is part 26 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the Who is Active documentation. The CPU is pegged. Your hard disks are fried. Memory ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 26, 2011
1 2 3 4 Next >
Privacy Statement