Small correction, the maintenance is NOT the night before..... This is done on a different schedule.

Thanks GilaMonster for getting back to me.

Unfortunately, I ran DBCCs on all DBs. Everything came back okay, no messages or warnings.

After getting the first occurrences of the messages a...

.

Oh I forgot to add that this is for an Analysis Services database.

Hi,

The "test" version needs to have the same right as the production one, so read/write.

Thanks all for your help.

Hi MysteryJimbo,

Thanks for your reply. Yes, both are enabled :ermm:.

I did deleted the previous schedule and created a new one. Let see how this will behave.

Rem

What I did is moving the building of the cube on a different server. SO when the process is creating the aggregate, the high CPU usage doesn't affect the...

This is strange.

As far as I know, there is no process running at the same time.

Thanks for your quick reply.

But I am able to start/stop/restart the service via the service administrative tools.

Got the message.

Thanks for your help guys. 😉

This is what I am thinking also. But our sys admin doesn't want to believe me.

What monitor should I can use to prove this?

Thanks,

Thanks all.

The main slowness is in our ETL process. This process

-Truncate a reporting table

-Populate the reporting table

-Create indexes on the table

Even the create index is slower. I will...

Thanks GSquared....

interestingly, this works great:

select * from TableA a

where not exists (select CustID from remoteserver.PRDA.dbo.Cust b where b.Custid=a.Custid)