current activity takes 15 minutes to refresh

Can anyone think of a reason that it would take 15 minutes
for the Current Activity/process info to refresh? The
only thing going on right now is replication. This server
is the secondary/subscriber to two different publishers.
The distributer is also running on this machine. Other
than the replication processes, nothing else is
running... Thanks.Have you checked Task Manager/Perfmon to see if something else is chewing up
the CPU unrelated to SQl Server?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:208bd01c45958$120666a0$a101280a@.phx
.gbl...
> Can anyone think of a reason that it would take 15 minutes
> for the Current Activity/process info to refresh? The
> only thing going on right now is replication. This server
> is the secondary/subscriber to two different publishers.
> The distributer is also running on this machine. Other
> than the replication processes, nothing else is
> running... Thanks.|||No because the server guys have everything secured
extremely tight. I can't run anything remotely. Strange,
I know.

>--Original Message--
>Have you checked Task Manager/Perfmon to see if something
else is chewing up
>the CPU unrelated to SQl Server?
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>www.DallasDBAs.com/forum - new DB forum for Dallas/Ft.
Worth area DBAs.
>"Rob" <anonymous@.discussions.microsoft.com> wrote in
message
> news:208bd01c45958$120666a0$a101280a@.phx
.gbl...
minutes[vbcol=seagreen]
server[vbcol=seagreen]
>
>.
>|||Not really...happens all the time.
Have you cheked activity via QA instead of EM, using SP_Who, sp_who2,
SP_Lock, dbcc opentran, etc to see if something is hanging out there?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
<anonymous@.discussions.microsoft.com> wrote in message
news:205b401c4595a$de0f7460$a301280a@.phx
.gbl...[vbcol=seagreen]
> No because the server guys have everything secured
> extremely tight. I can't run anything remotely. Strange,
> I know.
>
> else is chewing up
> Worth area DBAs.
> message
> minutes
> server|||I ran sp_who2 and the only thing that seems to be eating
CPU is the two distribution agents. Although sp_lock is
coming back with over 1.1 millon rows... That doesn't
sound right for a server with no production activity and
only the replication agents running. Strange.
>--Original Message--
>Not really...happens all the time.
>Have you cheked activity via QA instead of EM, using
SP_Who, sp_who2,
>SP_Lock, dbcc opentran, etc to see if something is
hanging out there?
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>www.DallasDBAs.com/forum - new DB forum for Dallas/Ft.
Worth area DBAs.
><anonymous@.discussions.microsoft.com> wrote in message
> news:205b401c4595a$de0f7460$a301280a@.phx
.gbl...
Strange,[vbcol=seagreen]
something[vbcol=seagreen]
The[vbcol=seagreen]
publishers.[vbcol=seagreen]
Other[vbcol=seagreen]
>
>.
>|||Check the spid or spids for the locks when you execute
sp_lock. Then check what the spids are doing with dbcc
inputbuffer(SpidNumber)
-Sue
On Wed, 23 Jun 2004 13:07:02 -0700,
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I ran sp_who2 and the only thing that seems to be eating
>CPU is the two distribution agents. Although sp_lock is
>coming back with over 1.1 millon rows... That doesn't
>sound right for a server with no production activity and
>only the replication agents running. Strange.
>SP_Who, sp_who2,
>hanging out there?
>Worth area DBAs.
>Strange,
>something
>The
>publishers.
>Other

current activity takes 15 minutes to refresh

Can anyone think of a reason that it would take 15 minutes
for the Current Activity/process info to refresh? The
only thing going on right now is replication. This server
is the secondary/subscriber to two different publishers.
The distributer is also running on this machine. Other
than the replication processes, nothing else is
running... Thanks.
Have you checked Task Manager/Perfmon to see if something else is chewing up
the CPU unrelated to SQl Server?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:208bd01c45958$120666a0$a101280a@.phx.gbl...
> Can anyone think of a reason that it would take 15 minutes
> for the Current Activity/process info to refresh? The
> only thing going on right now is replication. This server
> is the secondary/subscriber to two different publishers.
> The distributer is also running on this machine. Other
> than the replication processes, nothing else is
> running... Thanks.
|||No because the server guys have everything secured
extremely tight. I can't run anything remotely. Strange,
I know.

>--Original Message--
>Have you checked Task Manager/Perfmon to see if something
else is chewing up
>the CPU unrelated to SQl Server?
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>www.DallasDBAs.com/forum - new DB forum for Dallas/Ft.
Worth area DBAs.
>"Rob" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:208bd01c45958$120666a0$a101280a@.phx.gbl...
minutes[vbcol=seagreen]
server
>
>.
>
|||Not really...happens all the time.
Have you cheked activity via QA instead of EM, using SP_Who, sp_who2,
SP_Lock, dbcc opentran, etc to see if something is hanging out there?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
<anonymous@.discussions.microsoft.com> wrote in message
news:205b401c4595a$de0f7460$a301280a@.phx.gbl...[vbcol=seagreen]
> No because the server guys have everything secured
> extremely tight. I can't run anything remotely. Strange,
> I know.
> else is chewing up
> Worth area DBAs.
> message
> minutes
> server
|||I ran sp_who2 and the only thing that seems to be eating
CPU is the two distribution agents. Although sp_lock is
coming back with over 1.1 millon rows... That doesn't
sound right for a server with no production activity and
only the replication agents running. Strange.
>--Original Message--
>Not really...happens all the time.
>Have you cheked activity via QA instead of EM, using
SP_Who, sp_who2,
>SP_Lock, dbcc opentran, etc to see if something is
hanging out there?
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>www.DallasDBAs.com/forum - new DB forum for Dallas/Ft.
Worth area DBAs.[vbcol=seagreen]
><anonymous@.discussions.microsoft.com> wrote in message
>news:205b401c4595a$de0f7460$a301280a@.phx.gbl...
Strange,[vbcol=seagreen]
something[vbcol=seagreen]
The[vbcol=seagreen]
publishers.[vbcol=seagreen]
Other
>
>.
>
|||Check the spid or spids for the locks when you execute
sp_lock. Then check what the spids are doing with dbcc
inputbuffer(SpidNumber)
-Sue
On Wed, 23 Jun 2004 13:07:02 -0700,
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I ran sp_who2 and the only thing that seems to be eating
>CPU is the two distribution agents. Although sp_lock is
>coming back with over 1.1 millon rows... That doesn't
>sound right for a server with no production activity and
>only the replication agents running. Strange.
>SP_Who, sp_who2,
>hanging out there?
>Worth area DBAs.
>Strange,
>something
>The
>publishers.
>Other