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