SQL Server DMVs - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server DMVs

Author

Topic

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2009-10-13 : 07:49:29

What would you say are the top 5 DMVs used in SQL Server 2005?

I currently use one at the moment on a regular basis: dm_db_index_physical_stats.

Which other ones are good for general SQL database admin.

Thanks.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-10-13 : 09:04:06

Depends what you're looking for. There's a lot more than 5

Currently executing queries
sys.dm_exec_requests
sys.dm_exec_sessions
sys.dm_exec_sql_text

Cached plans
sys.dm_exec_query_stats
sys.dm_exec_query_plan

Locks
sys.dm_tran_locks

Waits
sys.dm_os_wait_types
sys.dm_os_waiting_tasks

Index stats
sys.dm_db_index_physical_stats
sys.dm_db_index_usage_stats
sys.dm_db_missing_index_details
sys.dm_db_missing_index_groups

All typed from memory, so there may be typos.

--
Gail Shaw
SQL Server MVP

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2009-10-13 : 10:14:27

Many thanks for that!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources