September 11, 2009 at 3:48 am
Hello All, Firstly I hope this is in the right forum apologies if it isn't.
I have been given the task of adding SSAS and SSIS to an existing SQL 2005 Windows 2003 A/A Cluster and I was wondering if this would have any effect on the 15 or so databases that are already on this cluster. My setup is 2 node A/A cluster using 2 x IBM x3655 servers connected to EMC SANs via firbre channel with Windows 2003 Ent x64 SP2 and SQL Server 2005 SP2.
While I can't really find anything on the net about whether installing these extra services will have any detriemental effect on my exisiting cluster and databases I thought it best to ask around to see if anyone has done this and if there were things I should look out for. For eg does the nodes require a reboot once you install SSAS and SSIS? this could be an issue as I work for a hospital and some of the databases contain cancer patient records.
Thank you.
September 11, 2009 at 9:39 am
Hi
I don't think a straight install will require a reboot - but you will probably need to get SSAS to the same service pack level as SQL Server - and that might require a reboot (try it on a test server first) - If you stop SSAS before the service pack it should be ok but I normally like to reboot after a service pack myself.
As for impact, SSAS will have an effect when you are processing your cubes + disk space if the cube databases are going to be large.
The install shouldn't have any affect on you existing OLTP databases - other than potential reboot on SP install, and use of memory etc when SSAS is processing.
September 11, 2009 at 10:16 am
thanks for very much for your reply Seth. I agree with you I also like to reboot after installing services, SPs etc and I can always fail each node over and reboot 1 at a time. This would need to be done out of hours. There is quite a bit of memory on these boxes (16gb on each) so using a bit more memory shouldn't be an issue.
Apart from this installing SSAS and SSIS should be pretty straight forward and I'll begin testing it next week prior to installing it on the live environment. thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply