SQL Server Performance

Transactions/sec: _Total

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by shark68, Jul 16, 2007.

  1. shark68 New Member

    Hi guys, we do have this threshold defined on the server (Transactions/sec: _Total value > 2000) and every morning i have a message from monitoring system about this error being raised.
    My question is what is this threshold exactly for and what should i check on server?

    Thanks
  2. ghemant Moderator

    Hi,
    In general term "maximum value" = threshold, Transaction/Sec:_Total Value > 2000) means you will get an alert message when transaction value crossed 2000 transaction per second, that means 2000 is the threshold value for transaction. Whenever this threshold value is reached / crossed your monitoring tool sends you an alert.

    Hope this helps.

    Regards

    Hemantgiri S. Goswami
    MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
  3. satya Moderator

    What is the error you get?
    Also check during that alert is generated what kind of transactions & processes are continued in SQL Server, keep the transactions with smaller batches from the queries.

    Some of the useful database counters to collect are:

    -Transactions/sec
    -Log Cache Hit Ratio
    -Log Cache Reads/sec
    -Log Bytes Flushed/sec
    -Log Flush Wait Time
    -Log Flush Waits/sec
    -Log Flushes/sec
    -Percent Log Used
    By collecting this data for all of your databases you can see where the most activity is occurring. Also, by using Performance Monitor you can easily graph out and trend these various counters for each of your databases.

    Also using DMVs you can get such informationhttp://sqlserver-qa.net/blogs/perft...mon-counters-using-a-tsql-query-aka-dmvs.aspx fyi.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  4. shark68 New Member

    Thanks a lot guys

Share This Page