An Introduction to Dynamic Management Views and Functions in SQL Server 2005By : Brad McGeheeFeb 08, 2007 One my most favorite features of SQL Server......
sys.dm_db_missing_index_group_stats
sys.dm_db_missing_index_groups
While the name of the DMV or DMF is somewhat useful when figuring out what information they provide, you will find yourself looking these up in Books Online, or just experimenting by trail and error, to find out what information they can provide you.
Summary
DMVs and DMFs, along with data provided by Management Studio, System Monitor, and Profiler, provide DBAs with a wealth of information they can use to troubleshoot and correct SQL Server performance problems, in addition to many other SQL Server-related problems. If you have not yet done so, take some time and look up the more interesting DMVs and DMFs in Books Online and give them a try.
3/3 首页 上一页 1 2 3 |
