January 7, 2013 at 3:19 am
Hi all,
Looking to try and confirm to a standard build for all our servers. We have a lot of SSRS, SSIS and SSAS servers (Normally on the same box).
We normally have the full project files on the live server.
does anyone have a standard build. Do you like to leave everything in there default C location? or separate them out to different drives?
Any input greatly received!
January 7, 2013 at 6:51 am
Sorry to say It Depends, usually the data volumes, budget etc will dictate these things.
We tend to split everything out, even down to having seperate Servers for SSAS, SSRS and Database.
A General SQL Server Engine build we have is
OS Drive (Mirrored Raid 1+0)
Data file Drive (min Raid 1+0, normally Raid 5)
Log File Drive (raid 1+0)
TempDb and System DB (Raid 1+0) drive
Backup Drive.
If you've got a SAN or a lot of attached storage then Raid5 or Raid 10 seem to be best for the SQL Data files.
In some cases we have split the database across multiple file groups with each filegroup sitting on its own disk, but that tends to be for very large databases (500gb +)
On the SSAS Server a standard OS drive, with the Temp (Processing area) and data drives usually on seperate disks as well
SSRS tends to be run on a small blade (or VM) with limited drive space as its only really serving out data rather than doing anything specific.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
January 7, 2013 at 8:56 am
Hi Jason
Makes sense!
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply