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...
>> 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.
>
>.
>|||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...
> 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...
> >> 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.
> >
> >
> >.
> >|||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...
>> 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...
>> >> 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.
>> >
>> >
>> >.
>> >
>
>.
>|||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:
>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...
>> 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...
>> >> 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.
>> >
>> >
>> >.
>> >
>>
>>.