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

What are DMV? Can some one teach me with examples. Expand / Collapse
Author
Message
Posted Wednesday, April 23, 2014 7:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 3:42 PM
Points: 13, Visits: 72
HI I want to find how to use DMV and when to use them?
Post #1564489
Posted Wednesday, April 23, 2014 7:30 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:28 PM
Points: 4,611, Visits: 4,067
DMVs are dynamic management views. They're a collection of views and functions that provide access to internal information about your SQL Server. They're very useful in determining what's going on in your instance.

The are lots of them for many different purposes. The MS page is at http://technet.microsoft.com/en-us/library/ms188754.aspx. It breaks them up into categories and then gives specifics about each one.

If you prefer a more graphical format, Tim Ford has a cool "Periodic Table of DMVs" he's posted at http://thesqlagentman.com/periodic-table/. It doesn't have the detail, but is useful once you get familiar with them.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1564490
Posted Thursday, April 24, 2014 2:08 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:22 AM
Points: 14,205, Visits: 28,534
Start with the Microsoft documentation. Always start with the Microsoft documentation. But, there are also 3rd party resources such as Tim Ford and Louis Davidson's excellent book.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1564868
Posted Friday, April 25, 2014 5:57 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:28 PM
Points: 4,611, Visits: 4,067
Grant Fritchey (4/24/2014)
Start with the Microsoft documentation. Always start with the Microsoft documentation. But, there are also 3rd party resources such as Tim Ford and Louis Davidson's excellent book.
Thanks for the book reference, Grant. I didn't know about it, but I have it downloaded now. Time to read my next book.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1565036
Posted Friday, April 25, 2014 6:56 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:22 AM
Points: 14,205, Visits: 28,534
Excellent! Happy to share.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1565072
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse