DMVs: are they worth the effort?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » DMVs: are they worth the effort?

DMVs: are they worth the effort?

Rate Topic

Display Mode

Topic Options

Author

Message

Tony Davis

Posted Monday, August 23, 2010 4:13 PM

Mr or Mrs. 500

Group: Administrators
Last Login: Wednesday, May 08, 2013 10:31 AM
Points: 511, Visits: 945

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

Post #973772

SQLRNNR

Posted Tuesday, August 24, 2010 10:54 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732, Visits: 12,329

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 2008

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

WayneS

Posted Tuesday, August 24, 2010 11:06 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:22 PM
Points: 6,367, Visits: 8,225

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

Tony Davis

Posted Wednesday, August 25, 2010 4:01 AM

Mr or Mrs. 500

Group: Administrators
Last Login: Wednesday, May 08, 2013 10:31 AM
Points: 511, Visits: 945

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.

Post #974715

ianstirk

Posted Wednesday, August 25, 2010 8:33 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 1:08 AM
Points: 47, Visits: 761

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

SQLRNNR

Posted Wednesday, August 25, 2010 8:42 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732, Visits: 12,329

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

Post #974908

« Prev Topic | Next Topic »

Permissions