Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 R2 Enterprise Installation Recommendation Expand / Collapse
Author
Message
Posted Monday, May 6, 2013 1:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 6, 2013 4:33 PM
Points: 8, Visits: 73
Hello Peeps,
I would appreciate if you guys can recommend a good installation setup for SQL Server 2008. Below are the Hardware/Software Specs.

Specs:
1. Sql Server 2008 R2 Enterprise
2. Intel Xeon 3.3GHZ - 16GB Ram
3. Primary Drive - 2 * 1TB HD (RAID 1)
4. Secondary Storage - 1TB single drive (another volume)

Given:
1. DB will be using Simple Recovery as we don't care to lose a days worth of data.
2. We will not be using SQL Server's other Services (Replication, Analysis etc)

Question:
1. Where should we install the data files? In the Primary where I can benefit from RAID 1 or Secondary Storage where it will be separate from the OS except I dont have redundancy (although I can run a backup every night and I as mentioned, dont care if we lose some data)?
2. Any other config options I should be considering?


Thanks a bunch!
Post #1449866
Posted Monday, May 6, 2013 3:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 6, 2013 4:33 PM
Points: 8, Visits: 73
anyone? please
Post #1449911
Posted Monday, May 6, 2013 4:22 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:11 PM
Points: 17,601, Visits: 15,465
With that hardware, I would probably install SQL Server and User databases to the RAID 1. Save the other drive for the backups or maybe for tempdb.

With these kinds of specifications, you are really limited in how you can configure SQL Server.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1449925
Posted Monday, May 6, 2013 4:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 6, 2013 4:33 PM
Points: 8, Visits: 73
Thanks! I'll do that then
Post #1449934
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse