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 |
|
ld4987
Starting Member
4 Posts |
 Posted - 2012-08-31 : 15:46:49
|
| I'm looking to run SQL Server 2008 R2 (Standard) and SAP BusinessObjects 3.1 on the same server. I expect a maximum of five concurrent users and more likely two or three users at any given moment.SQL Server will host two databases.I am seeking advice/comments regarding the server that I have planned and whether it will handle the workload.RAM:I'm figuring on 36GB of total RAM. 12GB for the OS, 12GB for SQL, and 12GB for BusinessObjects. Will that be enough RAM?CPU:I'm figuring on a single Intel Xeon E5-2620 (6 cores, 2.00Ghz, 15M cache, Turbo). Is there any need for a second CPU?Disk:Hardware RAID, four total disksRAID 1: OSRAID 1: DataThanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-09-01 : 13:49:44
|
| You can get by with 4 GB for the OS, 6 GB to be safe. The remaining can be split between SQL and Business Objects. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-02 : 12:17:55
|
| Have you done any profiling re: memory \ CPU requoiremets. Do you have this set up in another environment and have you experienced any memory pressure?It doesn't sound like there will be high levels of traffic , but it's unclear , what type of reports , they'll be running and on which database they will be querying - Are they querying a Datawarehouse on another server?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Hardware Reqs for SQL 2008 R2