• subscribe
January 18, 2005 12:00 AM

Fn_virtualfilestats() Function Reports Reads and Writes

SQL Server Pro
InstantDoc ID #44846

What do the number of reads and writes reported by the fn_virtualfilestats() system function mean?

Fn_virtualfilestats() can be a handy tool for understanding the amount of I/O that's happening within individual files on your SQL Server system. The function reports the data that Table 1 shows. The definitions for NumberReads and NumberWrites seem obvious, however, SQL Server often uses the term read to refer to reading a particular database page. Pages in SQL Server are 8KB, and SQL Server must read an entire extent—a group of 8 pages, 64KB total—to read a single page. The short answer to your question about what the value for NumberReads or NumberWrites measures is that the values are the number of read and write requests issued by SQL Server to the OS. You can't directly infer how much data was read or written for any single request.



ARTICLE TOOLS

Comments
  • CAROLYN
    7 years ago
    Feb 14, 2005

    It would be nice to have a syntax as well. So I went to BOL and found a much better explanation ( suprise!) for that.
    SELECT *
    FROM :: fn_virtualfilestats(1, 1)

You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...