Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsWindows Server 2003Windows 2000Windows NTSmall Business ServerVirtual ServerExchange ServerIISHost Integration ServerISA ServerSMSWSUSMOMWindows Media ServerSecurityCertification
Related Topics
SQL ServerMS WindowsMS OfficePC HardwareMore Topics ...

Windows Server Forum / Exchange Server / Design / October 2008

Tip: Looking for answers? Try searching our database.

Separate Logs and Database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
chua - 02 Oct 2008 09:04 GMT
Hi,

i always see that best practice advise to "Separate Logs and Databases" in a
Storage. However, what it really means? Can it be done as:

1. 1 Array (Raid 1/0), Sliced into 2 LUNs. partition as 2 logical drive. 1
for Logs and 1 for Databases.
OR

2. 2 Arrays (both as Raid 1/0). One Array for Logs and the Other Array for
Database.

thanks,
Chua
Oliver Moazzezi [MVP] - 02 Oct 2008 10:49 GMT
Hi there,

A logical partion for logs and databases is technically OK. However not
really in this case as they are on the same physical RAID set. It depends if
you find this acceptable or not - many probably wouldn't.

For example, having both on logical partitions but each on a different set
of disks wouldn't be so much of a problem.

Example

RAID10 4 disk set - 2 logical partitions for SG1 and SG2 logs
RAID10 4 disk set - 2 logical partitions for SG1 database and SG2 database.

Following on from that you can still see there's an element of risk,
compared to having dedicated 'disks' for all.

You need to sum up what is acceptable to your client/your business, and
ensure you can recover in whatever agreed SLA is in place.

Oliver
A, Deji - 21 Oct 2008 23:42 GMT
It means the second option you listed. But, depending on your budget and
level of tolerance, you can do it as option 1, too.

Deji

> Hi,
>
[quoted text clipped - 11 lines]
> thanks,
> Chua
John Fullbright - 28 Oct 2008 19:18 GMT
There are really two reasons for seperating the logs and databases onto
seperate spindles:

1.  It provides an extra level of recoverability.  If you lose the partition
where the database resides then, after repairing the hardware you an restore
from backup and roll the logs forward.  Instead of losing up to 24 hours of
data (assumes backup once a day), you would potentially be up to the minute.

2.  Writes to the logs are the single most user visible aspect of Exchange
IO.  If  multiple LUNs share the same physical spindles, then IO against one
LUN can negatively impact the performance of another.  This is called
comingling.  Very few storage systems out there provide a mechinism to
mitigate comingling effects.

If you create two logical LUNs on the same spindles, you lose a bit on your
RPO, and you potentially expose yourself to comingling issues.  It can be
done; it's just not a best practice.

> Hi,
>
[quoted text clipped - 11 lines]
> thanks,
> Chua
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.