Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DMVs: are they worth the effort? Expand / Collapse
Author
Message
Posted Monday, August 23, 2010 4:13 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: Administrators
Last Login: Today @ 9:53 AM
Points: 569, Visits: 985
Comments posted to this topic are about the item DMVs: are they worth the effort?
Post #973772
Posted Tuesday, August 24, 2010 10:54 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:26 AM
Points: 20,455, Visits: 14,067
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #974307
Posted Tuesday, August 24, 2010 11:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:06 PM
Points: 6,543, Visits: 8,751
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
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, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #974313
Posted Wednesday, August 25, 2010 4:01 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: Administrators
Last Login: Today @ 9:53 AM
Points: 569, Visits: 985
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.

Tony.
Post #974715
Posted Wednesday, August 25, 2010 8:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 3:05 AM
Points: 48, Visits: 833
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
Post #974894
Posted Wednesday, August 25, 2010 8:42 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:26 AM
Points: 20,455, Visits: 14,067
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.

Tony.


Ouch




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #974908
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse