Post reply

Sql Server Stats from sys.dm_exec_sessions

  • October 6, 2010 at 1:30 pm

    #224818

    Hi,

    I need to get the following for one of our active servers and the results from perfmon are just not doing it for me. Can anyone please help? Thanks.

    Reads

    Writes

    Reads and writes Size(in blocks)

    Reads to writes ratio

  • October 7, 2010 at 6:42 am

    #1233477

    Basically, I'd rely on perfmon for those metrics. It's should be gathering what you need.

    The real question is, what are you trying to figure out? What's happening on the server that makes you think you need to focus on the I/O?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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