locked
Physical reads/sec RRS feed

  • Question

  • Hi

    In sql server system tables, they have given physical reads/sec,logical reada/sec and logical write/sec interms of numbers.But they have given threshold interms of secs.I would like to set threshold for physical reads/sec.logical reads/sec and logical write/sec interms of number.If you have any idea about setting threshold for above mention columns,please get back me.I dont have idea about that.Thank you

    with regards

     selva

    Tuesday, December 18, 2012 3:46 AM

Answers

  • Hi selva1587,

    First, I want to confirm whether you are talking about Physical Reads/sec, Logical Writes/sec, Logical Reads/sec in SQL Server Activity Monitor. These values stand for the rate per second of action (read, write) by the query, we can select all values to check all the queries according to the values (or one special value to check the queries according to this value), they are not threshold. The information is derived from the union of sys.dm_exec_requests and sys.dm_exec_query_stats, and includes queries in process and queries that finished during the time period. You can also get all data from these DMVs and aggregate them to get the data you want. For more detail information, please refer to the following link:

    Activity Monitor:
    http://msdn.microsoft.com/en-us/library/cc879320(v=sql.105).aspx

    sys.dm_exec_requests (Transact-SQL):
    http://msdn.microsoft.com/en-us/library/ms177648.aspx

    sys.dm_exec_query_stats (Transact-SQL):
    http://msdn.microsoft.com/en-us/library/ms189741.aspx


    Allen Li
    TechNet Community Support

    Wednesday, December 19, 2012 2:51 AM