dbTalk Databases Forums  

Analysis Server Error: File error [Write error] There is not enough space on the disk

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


Discuss Analysis Server Error: File error [Write error] There is not enough space on the disk in the microsoft.public.sqlserver.olap forum.



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

Default Analysis Server Error: File error [Write error] There is not enough space on the disk - 05-04-2005 , 06:02 AM






Has anyone seen this message? We have been trying to build a cube
(approx. 3 GB with 5% aggregations) and we keep getting this message.
Our cube directory has over 200 GB available. Can someone point me to
"what" file/disk is running out of space? Is there a "temp" area that
is being used that we have allocated on another drive? Thanks.


Reply With Quote
  #2  
Old   
David Botzenhart
 
Posts: n/a

Default Re: Analysis Server Error: File error [Write error] There is not enough space on the disk - 05-04-2005 , 10:21 PM






Hi Mike,

There are two temp areas that AS will write files to.
1. Is the Temp directory, this by default is the same as your Data folder.
You can check by right clicking the servername in Analysis Manager and then
choose properties. The first tab will show you data folder and temp
directory.
2. I also believe some temp files are written to the Bin folder. So make
sure you have enough disk space there as well.

If the data folder for this cube is only 3GB you should have plenty of Disk
space. Make sure your swap file isn't set too large.

How many aggregations are being created at 5%? You may still need to
decrease this if the number of aggs are to large. I can't imagine that you
would have that many aggs at 5% to consume that much disk space.

How much ram is AS taking when you first start AS? What is the process
buffer and read ahead buffer size in the properties of the server?

David Botzenhart
"mmajorza52" <mike.major (AT) marriott (DOT) com> wrote

Quote:
Has anyone seen this message? We have been trying to build a cube
(approx. 3 GB with 5% aggregations) and we keep getting this message.
Our cube directory has over 200 GB available. Can someone point me to
"what" file/disk is running out of space? Is there a "temp" area that
is being used that we have allocated on another drive? Thanks.




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.