Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jagpalsingh4
Starting Member
7 Posts |
 Posted - 2008-06-12 : 09:47:34
|
| Hi , DBA's i just want to know that one of our customer want to add services like ssis,ssrs and ssas .but i want to know that on which server they need to install these services. 1. web server2. application server 3. database server which server is perfect for these services .plz w8ing for ur suggestions .Thaxxx Regards Jagpal Singh jagpalsingh |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-12 : 10:12:21
|
| database server. These are bundled along with SQL Server. You only need to select these compoents also while installing SQL Server on your box. And you can control these services properties from configuration manager. |
 |
|
|
jagpalsingh4
Starting Member
7 Posts |
Posted - 2008-06-12 : 10:20:21
|
| Thaxx for reply i know this how to install but my question is that on which server we can install it because after installing thses services server is using more memory so that y they ask me for planning .jagpalsingh |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-12 : 11:59:07
|
| First of all, you need to have IIS installed for SSRS. It good to have separate server for SSRS and dedicated server for SQL server as it is memory hog. But if your server has more memory ,then you can limit min and min memory for SQL server so these apps can use the rest memory . |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-14 : 01:04:59
|
| Put ssrs om web server. Put ssis and ssas on sql server, but ensure it has enough horsepower. |
|
|
|
|
|
|
which server is perfect for installation ?