selectstarfromyogi

sql server DBA ,sql server 2008 , 2012 , 2014 ,sql

Menu
Search
Skip to content
  • Home
  • About

dmv

10 most useful DMVs for DBA’s in SQL Server

1) sys.dm_exec_requests
2) sys.dm_exec_connections
3) sys.dm_exec_sessions
4) sys.dm_io_virtual_file_stats
5) sys.dm_db_index_usage_stats
6) sys.dm_db_index_Physical_stats
7) sys.dm_db_missing_index_details
8) sys.dm_os_schedulers
9) sys.dm_os_wait_stats
10) sys.dm_exec_sql_text(sql_handle)

December 3, 2015yogigollapudi dmv, dmvs, SQL Server 1 Comment

Categories

  • DEVOps (1)
  • Errors (9)
  • FUN (1)
  • Performance Tuning (11)
  • powershell (12)
  • T-SQL (43)
  • Uncategorized (154)

Blog Stats

  • 39,568 hits
Follow selectstarfromyogi on WordPress.com
Blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • selectstarfromyogi
    • Already have a WordPress.com account? Log in now.
    • selectstarfromyogi
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
Design a site like this with WordPress.com
Get started