We are running SQL Server 2008 64 bit Enterprise, Service Pack 1, Cumulative 7, Version 10.0.2766.
We do about 10 million transactions a day over16 servers and 900 databases, with each database having about 400 tables and about 600 stored procedures.
I run a stored procedure daily to gather index analaysis statistics and recently noticed that sys.dm_db_missing_index_group_stats has no records in about 700 of the 900 databases, and these servers have not had a service restart for over 3 months, some have been up for over 6 months.
For instance when I execute the following two statements on a database:
SELECT * FROM sys.dm_db_missing_index_group_stats --Returns 0 records
SELECT * FROM sys.dm_db_missing_index_groups --Returns 600 records
I have seen FIX 969844 [http://support.microsoft.com/kb/969844]
and some of the symptoms apply, but not all. Also, according to the fix, since we are running SQL Server 2008 SP1 CU7, it should be fixed.
We do not use any start up parameters that would disable the gathering of index stats.
I am wondering if this seems strange? Any ideas on what might be the issue if it does seem strange?