2010. 7. 16. 17:33
Brain Trainning/DataBase
Categories of DMOs
The DMOs are divided into different categories and named accordingly to be easy to find and distinguish. All DMO names start with the prefix dm_ (no difference between DMVs and DMFs). Next follows a prefix identifying the category a DMO belongs to. For instance, the prefix dm_io_ is used for dynamic management objects that return information regarding disk and network I/O. Another category is dm_clr_ which is used for DMOs that return information regarding the hosting of the CLR (.NET Common Language Runtime) in SQL Server. Below is a listing of the complete set of categories of dynamic management objects.
- dm_broker_* - Service Broker
- dm_clr_* - Common Language Runtime
- dm_db_* - Database related
- dm_db_index_* - Indexes
- dm_db_mirroring_* - Database mirroring
- dm_exec_* - Execution
- dm_fts_* - Full-Text Search
- dm_io_* - I/O
- dm_os_* - SQL Operating System (SQLOS)
- dm_qn_* - Query Notification
- dm_repl_* - Replication
- dm_tran_* - Transactions
'Brain Trainning > DataBase' 카테고리의 다른 글
디스크공간 / 여유공간 (0) | 2010.07.18 |
---|---|
디스크 여유공간 체크 및 메일보내기~ (0) | 2010.07.18 |
SQL Server 2005 DBCC Command Quick Reference (0) | 2010.07.16 |
Top 10 SQL Server 2008 Features for ISV Applications (1) | 2010.07.14 |
SQL Server 2008 T-SQL Enhancements (0) | 2010.07.14 |