November 7, 2007 at 9:02 pm
I have sql server 2005 - version 9.00.3054.00 -SP2 - Enterprise Edition. Is there any latest version than this to upgrade. I am having lot of troubles on the server these days. Whenever Analysis server cube is processed, the server is going really slow and before the cube process analysis service is stopping. I don't understand what the problem is? Analysis services is getting stopped whenever a cube is processed and server performance is getting really slower.
Please let me know how to trouble shoot this.
Thanks in advance.
November 8, 2007 at 4:27 am
Refer the below link, Steve has provided all the version list
http://qa.sqlservercentral.com/articles/Administration/2960/[/url]
Regards..Vidhya Sagar
SQL-Articles
November 8, 2007 at 6:25 am
I'm having problems like this with a sql 2000 AS, we've partially solved this by processing the dimensions sequentially rather than processing the whole cube at once.
You might want to make sure the underlying sql tables are optimised for the cube builds - trap worst performing and all that. We're also going to move to 64bit as lower memory limits really hit AS hard which seems to move processing out to the page file when short of physical memory - you might want to check your page file and maybe get it onto your fastest disk array ( probably not the C: drive )
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
November 14, 2007 at 11:23 pm
Thanks for all your replies.
My problem is solved atlast. I had less memory in C:drive, so when the cube is processing due to space issue, it is stopping the analysis services. I changed data path of analysis services to an other drive and processed the cube, it ran successfully.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply