October 24, 2007 at 9:30 am
Our current SQL Server2005 environment does not include Analysis or Reporting services. We are introducing an application that requires both. We have 2 options - Build a server for the new app and install SQL Server 2005 with both services or we can install the services on our shared server. There are about 6 apps and 11 databases on the shared server. Plenty of space, memory, etc. My question is - How does Analysis and/or reporting services effect the server. Overhead? Is there a best practice? Any suggestions welcomed.
October 24, 2007 at 3:13 pm
Are you running x86 or x64? Keep in mind SSAS is limited to 3GB in an x86 environment (using the /3GB switch).
Tommy
Follow @sqlscribeOctober 24, 2007 at 6:09 pm
As you might expect, both consume resources. And it depends on how heavily both will be used. With respect to Reporting Services, however, the reporting services databases can generate a lot of I/O.
K. Brian Kelley
@kbriankelley
October 25, 2007 at 5:54 am
I'm running x86. We don't have that much activity on this server. I guess you can say it is more of a month end batch processing server for SQL Server.
This new app will only be used for Reporting. So I guess I'll try it in test then move to prod testing.
Thanks guys!!!!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply