Monthly Archives: April 2015 - Page 23

How do you clear DMVs information

2 ways:

    Restart SQL server
    DBCC SQLPERF (‘sys.dm_db_index_usage_stats’, clear)