in

SG SQL Server Usergroup

The Premier web platform for Microsoft SQL Server professionals in Singapore

Querying I/O Statistics

Last post 03-22-2008 12:50 AM by Pom. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 03-22-2008 12:50 AM

    • Pom
    • Top 10 Contributor
    • Joined on 01-23-2008
    • Singapore
    • Posts 122

    Querying I/O Statistics

    To view I/O statistics for database and log files, use fn_virtualfilestats.
    The arguments for this function is ([Database ID], [File ID])

    For example:
    To obtain the I/O stats for the TempDB database file the syntax would be

    SELECT * FROM ::fn_virtualfilestats (2, 1)

    To obtain the I/O stats for the TempDB log file the syntax would be

    SELECT * FROM ::fn_virtualfilestats (2, 2)


     

    Pom Figueroa
    http://pomski.spaces.live.com/
    Filed under:
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems