Post reply

How to clear IOSTATS in sys.dm_io_virtual_file_stats?

  • 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!

  • November 7, 2008 at 1:22 am

    #895350

    Hi,

    You should restart the SQL Server instance.

    Grts,

    F;

    Franky L.

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply