DMV's in SQL 2005

Question

Post reply

DMV's in SQL 2005

Tony-382973

SSC Enthusiast

Points: 154
More actions
April 10, 2009 at 11:39 am

#129292

Hi,
Where I can find a list of all DMV's in SQL 2005 and, if possible,what they are used for?
Thank you,
T.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

You can get a list with this command:

select * from sys.system_views

See Books OnLine for descriptions.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Have you looked in Books Online? There's a pretty good list in there. Use the index rather than contents and look for anything that starts with sys.dm

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

maechismo_8514 SSCoach Points: 17510 More actions · Answer 3

Tony (4/10/2009)
Hi,
Where I can find a list of all DMV's in SQL 2005 and, if possible,what they are used for?
Thank you,
T.

SQL 2005 ships with over 70 dmv's both documented and undocumented. Why you want to know all at a time? What are you exactly looking for? In addition you can use this:

SELECT * FROM sys.system_views

where name like 'dm%'