September 15, 2005 at 10:37 am
I have a shared production server running SQL Server 2000, SP3a (going to SP4 very soon) with 7 databases currently running on it. Recently I had a request from a database owner to install Analysis Services. Another database owner expressed concerns that Analysis Services would impact the performance of his application. Any comments or information regarding this issue are greatly appreciated! Thanks!
September 15, 2005 at 12:47 pm
The answer is that AS can definately impact the performance of a SQL instance, the inverse is, of course, also true.
Many people recommend running them on seperate servers, but it isn't always so straightforward. I have several instances where they coexist quite nicely and together they add up to more efficient use of our hardware resources. These are cases where SQL gets hit pretty hard during business hours while AS gets fairly light use during that time. During the evening hours we schedule our cube processing (where AS really gives the server a workout).
So if you have a server that isn't being fully utilized and have a similar situation to the one I described, you just might be able to save yourself some hardware and licensing costs. If not, be aware that if you install AS on a seperate machine, you have to purchase a SQL Server license for it.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
September 16, 2005 at 12:30 pm
I order to minimize the impact each has on the other (if they must co-exist on the same server) I'd fix min/max memory on SQL Server and also limit memory that AS can use as well. As for the exact numbers well, it's kind of a trial/monitor/change situation. In the past on a 4 Gb server I've had luck with 2 Gb for SQL Server 1 Gb for AS leaving Windows 1 Gb. But again, monitoring is the key.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply