I am running Performance Monitor and it says that for the
SQL SERVER:DATABASE (Active Transaction) I have for
_TOTAL = 4,300,000,000
yet for all the individual databases, they all are 0 or 1 during any given
second and I only have 8 databases. Shouldn't the _Total add up to all the
individual Database?
Please advise
Answered my own question with a little digging..
http://support.microsoft.com/default...en-us%3B841401
"Jason Greene" wrote:
> I am running Performance Monitor and it says that for the
> SQL SERVER:DATABASE (Active Transaction) I have for
> _TOTAL = 4,300,000,000
> yet for all the individual databases, they all are 0 or 1 during any given
> second and I only have 8 databases. Shouldn't the _Total add up to all the
> individual Database?
> Please advise
Showing posts with label transactions. Show all posts
Showing posts with label transactions. Show all posts
Tuesday, March 20, 2012
Active Transactions on Performance Monitor for SQL Server DATABASE
I am running Performance Monitor and it says that for the
SQL SERVER:DATABASE (Active Transaction) I have for
_TOTAL = 4,300,000,000
yet for all the individual databases, they all are 0 or 1 during any given
second and I only have 8 databases. Shouldn't the _Total add up to all the
individual Database?
Please adviseAnswered my own question with a little digging..
http://support.microsoft.com/defaul...Ben-us%3B841401
"Jason Greene" wrote:
> I am running Performance Monitor and it says that for the
> SQL SERVER:DATABASE (Active Transaction) I have for
> _TOTAL = 4,300,000,000
> yet for all the individual databases, they all are 0 or 1 during any given
> second and I only have 8 databases. Shouldn't the _Total add up to all th
e
> individual Database?
> Please advise
SQL SERVER:DATABASE (Active Transaction) I have for
_TOTAL = 4,300,000,000
yet for all the individual databases, they all are 0 or 1 during any given
second and I only have 8 databases. Shouldn't the _Total add up to all the
individual Database?
Please adviseAnswered my own question with a little digging..
http://support.microsoft.com/defaul...Ben-us%3B841401
"Jason Greene" wrote:
> I am running Performance Monitor and it says that for the
> SQL SERVER:DATABASE (Active Transaction) I have for
> _TOTAL = 4,300,000,000
> yet for all the individual databases, they all are 0 or 1 during any given
> second and I only have 8 databases. Shouldn't the _Total add up to all th
e
> individual Database?
> Please advise
Active Transactions on Performance Monitor for SQL Server DATABASE
I am running Performance Monitor and it says that for the
SQL SERVER:DATABASE (Active Transaction) I have for
_TOTAL = 4,300,000,000
yet for all the individual databases, they all are 0 or 1 during any given
second and I only have 8 databases. Shouldn't the _Total add up to all the
individual Database?
Please adviseAnswered my own question with a little digging..
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B841401
"Jason Greene" wrote:
> I am running Performance Monitor and it says that for the
> SQL SERVER:DATABASE (Active Transaction) I have for
> _TOTAL = 4,300,000,000
> yet for all the individual databases, they all are 0 or 1 during any given
> second and I only have 8 databases. Shouldn't the _Total add up to all the
> individual Database?
> Please advise
SQL SERVER:DATABASE (Active Transaction) I have for
_TOTAL = 4,300,000,000
yet for all the individual databases, they all are 0 or 1 during any given
second and I only have 8 databases. Shouldn't the _Total add up to all the
individual Database?
Please adviseAnswered my own question with a little digging..
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B841401
"Jason Greene" wrote:
> I am running Performance Monitor and it says that for the
> SQL SERVER:DATABASE (Active Transaction) I have for
> _TOTAL = 4,300,000,000
> yet for all the individual databases, they all are 0 or 1 during any given
> second and I only have 8 databases. Shouldn't the _Total add up to all the
> individual Database?
> Please advise
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
> >
> >
> >
>
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
> >
> >
> >
>
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 A
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
>
>
|||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[vbcol=seagreen]
> 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...
gone[vbcol=seagreen]
SP3?
>
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
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
>
>
|||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[vbcol=seagreen]
> 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...
gone[vbcol=seagreen]
SP3?
>
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...
gone[vbcol=seagreen]
SP3?[vbcol=seagreen]
>
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...
gone[vbcol=seagreen]
SP3?[vbcol=seagreen]
>
Subscribe to:
Posts (Atom)