?
Solved

Storage (SAN configuration) Recommendation for MOSS 2007 Farm

Posted on 2009-02-17
11
Medium Priority
?
770 Views
Last Modified: 2013-11-14
Scenario: We have plan to install MOSS 2007 farm. Initially, we will install MOSS 2007, webserver, search & indexing on one box and SQL 2005 on another box. Afterwards, according to need we will add another server for search and indexing. We also have fiber channel card on our boxes.

We have a SAN solution (Pillar Data Systems) also.

Requirement: I need a suggestion about storage for MOSS 2007 and SQL 2005, i.e. Do we need to install MOSS 2007 on local hdd? If on local then which files should be on SAN? Which files of SQl 2005 should be SAN? Which files need what type of RAID configuration?

Please help me in this regard.
0
Comment
Question by:A1opus
  • 6
  • 5
11 Comments
 
LVL 13

Expert Comment

by:St3veMax
ID: 23663888
I can help out here...

We have a "Medium Server Farm"; two web front ends; one index and two sql (Clustered); all connected to a SAN.

Web:

Install MOSS Locally and have a SAN Attached drive to house your indexes that are propogated up from the index server

Index:

Again - Install MOSS Locally and have a SAN Attached Drive to hold your indexes

SQL:

Install SQL Locally; Configure 4 x SAN Drives (Data, Log, TempDB, Quorum). Depending on your requirements; Use RAID 1+0 for Log, TempDB, Raid 5 for Data, Quorum.

HTH
0
 
LVL 2

Author Comment

by:A1opus
ID: 23664738
Thanks St3veMax.

In fact we are planning small farm consisting of webserver and DB server. If we are planning MOSS 2007 for 200 users so initially what will be the size of your suggested volumes for both MOSS indexes and DB server's 4 volumes?
0
 
LVL 13

Expert Comment

by:St3veMax
ID: 23668063
Size of volumes is difficult as it depends on your current data volume and projected growth. Ideally you need to ensure your SAN has enough raw capacity to last 3yrs (assuming 3yr financial write-off).

You need to consider what you MOSS implementaion is going to be used for....Document Storage, Workflow sites, Intranet, etc.

On our MSF; we have a 2TB LUN for Data; 600GB for Logs, 100GB for TempDB, 500MB for Quorum (which is way over what it really needs). Our farm is split over 20 x content databases; with a 60GB Month-On-Month growth.

Other considerations are how mission critical is your setup? i.e. do you really need a SQL Cluster? MOSS 2007 will work with Database Mirroring; but it's a manual failover from a SharePoint perspective.

I would also reccomend creating a DNS CName for your SQL Connection; i.e. SQLMOSS.YourDomain.net which points to your DB Server; thus meaning when you need to move the DB; you just move it, move the logins and repoint the DNS - something I found out the hard way...

HTH
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Author Comment

by:A1opus
ID: 23678156
We are not planning for SQL clustering. We have a plan for 200 users who will not interact with MOSS aggressively. We will host document storage, workflow and intranet as well. So what is the final recommendation for the following SAN attached volumes:

Webserver:

Indexes = ?

SQL Server:

TempDB = ?

Data Files = ?

Logs = ?

0
 
LVL 13

Accepted Solution

by:
St3veMax earned 1500 total points
ID: 23679053
Assuming all binaries will be installed locally (C:\Program Files); I would suggest the following:

Webserver:

Data = D:\50GB RAID5

Indexes:

Data = D:\50GB RAID5

SQL Server:

TempDB = R:\100GB RAID1+0 (Log)

Data Files =  S:\100GB RAID5 (Data)

Logs = T:\50GB RAID 1+0 (Log)

The above really depends how big you think your data is currently and how big you expect it to grow.

HTH
0
 
LVL 2

Author Comment

by:A1opus
ID: 23679095
I didn't get first part of the message (Webserver) I am cleared in SQL Server.

You mean if I install MOSS 2007 locally on Webserver then What is Data? You mean local HDD space? and Index Data should be on SAN attached volume?
0
 
LVL 13

Expert Comment

by:St3veMax
ID: 23679119
Your Index server will crawl all your content and then propogate the index file (flat file) upto your webserver; hence the need for a reasonable size SAN disk on both the Index and Web server.
0
 
LVL 2

Author Comment

by:A1opus
ID: 23679200
Currently I have only 72 GB (Raid 5) on my Local server. Isn't enough I think?
0
 
LVL 13

Expert Comment

by:St3veMax
ID: 23679221
Do you have any existing content to migrate into MOSS?

If so, how big is it currently?
0
 
LVL 2

Author Comment

by:A1opus
ID: 23679238
Remember our Index and Webserver is same.
0
 
LVL 2

Author Comment

by:A1opus
ID: 23679292
Yes we have but not much.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you an Exchange administrator employed with an organization? And, have you encountered a corrupt Exchange database due to which you are not able to open its EDB file. This article will explain all the steps to repair corrupt Exchange database.
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question