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 » DMVs » monitoring   (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 ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 22, 2010
  • 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
Privacy Statement