Post reply

Physical IO reads and writes on database using SQL query

  • December 7, 2010 at 3:56 am

    #242168

    Dear All,

    Can some one please advise on the below.

    How to find Physical IO reads and writes on database using SQL query? as I want to know how many reads and writes operations are happening on particular database rather than running SQLProfiler/Perfmon.

    Thanks and Regards,

    Ravichandra.

  • December 7, 2010 at 3:58 am

    #1259450

    For an individual query - SET Statistics IO on

    Won't tell you writes. You'll need profiler for that, and those are logical writes (to memory)

    For the DB as a while, sys.dm_io_virtual_file_stats.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 7, 2010 at 4:58 am

    #1259463

    Thanks GailShaw !!

    Can you suggest me on the below please

    http://www.sqlservercentral.com/Forums/Topic1030483-146-1.aspx

    Regards,

    Ravichandra.

  • December 7, 2010 at 5:46 am

    #1259478

    I answer questions that I know the answers to and have time to answer. If I haven't answered a question it means either I don't have an answer or I don't have the time. Nagging is not going to change either of those.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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