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 » SQL Server 2008 » Dynamic Management Views   (RSS)
  • Pushing for more disclosure in DMVs

    I have been involved in several discussions over the past week involving getting more diagnostic information out of the DMVs in SQL Server 2008 and beyond. Yesterday, I asked for procedure recompiles to be tracked in the new sys.dm_exec_procedure_stats DMV: http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=388218 Today, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 16, 2008
  • When was my database / table last accessed?

    A frequently asked question that surfaced again today is, ''how do I see when my data has been accessed last?''  SQL Server does not track this information for you.  SELECT triggers still do not exist.  Third party tools are expensive and can incur unexpected overhead.  And people continue to be reluctant or unable to constrain ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 6, 2008
  • 46 New Dynamic Management Views In SQL Server 2008 CTP6

    Remember the 33 new DMVs in SQL Server 2008 post? I was just poking around in SQL Server 2008  CTP6 and wanted to know if there were any new Dynamic Management Views since CTP5. There are 13 new DMVs in CTP6 and there are a total of 46 new Dynamic Management Views compared to SQL server 2005. The list of them is below, I think their ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on February 21, 2008
  • 16 Changed Dynamic Management Views in SQL Server 2008

    Yesterday Denis Gobo told you about 33 new DMVs in SQL Server 2008; previously, I had noticed that a few of the existing DMVs from 2005 had changed slightly.  So, Denis sparked my curiosity, and I ran the following query on a recent build of SQL Server 2008, which had a linked server pointing to SQL Server 2005: SELECT s1.vn, s1.cn ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 7, 2008
  • 33 New Dynamic Management Views In SQL Server 2008

    I was just poking around in SQL Server 2008 and wanted to know if there were any new Dynamic Management Views. There are a total of 33 new Dynamic Management Views. The list of them is below, I think their names make clear what the dmv is supposed to do (or at least I think I ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on February 6, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement