Solved

SQL and Exchange DBs and Logs on SAN

Posted on 2008-10-16
6
305 Views
Last Modified: 2013-11-14
Hello, I've got a question re. disk performance for SQL and Exchange running on a SAN.

With a SAN with a fair amount (16GB) of cache, and using 4Gb Fibre links, is it still necessary to split the Logs files and Databases over different arrays like it used to be with local storage?

I realise its probably down to the amount of traffic the servers are processing, but I was just wondering from a 'rule of thumb' point of view.

Many thanks.
0
Comment
Question by:paulo999
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 11

Accepted Solution

by:
jkarnes12 earned 64 total points
ID: 22735993
You always want to keep Database and log files on separate disks due to I/O considerations.  If they are on the same RAID physical disk configurations there will be I/O contentions that will degrade performance dramatically.
0
 
LVL 15

Assisted Solution

by:MohammedU
MohammedU earned 62 total points
ID: 22736068
SAN should have different configuration...
Make sure LUNs used datafiles and logfiles from different filegroup set other even you change the location you have the problem.
Check with your SAN adminstrator about SAN configuration.
0
 
LVL 30

Assisted Solution

by:Duncan Meyers
Duncan Meyers earned 62 total points
ID: 22736630
As a rule, database and logs should be put on different physical discs as they present a competing I/O load. The reality in many cases, though, is that a smaller Exchange environment (<500 users) does not generate that much I/O - despite Microsoft's sizing calculators - and the logs and databse *could* go on the same physical discs if you were pressed for space. It sounds like you have a pretty chunky storage array if you've got 16GB of cache whcih suggests that you support a large number of users - so I'd stick with best practices and keep logs and database separated if you can. Note that if your database and Exchange servers are virtualised, then things change. A virtualised environment presents a highly random I/O load, so you need to be very careful with sizing calculations.
0
 
LVL 55

Assisted Solution

by:andyalder
andyalder earned 62 total points
ID: 22742145
If you read http://chucksblog.typepad.com/chucks_blog/2008/08/your-storage-mi.html and the followup from the other vendors you'll see it's a minefield. One of the HP replies on their blog was to have 2 storage groups for 2 exchange servers with the logs for server 1 on the same disk group as the data disks for server 2 and vice versa - http://www.communities.hp.com/online/blogs/datastorage/archive/2008/08/29/emc-distortion-about-capacity-efficiency.aspx .

So, according to the big boys it *is* acceptable to have logs on the same disks as data. I tend to agree and where possible put everything on one set of disks unless data separation of logs for data security is required. There is of course contention for the disks but on the flip side there are more disks available for each individual application.

Look at SAME from Oracle for another example, admittedly it's just one database but a complex one with varying I/O profiles and they put everything on a single disk set (although they keep the redo logs seperate for point in time DR restore purposses) - www.oracle.com/technology/deploy/availability/pdf/oow2000_same.pdf
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions.  Here are my tips for handling such a transfer.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

737 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