Hi all,
I should program a small VisualBasic program for monitoring the status of
the subscription. It is a Pull anonymous subscription to a Snapshot
publication. It is supposed to run at the subscriber, a laptop PC, and
provide info to an human about:
-Wheter the distributor is reachable/available
-The last successful synchronization.
-If the synch is running, the approx time to the end.
I've been browsing around the SQL Replication ActiveX controls available,
but the samples on the Books on Line are focused on how to use the controls
to create the replication, I can't find a sample or indications on how to
monitor a pull subscription at the subscriber. Where can I find some samples
about it? Which control I need?
Thanks in advance
Faustino Dina
If my email address starts with two 'f'
drop the first 'f' when mailing me.
You are probably best to either use the status event or to query the
particular agent's history table in the distribution database for a pull
subscription.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"faustino Dina" <ffdina@.matusa.com.mx> wrote in message
news:ermC9JomEHA.748@.TK2MSFTNGP15.phx.gbl...
> Hi all,
> I should program a small VisualBasic program for monitoring the status of
> the subscription. It is a Pull anonymous subscription to a Snapshot
> publication. It is supposed to run at the subscriber, a laptop PC, and
> provide info to an human about:
> -Wheter the distributor is reachable/available
> -The last successful synchronization.
> -If the synch is running, the approx time to the end.
> I've been browsing around the SQL Replication ActiveX controls available,
> but the samples on the Books on Line are focused on how to use the
controls
> to create the replication, I can't find a sample or indications on how to
> monitor a pull subscription at the subscriber. Where can I find some
samples
> about it? Which control I need?
> Thanks in advance
> --
> Faustino Dina
> If my email address starts with two 'f'
> drop the first 'f' when mailing me.
>
|||> You are probably best to either use the status event or to query the
> particular agent's history table in the distribution database for a pull
> subscription.
Yes, ideally I'll show a Progress bar feeded by the status event of one of
the replication controls. Since my publications is a Snapshot one, and
subscription is anonymous pull, I suppose I should use the SqlDistribution
Control but the documentation states it should be used only for
transactional replication so I'm not sure about which other control to use.
The Snapshot control states it should be used for creating snapshot, it is
not the case. The snapshot is already created and ready at the distributor.
And the Merge control is useless on the Snapshot publication I think.
Showing posts with label monitoring. Show all posts
Showing posts with label monitoring. Show all posts
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
> >
> >
> >
>
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)