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 |
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
 Posted - 2003-03-28 : 16:23:31
|
| I have Performance monitor up on one of my SQL Servers. It's showing 4,000,000,000 some active transactions. It will occasionally drop to between 0 and 100 then shoot back up again.When I run perf monitor against other servers it looks fine. Also, I know this can't be the case because my server resources would be pegged with that many transactions and I'm maintaining at 60-80 percent. Anybody got any ideas????Derrick Leggettderrick_leggett@hotmail.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-28 : 16:32:07
|
| Well 60-80 percent utilization is a little high. I typically like to keep it under 40 if possible.What Performance Monitor counter are you tracking? Have you looked at SQL Profiler to determine what is happening on the SQL Server?Tara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2003-03-28 : 17:02:07
|
| The utilization is unfortunately normal on this box. There is nothing going on with sql server. The active transactions for the individual databases are fine. It's the total tranactions that are messed up. Some how the total transactions counter for the for server is posting incorrect information. Each individual db is showing up fine.Derrick Leggettderrick_leggett@hotmail.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-28 : 17:12:27
|
| Doesn't the active transactions also include everything that the system is doing such as in msdb? If that's true, then maybe the reason why it goes down to a small number is that maybe the number of transactions is hitting some limit such as the limit for bigint or whatever data type it is using.TaraEdited by - tduggan on 03/28/2003 17:14:23 |
|
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2003-03-29 : 18:55:00
|
| 4 Billion sounds suspiciously like an unsigned int rounding error; for unsigned ints, -1 = 4,294,967,296. Not sure what to point to, but it's something to think about.-b |
|
|
|
|
|
|
Unbelievable Active Transactions