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 |
|
olanorm
Starting Member
2 Posts |
 Posted - 2008-07-23 : 03:43:31
|
| Hi,I have a fairly large web application that is running on ASP.NET 2.0 with a SQL Server 2005 Standard database back-end. The solution are running on 2 separate boxes so that the SQL Server has it's own dedicated box. It is today running on an HP DL360 with 3GHz CPU and 4GB ram. The CPU usage on the SQL Server box is averaging on about 5%-10% under normal use.Now I'm going to install analysis services and providing my users with OLAP support and I'm wondering if I should install analysis services on the same box or if I should add a separate box for analysis services.Any suggestions? |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-23 : 22:23:37
|
| It depends a lot on how heavily the Analysis Services cubes etc will be used & how complex they are. Keep in mind that you will need to allow time for cube generation etc. If you have users around the world I imagine you will need 24x7 up-time for the website. The cube generation is what really taxes the DB. There can also be problems in the initial setup. I'd recommend a separate box for the DW. Are you also planning on using reporting services? It also requires a web server. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-23 : 23:16:29
|
| If you put DW on separate server, cube processing may take much longer. |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-24 : 00:00:29
|
| You need to think about whether you want to logically separate your DW from your operational DB. Keeping them on the same box will speed-up loads etc but will also increase risk to your operational DB. What is the operating range of the number of website oncurrent users, users/day & what is the size of your operational DB? |
|
|
|
olanorm
Starting Member
2 Posts |
Posted - 2008-07-25 : 15:34:24
|
| My operational database is about 50 GB. I'm having about 400-500 unique users of the system each day, but they are quite heavy users.I'm planning on generating the cube(s) once per night. When we have less traffic on the site.I don't think we will run reporting services. We'll mostly access the cubes via the Dundas OLAP client (webbased).If I initially run analysis services on the same box as the operational database, will it be difficult to move it to a separate box later, or is that a pretty straight forward procedure? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-26 : 19:07:46
|
| Moving cubes is not that difficult. |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-28 : 09:10:09
|
| If you have a good test server/environment where you can replicate your prod server/environment to a decent extent & set things up & make sure it's ok, then you reduce the risk. If not, with that size & no of users, it's riskier to put it on the same box. |
|
|
|
|
|
|
Hardware requirements for analysis services