June 13, 2011 at 12:09 pm
Hi,
I'm after some help to configure a server for a new Intranet system my company have just bought. I'm a complete novice when it comes to SQL and have no idea which drives I should be using for each type of SQL file.
I've been given a server with Windows 2008 R2 and 5 disks. I'm using two disks in a RAID 1 configuration for the system drive (135GB) and 3 disks in a RAID 5 configuration for D: (146GB) and E: (410GB). The server has plenty of space for future expansion if needed.
The Intranet will be used by about 500 people in total but no more than 10 to 15 people at any one time. It will house company handbooks and documentation to begin with so won't be used to store a great deal of data. Only a few people can publish documents on the Intranet with the rest reading information from it.
The spec sheet for the system suggested an 80GB data partition but didn't mention anything about log files so that should give you an idea about how small it is.
Is there a suggested configuration for something so small and if so can anyone help me?
Thanks
Tim
June 14, 2011 at 3:54 am
Processors and RAM in this server ?
Use Raid 1 for Tempdb
Use Raid 5 drive D: for Log Files
Use Raid 5 drive E: for mdf.ndf Files
total space is dependent on the requirement
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
June 14, 2011 at 5:24 am
Thanks for the response 🙂
It's got 1 x E5620 processor and 8GB RAM.
The spec for the Intranet was way lower than the spec of this server so I would hope it's up to the job for now but should I be asked to use it for larger databases could I move the db's, logs and tempdb to other disks at a later date?
Thanks
Tim
June 14, 2011 at 10:00 am
Processor have 4 Cores and 8 Thread and 2.4G its a good one,yes you can move later as per requirement if you see locks and performance issues then come to this
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply