Post reply

SQL Server Writes response time

  • February 13, 2013 at 2:31 pm

    #270098

    Hi,

    How to get the info on SQL Server Writes response time..

  • February 13, 2013 at 4:03 pm

    #1587676

    Google must be on the fritz again...

    http://www.sqlmag.com/article/business-intelligence/Is-Your-Physical-Disk-I-O-Affecting-SQL-Server-Performance--103703

    When it comes to defining I/O response times related to SQL Server, there are three primary sources of data that you should watch regularly. You obtain two of these—the virtual file and wait stats—directly from SQL Server, and you get the third via the Windows Performance Monitor counters. Individually and especially together, these performance metrics can shed a lot of light on how well your disk subsystem is handling your requests for physical I/O. You just need to know what to look for and where to find it.

    Physical I/O response time is the amount of time (in seconds) that an average read or write request to a physical disk takes to complete. You can get this data easily by using Performance Monitor's Logical or Physical Disk counters for Avg. Disk sec/Read and Avg. Disk sec/Write.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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