July 23, 2009 at 3:29 pm
We are considering installing IIS on our production SQL server (eight instances running various production databases). The reason we would be doing this is to save the cost of buying more SQL licenses to install Reporting Services on another server. This way we can install Reporting Services on the SQL box we already have licenses for and save that cost.
My question is this: What could be the repercussions of doing this? Performance wise, security wise, and any other aspects. Any help would be appreciated.
July 24, 2009 at 5:30 am
In terms of security, you shouldn't have any concerns, assuming you properly wall off the IIS server. Performance could be a serious issue, depending on how much memory and processor power you're already consuming on the box. Reporting Services is pretty resource intensive, more so as the reports get bigger. If you're already seeing memory or cpu pressure on the system, it's just going to get worse.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply