Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-05 : 08:23:18
|
| Shaili writes "Hi,I have defined an alert on my production server that monitors transaction/sec value for the main production database. I am notified if the value have risen above 10000 transactions/sec.Since yesterday, I have been getting this emails every 5 minutes that the value is above 10000 trans/sec. The surprising thing is that in every email the value is increasing constantly. It started with 10000. Right now the email shows currect value over 30000. Does this counter show the accumulated value since the database server is rebooted? or something is wrong with my server?Also, where can I get detailed information about this performance monitoring for sql server?I have performance Monitor on 24 hrs to show me the transaction/sec counter for the production database in question. Somehow the value in this NT performance monitor haven't gone beyond 2.36 with current average showing as .122. I am still getting emails from sql server Alert engine : here is the last one:DESCRIPTION: The SQL Server performance counter 'Transactions/sec' (instance 'ProdOrders') of object 'SQLServer:Databases' is now above the threshold of 10000.00 (the current value is 32564.00).Why is this descrepency in NT monitor and sql server Alert reading? Is there any calculation that I am missing here?Thanks,Shaili" |
|
|
|
|
|
Transactions/sec counter for monitoring database activities