Tuesday, March 20, 2012

Active transaction count...

I have been monitoring the number of active transactions on my server.
Since I am the only one on it fluctates generally between 0 and 4 depending
on what I am doing and what programs are running against it.
I have noticed a couple of times that the number of transactions has gone to
a whopping 4294967295 (2^32 - 1). Is this a bug with SQL Server 2000 SP3?
Or is this a problem with Performance monitor? Does it only affect the
number of active transactions or should I treat all of the other stats with
a grain of salt?
Regards
Dave AHi
When a counter is collected at a critical moment, the numbers it produces
may not be 100% correct. SQL Server shows it now and again, but I've seen
funny numbers come out of Sybase and Oracle too.
It is usually just that specific sample that is at an extreme, so disregard
it.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave A" <dave@.sigmasolutionsdonotspamme.com.au> wrote in message
news:uhYJjheOFHA.624@.TK2MSFTNGP10.phx.gbl...
>I have been monitoring the number of active transactions on my server.
> Since I am the only one on it fluctates generally between 0 and 4
> depending
> on what I am doing and what programs are running against it.
> I have noticed a couple of times that the number of transactions has gone
> to
> a whopping 4294967295 (2^32 - 1). Is this a bug with SQL Server 2000 SP3?
> Or is this a problem with Performance monitor? Does it only affect the
> number of active transactions or should I treat all of the other stats
> with
> a grain of salt?
> Regards
> Dave A
>
>|||Can I just emphasise that it is not set to 4294967295 for a fleeting
moment. Rather it gets stuck on 4294967295 until SQL Server is restarted.
Looks like a bug to me. I think someone forgot to put a critical section
around some block of code.
Regards
Dave A
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e1PtdrgOFHA.3444@.tk2msftngp13.phx.gbl...
> Hi
> When a counter is collected at a critical moment, the numbers it produces
> may not be 100% correct. SQL Server shows it now and again, but I've seen
> funny numbers come out of Sybase and Oracle too.
> It is usually just that specific sample that is at an extreme, so
disregard
> it.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Dave A" <dave@.sigmasolutionsdonotspamme.com.au> wrote in message
> news:uhYJjheOFHA.624@.TK2MSFTNGP10.phx.gbl...
> >I have been monitoring the number of active transactions on my server.
> > Since I am the only one on it fluctates generally between 0 and 4
> > depending
> > on what I am doing and what programs are running against it.
> >
> > I have noticed a couple of times that the number of transactions has
gone
> > to
> > a whopping 4294967295 (2^32 - 1). Is this a bug with SQL Server 2000
SP3?
> > Or is this a problem with Performance monitor? Does it only affect the
> > number of active transactions or should I treat all of the other stats
> > with
> > a grain of salt?
> >
> > Regards
> > Dave A
> >
> >
> >
>

No comments:

Post a Comment