SQL Server Performance Forum – Threads Archive
Transactions/sec: _Total
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
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
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.
Thanks a lot guys
]]>