SQLServerCentral / Discuss Content Posted by Christoffer Hedgate / Article Discussions / Article Discussions by Author / Dynamic Management Objects / Latest Posts

RE: Dynamic Management Objects

John Kanagaraj — Thu, 26 Jan 2006 17:08:00 GMT

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/

RE: Dynamic Management Objects

PaulBarbin — Thu, 26 Jan 2006 12:29:00 GMT

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

Dynamic Management Objects

Chris Hedgate — Thu, 05 Jan 2006 11:22:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/chedgate/dynamicmanagementobjects.asp