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 » DMVs   (RSS)
Showing page 2 of 9 (83 total posts)
  • Connect Digest : 2011-05-09

    This week we're going to look at some issues involving tempdb... Provide a tempdb per database #176241 : Eliminating TempDb By Adding Temp Filegroup to Each Database#281202 : multiple tempdb For these two requests, I am hoping that the Contained Databases feature (which I've talked about multiple times) will get to this capability in the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 9, 2011
  • Connect Digest : 2011-05-02

    This week, after seeing a lot of the DMV enhancements made in SQL Server 2008 R2 SP1, I thought I would take a look at some dynamic management view/function requests. Page split personality Michael Zilberstein blogged on Monday about how Extended Events and the transaction log differ in the way they report page split information, and that it ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 2, 2011
  • 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
  • More changes you might not have noticed in SQL Server 2008 R2 SP1 CTP

    On Friday, after Microsoft released the CTP, I talked a little bit about the changes you will see in SQL Server 2008 R2 SP1. Namely: new rowcount-related columns in sys.dm_exec_query_stats; extended functionality of the FORCESEEK query hint; a new FORCESCAN query hint; support for 15,000 partitions (to match new ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 25, 2011
  • Capturing the Output (A Month of Activity Monitoring, Part 25 of 30)

    This post is part 25 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. Yesterday’s post was about configuring the output based on what ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 25, 2011
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement