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 |
|
ThreePea
Yak Posting Veteran
83 Posts |
 Posted - 2006-01-04 : 11:29:44
|
| Hey Everyone,The SQLServer:Databases perfmon counter has two transaction-related counters:Active Transactions: Number of active transactions for the database.Transactions/sec: Number of transactions started for the database per second.Those definitions make sense on a very superficial level, but I'm having trouble understanding what that means in real life. For instance, we are currently running at 1500 Transactions / sec, but only 1-2 Active Transactions.How can we be starting 1500 transactions per second but only have 1 or 2 active at any given time? Unless the word "transactions" means something different to each counter.Any insight would be appreciated. Thanks.3P |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-01-04 : 11:50:39
|
| HiI might be wrong about this but if your clients are connected to your db, aren't you going to pick them under "Transactions /sec" even if they are Dormant and if they are Active then they fall under "Active Transactions"?RegardsNIf you want your computer to be faster then throw it out of the window. |
 |
|
|
|
|
|
Difference between Transactions counter