DMVs: are they worth the effort?

Question

DMVs: are they worth the effort?

Tony Davis

SSCarpal Tunnel

Points: 4405
More actions
August 23, 2010 at 4:13 pm

#237081

Comments posted to this topic are about the item DMVs: are they worth the effort?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

I was expecting there to at least be a few comments on this one.

I, like you, have found that the DMVs are useful. I find that, despite some of the problems, I can get relative performance information faster and easier through the DMVs in many cases.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

WayneS SSC Guru Points: 95460 More actions · Answer 2

I would have to agree on both counts.

I think this book will be one to buy - we just don't have a lot of information on using the DMVs, and I think that this will be quite useful.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Tony Davis SSCarpal Tunnel Points: 4405 More actions · Answer 3

I don't think my cause was helped by forgetting to take the editorial out of "draft" mode. It meant that until yesterday the editorial wasn't visible and the "discussion" link didn't work. :ermm:

Tony.

ianstirk Ten Centuries Points: 1310 More actions · Answer 4

Hi,

You might also want to look at “SQL Server DMVs in Action”, the first chapter is available free at: www.manning.com/stirk

Thanks

Ian

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Tony Davis (8/25/2010)
I don't think my cause was helped by forgetting to take the editorial out of "draft" mode. It meant that until yesterday the editorial wasn't visible and the "discussion" link didn't work. :ermm:
Tony.

Ouch

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events