Showing posts with label refresh. Show all posts
Showing posts with label refresh. Show all posts

Monday, March 19, 2012

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

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

Wednesday, March 7, 2012

Cube Refresh

Hi,
I hope someone can clarify this to me.
I have DW Database which is the for a OLAP Database I
created in AS. I have created cube with the necessary fact
tables and the dimensions. my question is whenever the
Data in the DW is updated, do u need to manually refresh
the cubes so the cube would have data? is this automatic
or else can this be automated?
Thanks
Regards
ImranYes and yes, you need to "re-process" the cube when you add data to the
underlying tables. You can automate this by using the process cube task in
DTS.
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Imran" <anonymous@.discussions.microsoft.com> wrote in message
news:b70e01c40d94$5e25e840$a001280a@.phx.gbl...
> Hi,
> I hope someone can clarify this to me.
> I have DW Database which is the for a OLAP Database I
> created in AS. I have created cube with the necessary fact
> tables and the dimensions. my question is whenever the
> Data in the DW is updated, do u need to manually refresh
> the cubes so the cube would have data? is this automatic
> or else can this be automated?
> Thanks
> Regards
> Imran|||Our team uses DTS to populate a special datawarehouse db and then trigger an
alysis server to reprocess it's cubes. We have this automated to run every
15 minutes. In our DTS package, we just needed to drage the SQL Server OLED
B provider, an execute SQL
task that kicks off our datawarehouse data import stored procedures, and the
n an analysis services processing task. The processing task would then just
be set up with a work flow to execute after the data import stored procedur
e. This has worked splendi
dly for us.