Server build design for BI servers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Server build design for BI servers

Server build design for BI servers

Rate Topic

Display Mode

Topic Options

Author

Message

n00bDBA

Posted Monday, January 07, 2013 3:19 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 3:19 AM
Points: 117, Visits: 415

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!

Post #1403511

Jason-299789

Posted Monday, January 07, 2013 6:51 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 3:38 AM
Points: 803, Visits: 2,123

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

Post #1403579

n00bDBA

Posted Monday, January 07, 2013 8:56 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 3:19 AM
Points: 117, Visits: 415

Hi Jason

Makes sense!

Thanks

Post #1403682

« Prev Topic | Next Topic »

Permissions