Hi,
After making changes to our development SSAS 2005 Database, I try to reporcess but it just seems to hang. Rebooting the server seems to fix the issue because once the server comes back up, I'm able to reprocess and see the progress immediately.
This server has SP2 installed.
Has anyone else run across this?
Thanks,
Brian
Maybe the was an lock on the database by you or an other user.
If there is an lock on the database this is the intended behavior.
In the analysis services samples there is an activity viewer where you could check for locks and sessions on the server.
Best Regards, HANNES
|||Thank you for the reply. Can you explain more on where to find the activity viewer that displays locks and instances?|||It is a C# Sample Code Program you have to manually setup with SQL Server 2005 Samples.
By default the samples install to C:\Program Files\Microsoft SQL Server\90\Samples with the special location of \Analysis Services\Administrator\ActivityViewer for the analysis activitiy viewer.
HANNES
