I know when you restart SQL Server the statistics are refreshed but what is the command you run to clear them out without a restart? By statistics I mean the type of info these kinds of queries give you...declare @dbid intselect @dbid = db_id()Select dbid=database_id, objectname=object_name(s.object_id), indexname=i.name, i.index_id --, partition_number, row_lock_count, row_lock_wait_count, [block %]=cast (100.0 * row_lock_wait_count / (1 + row_lock_count) as numeric(15,2)), row_lock_wait_in_ms, [avg row lock waits in ms]=cast (1.0 * row_lock_wait_in_ms / (1 + row_lock_wait_count) as numeric(15,2))from sys.dm_db_index_operational_stats (@dbid, NULL, NULL, NULL) s, sys.indexes iwhere objectproperty(s.object_id,'IsUserTable') = 1and i.object_id = s.object_idand i.index_id = s.index_idorder by row_lock_wait_count desc
Clearing out statistical information?
Posted - 2010-01-28 : 19:00:28
