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)
 Empty sys.dm_db_missing_index_group_stats

Author  Topic 

gpc44
Starting Member

35 Posts

Posted - 2014-06-05 : 09:49:07
hi,
We have a production server (SQL Server 2005). What can be the reason why this table is empty after a certain time?

SELECT *
FROM sys.dm_db_missing_index_group_stats
--0 Rows--

There is a lot of traffic on this Server / Database. Can it be that a table overflows?
Regards
Nicole

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-06-07 : 02:07:25
There are some known bugs on this DMV - which persisted through to sql server 2008 - and were planned to be fixed by sql server 2012.


Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -