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 1234»»»

Performance Monitoring with Dynamic Management Views Expand / Collapse
Author
Message
Posted Thursday, November 17, 2011 12:02 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 3:07 PM
Points: 65, Visits: 331
Comments posted to this topic are about the item Performance Monitoring with Dynamic Management Views
Post #1207258
Posted Thursday, November 17, 2011 12:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 7:11 AM
Points: 48, Visits: 843
Hi,

Very nice article!

Readers can discover a lot more about improving SQL performance via DMVs in this recently published book "SQL Server DMVs in Action" www.manning.com/stirk. It contains more than 100 scripts to identify problems, and offers a wide range of solutions.

Chapters 1 and 3 can be downloaded for free. Chapter 1 includes scripts for:

A simple monitor

Finding your slowest queries

Find your missing indexes

Identifying what SQL is running now

Quickly find a cached plan

Thanks

Ian
Post #1207265
Posted Thursday, November 17, 2011 2:22 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 2:08 PM
Points: 95, Visits: 1,139
Hi Ron,

I tried to take a look into the paper you´ve mentioned (SQL Server Instance Health Monitoring Tool) but it seems that the pdf is broken. It says the data type is incorrectly formatted.


Regards
Dirk


--
May you never suffer the sentiment of spending a day without any purpose.
@DirkHondong on Twitter
Post #1207314
Posted Thursday, November 17, 2011 2:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 6:34 AM
Points: 29, Visits: 356
Good article, although a second one on what the figures mean in the real world would be useful.

BTW the link to the first chapter of the book works fine, but is a bit slow.

Chris
Post #1207321
Posted Thursday, November 17, 2011 5:18 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 10:33 AM
Points: 17,705, Visits: 15,568
Thanks for the article - good stuff.



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 #1207406
Posted Thursday, November 17, 2011 5:27 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 2:08 PM
Points: 95, Visits: 1,139
Hi Ian,

thanks for mentoning the book. It´s now on my wish list
The sample chapters look promising.

Regards
Dirk


--
May you never suffer the sentiment of spending a day without any purpose.
@DirkHondong on Twitter
Post #1207413
Posted Thursday, November 17, 2011 5:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 20, 2013 8:17 AM
Points: 41, Visits: 88

I tried to take a look into the paper you´ve mentioned (SQL Server Instance Health Monitoring Tool) but it seems that the pdf is broken. It says the data type is incorrectly formatted.



yep, pdf is broken
Post #1207419
Posted Thursday, November 17, 2011 6:30 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 6:40 AM
Points: 86, Visits: 241
Everything downloaded fine for me - nice article.

Doug
Post #1207460
Posted Thursday, November 17, 2011 6:44 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 6:40 AM
Points: 86, Visits: 241
Ron,

Where can you download the script manager tool you wrote - that looks like a real neat utility I could use to categorize my scripts.

Thanks,
Doug
Post #1207468
Posted Thursday, November 17, 2011 6:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 20, 2013 8:17 AM
Points: 41, Visits: 88
Hi

I was able to download the file, but I can't open it using acrobat reader, it says that file is not a PDF file...

http://rjssqlservernotes.files.wordpress.com/2011/10/sqlserverinstancehealthmonitor.pdf

BR
P
Post #1207480
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse