Results 1 to 4 of 4

Thread: Databases & Transaction logs on same spindle

  1. #1
    RAJ Guest

    Databases & Transaction logs on same spindle

    Hello,
    In my now enviroment I have an Exchange 2003 Ent. edition server running on
    Win2K3 Standard edition.
    The person who built the server did the following:
    6 drives; 2 drives mirrored w/ the OS (C:\) and 4 drives RAID 0+1 w/ the
    database & transaction logs (E:\).
    I'm having I/O performance issues on E:\ (Event ID 509)
    I want to seperate the database files and transaction log files and I don't
    want to blow away the RAID config.
    I'm thinking of putting the database files on C:\ w/ the OS.
    Would this be acceptable in terms of performance, stability & reliability?
    Comments; suggestions...
    Thank you.

  2. #2
    Brian Desmond [MVP] Guest
    You'd be much better off putting th elogs on the same spindle as the OS as
    that's a RAID1 mirror set b/c of the write perf. The databases can go on the
    other array.


    --
    --Brian Desmond
    Windows Server MVP
    desmondb@payton.cps.k12.il.us

    www.briandesmond.com


    "RAJ" <RAJ@discussions.microsoft.com> wrote in message
    news:43AA0323-23A0-4037-8B90-C0CA0D1D5F65@microsoft.com...
    Hello,
    In my now enviroment I have an Exchange 2003 Ent. edition server running
    on
    Win2K3 Standard edition.
    The person who built the server did the following:
    6 drives; 2 drives mirrored w/ the OS (C:\) and 4 drives RAID 0+1 w/ the
    database & transaction logs (E:\).
    I'm having I/O performance issues on E:\ (Event ID 509)
    I want to seperate the database files and transaction log files and I
    don't
    want to blow away the RAID config.
    I'm thinking of putting the database files on C:\ w/ the OS.
    Would this be acceptable in terms of performance, stability & reliability?
    Comments; suggestions...
    Thank you.

  3. #3
    Jim Schwartz Guest
    The I/O load of the databases is higher than the load of the transaction
    logs. When calculating I/O's, the transaction logs typically take only 10%
    of what the total database I/O rate is.

    The transaction logs are also sequential write as apposed to random read
    write of the databases. As Brian said, it is better to isolate the databases
    and if you must share, share the transaction logs.

    "Brian Desmond [MVP]" <desmondb@payton.cps.k12.il.us> wrote in message
    news:%233FAcblOFHA.3296@TK2MSFTNGP15.phx.gbl...
    You'd be much better off putting th elogs on the same spindle as the OS as
    that's a RAID1 mirror set b/c of the write perf. The databases can go on
    the other array.


    --
    --Brian Desmond
    Windows Server MVP
    desmondb@payton.cps.k12.il.us

    www.briandesmond.com


    "RAJ" <RAJ@discussions.microsoft.com> wrote in message
    news:43AA0323-23A0-4037-8B90-C0CA0D1D5F65@microsoft.com...
    Hello,
    In my now enviroment I have an Exchange 2003 Ent. edition server running
    on
    Win2K3 Standard edition.
    The person who built the server did the following:
    6 drives; 2 drives mirrored w/ the OS (C:\) and 4 drives RAID 0+1 w/ the
    database & transaction logs (E:\).
    I'm having I/O performance issues on E:\ (Event ID 509)
    I want to seperate the database files and transaction log files and I
    don't
    want to blow away the RAID config.
    I'm thinking of putting the database files on C:\ w/ the OS.
    Would this be acceptable in terms of performance, stability &
    reliability?
    Comments; suggestions...
    Thank you.


  4. #4
    RAJ Guest
    Thanks for the added info! Very helpful.

    "Jim Schwartz" wrote:

    The I/O load of the databases is higher than the load of the transaction
    logs. When calculating I/O's, the transaction logs typically take only 10%
    of what the total database I/O rate is.

    The transaction logs are also sequential write as apposed to random read
    write of the databases. As Brian said, it is better to isolate the databases
    and if you must share, share the transaction logs.

    "Brian Desmond [MVP]" <desmondb@payton.cps.k12.il.us> wrote in message
    news:%233FAcblOFHA.3296@TK2MSFTNGP15.phx.gbl...
    You'd be much better off putting th elogs on the same spindle as the OS as
    that's a RAID1 mirror set b/c of the write perf. The databases can go on
    the other array.


    --
    --Brian Desmond
    Windows Server MVP
    desmondb@payton.cps.k12.il.us

    www.briandesmond.com


    "RAJ" <RAJ@discussions.microsoft.com> wrote in message
    news:43AA0323-23A0-4037-8B90-C0CA0D1D5F65@microsoft.com...
    Hello,
    In my now enviroment I have an Exchange 2003 Ent. edition server running
    on
    Win2K3 Standard edition.
    The person who built the server did the following:
    6 drives; 2 drives mirrored w/ the OS (C:\) and 4 drives RAID 0+1 w/ the
    database & transaction logs (E:\).
    I'm having I/O performance issues on E:\ (Event ID 509)
    I want to seperate the database files and transaction log files and I
    don't
    want to blow away the RAID config.
    I'm thinking of putting the database files on C:\ w/ the OS.
    Would this be acceptable in terms of performance, stability &
    reliability?
    Comments; suggestions...
    Thank you.





Similar Threads

  1. Transaction Logs
    By 1xnyer in forum Administration
    Replies: 6
    Last Post: 12-22-2005, 09:58 AM
  2. Many Transaction Logs
    By John in forum Administration
    Replies: 3
    Last Post: 10-10-2005, 05:58 PM
  3. Transaction Logs
    By Marco Roberto Gonçalves J in forum Administration
    Replies: 3
    Last Post: 08-12-2005, 04:46 PM
  4. Moving SBS Exchange 2003 Databases and Logs
    By Cass Shelver in forum General
    Replies: 4
    Last Post: 08-09-2005, 04:22 PM
  5. Replies: 6
    Last Post: 04-20-2005, 12:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other forums: Access Forum - Microsoft Office Forum - CAD Forum