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

Dynamic Management Objects Expand / Collapse
Author
Message
Posted Thursday, January 5, 2006 11:22 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Saturday, February 28, 2009 6:51 AM
Points: 1,489, Visits: 7
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/chedgate/dynamicmanagementobjects.asp



--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/
Post #248564
Posted Thursday, January 26, 2006 12:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 16, 2008 10:10 AM
Points: 13, Visits: 15
THANK YOU MICROSOFT!
I can't wait to dig into the other views and functions to see what they can provide, but just seeing the queryplan that is in action is a BIG deal.

Also its great the plan is in XML so it can be parsed!

Paul



Post #253880
Posted Thursday, January 26, 2006 5:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 3, 2009 5:41 PM
Points: 10, Visits: 12

Hi all,

This is an extremely important set of views and objects that really opens up what is going on in the inside of SS, and MS has *finally* taken this very welcome step to allow us to look at this info easily. Btw, Oracle has had this functionality for a very long time - these were called "V$" performance views and were around since V7. I (and most Oracle DBAs as well) regularly use these to quickly determine issues in Oracle. In fact so many books have been written about this, I have lost count!

I mention all of this to say that we are possibly at the cusp of really being able to break into this black box of MS performance, and hence I am excited!

Regards to all,

John Kanagaraj <><

DB Soft Inc

Co-Author: Oracle Database 10g Insider Solutions http://www.amazon.com/exec/obidos/tg/detail/-/0672327910/

Post #253934
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse