List of all SQL Server DMVs & System Objects
As you probably already know, SQL Server has many DMVs (Dynamic Management Views) and System Objects that helps DBAs, these include performance counters, index statistics, resource locking information, user object IDs and many more.
A few years back I found this nice script that returns a list of all the SQL Server system objects columns, and also adds a link to msdn for a description of the object, really handy if you want to quickly look-up a particular DMV (say filter by CPU relevant DMVs).
SELECT
SCHEMA_NAME(SCHEMA_ID)+ '.' + o.Name AS SysObjName,
o.type_desc,
c.name AS ColumnName,
'http://social.msdn.microsoft.com/Search/en-US/?Refinement=117&Query=' + SCHEMA_NAME(SCHEMA_ID)+ '.' + o.Name AS [Help!]
FROM
sys.system_columns c
INNER JOIN sys.system_objects o ON o.object_id=c.object_id
--WHERE
--c.name LIKE '%cpu%'
SCHEMA_NAME(SCHEMA_ID)+ '.' + o.Name AS SysObjName,
o.type_desc,
c.name AS ColumnName,
'http://social.msdn.microsoft.com/Search/en-US/?Refinement=117&Query=' + SCHEMA_NAME(SCHEMA_ID)+ '.' + o.Name AS [Help!]
FROM
sys.system_columns c
INNER JOIN sys.system_objects o ON o.object_id=c.object_id
--WHERE
--c.name LIKE '%cpu%'
TIP:
You can quickly browse the Help URLs in SQL Server, by selecting the link in the returned data-set, and holding Ctrl + ALT + R. this will open the link in SSMS.
0 votes
Leave a Reply
Want to join the discussion?Feel free to contribute!