Dynamic Management Objects (DMVs and DMFs) are some of the most useful tools for the DBA. So this month’s question is “Which DMV(s) do you most often use when managing your SQL Server instances, and why?” While the question uses the more generic DMV terminology, go ahead and tell us about your favorite DMVs and DMFs.
Post your responses to the SQL Server Question of the Month in the comments section below (at www.bradmcgehee.com if you are viewing this from a syndicated newsfeed). And don’t forget to enter your e-mail address when you post your response, so I can contact you if you win.
Because there is no right or wrong answer, this month’s winner will be selected randomly from all the entries that are received.
This Month’s Prizes
|The prizes this month are an Amazon.com voucher worth US$50.00, and a license for the new SQL Monitor 3.1, with one year of support and upgrades. SQL Monitor is a web-based monitoring and alerting tool which enables you to keep an eye on SQL server performance in real time on desktop machines and mobile devices. Try out a live demo of SQL Monitor now.|