How to clear IOSTATS in sys.dm_io_virtual_file_stats?

• mycorrado

  SSC Veteran

  Points: 276

  More actions

  October 15, 2008 at 11:53 am

  #194658

  How to clear IOSTATS in sys.dm_io_virtual_file_stats?

  In the old day, dbcc sqlperf(IOSTATS,CLEAR) would work, but seems to have been deprecated..

  Thanks!

• Franky Leeuwerck

  SSCrazy

  Points: 2036

  More actions

  November 7, 2008 at 1:22 am

  #895350

  Hi,

  You should restart the SQL Server instance.

  Grts,

  F;

  Franky L.

• mycorrado

  SSC Veteran

  Points: 276

  More actions

  November 7, 2008 at 8:00 am

  #895567

  True, I was hoping there is another way to do this without clearing the cache, to see runtime I/O loads.