dbTalk Databases Forums  

Object deletion VERY slow

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Object deletion VERY slow in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Les Russell
 
Posts: n/a

Default Object deletion VERY slow - 12-11-2005 , 11:24 PM






Hello,

I have a brand new SQL Server installation and I am copying Analysis
Services databases from the old server using Archive/Restore (this seems the
most effiicent way to copy an entire database in one go). No problems with
that.

I was trying to clean up the databases by removing some redundant
development dimensions and cubes (we don't yet have a separate
development/production environment).

However the deletion is extremely slow - to the point where so far I have
been unable to delete successfully any dimensions or cubes (after an hour or
so I kill it). Any clues as to what might be wrong? The server has 3GB of
memory and dual Xenon 3.4GB processors, so there is plenty of grunt available.

Thanks
Les

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.