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 |
|
Shadi85
Starting Member
1 Post |
 Posted - 2012-03-11 : 05:20:08
|
| Hi,My monitoring tool is showing alarms with description: # of active transactions for the entire server (44.00) is too high (>=5.00)I have 2 questions: 1- What does this mean? Is there transactions that are not ending (awaiting command for example)??2- is the threshold (5.00) good or needs to be modified?Thank you |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-11 : 13:42:49
|
| What is this monitoring tool?Can't say for sure. Don't know if they mean explicit transactions or just active CRUD operations.What's the result of DBCC OPENTRAN()Are you experiencing performance issues? |
 |
|
|
|
|
|
Number of active transactions