Solved

MSDE, transaction logs and partitions

Posted on 2010-11-15
8
363 Views
Last Modified: 2012-05-10
Hi

We have an application that runs on Windows 2008 servers. It requires a DB so we'll also have MSDE installed on the same box.

I understand that it's generally better to have transaction logs on RAID 1 and the database on RAID 5.

We could have the transaction logs on the same RAID group as the C drive in that case.

C: OS and transaction logs
D: Application and MSDE database

However, is there any issue with having two write intensive 'applications' (the OS and the transaction logs) on the same partition?

Also, I guess there is a higher risk placing them on the C drive in case the logs fill up the C drive and knock the server over?

What are people's recommendations?
0
Comment
Question by:Joe_Budden
[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
  • 5
  • 3
8 Comments
 
LVL 10

Accepted Solution

by:
Humpdy earned 500 total points
ID: 34135776
you should never place the T-Logs on the OS Drive, never!!
Ideally you would place your datafiles on one physical volume, and your T-Logs on another separate volume.
Ideally you would separate out again your tempdb to a disignated disk for the data file and one for the log file.
Depending on the amount of CPUs your server has as well, you should create multiple datafiles for your tempdb.
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34135778
also, for write intensive applications you should look at RAID 10 instead of RAID 5
0
 
LVL 1

Author Comment

by:Joe_Budden
ID: 34136103
Thanks! Out of interest, what's the reason for never placing transaction logs on the C drive?
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 10

Expert Comment

by:Humpdy
ID: 34136123
it's bad practice,
t-logs should be placed on their own spindle, outside of the OS.
Also, for fault tolerance, you want them on a separate disk in the case of a disaster happening.
Performance gains when placed outside of OS drive.
0
 
LVL 1

Author Comment

by:Joe_Budden
ID: 34136289
Thanks..

As regards to placing t logs on their own drive, does this include when circular logging is enabled?
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34136371
the actual t-logs is circular logging anyway, but still, should always be placed separately to data fils.
0
 
LVL 1

Author Comment

by:Joe_Budden
ID: 34136427
Ah ok.... I thought t logs were only flushed with a full backup ?
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34136493
by ciruclar log, it's not automatic.....
yes, you need to truncate the log essentially for it to wrap around.
Doing a transaction log backup within SQL will do this.
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
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 walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

756 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