fn_virtualfilestats - Returns negative results

• Leo.Miller

  SSChampion

  Points: 13051

  More actions

  February 16, 2011 at 7:55 pm

  #246883

  I'm analysing some of the IO stats on a SQL 2005 Server and some of the columns returned by fn_virtualFileStats are negative. In particular IoStallWriteMS and IoStallMS for the log file on the busiest database. This seems to implies the field is overflowing which raises two issues: Over flowing a Bigint requires a really big number and seems realtvily unlikely given the server was restarted only 5 days ago. and 2 why doesn't the system get an arithmetic overflow when the coulnm overflows?

  If this isn't what is happening, what is?

  Cheers

  Leo

  Leo
  Nothing in life is ever so complicated that with a little work it can't be made more complicated.

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  February 16, 2011 at 9:20 pm

  #1288035

  Can you use sys.dm_io_virtual_file_stats instead?

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot