Log files on server, data on SAN drive ?

From: Marlon Brown (marlon_brown_at_hotmail.com)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 09:14:22 -0800

I need to install SQL server on my MOM 2005 box.
For any db install, It is recommended to split log files disk location from
db location for better performance.

The existing (40GB) LUN drive available to my server is a Raid 5
configuration.
There are two disks on the local server configured as Raid1. I have the OS
installed on that Raid1 array as well.

In my situation, is better install the log files on the localserverArray and
db on the SAN drive ? Or should I put the whole data and log files on the
SAN ?

In my case I will have long delays if I ask the SAN folks to re-arrage the
arrays for me, so I would like to see if I can be OK as is now.

Relevant Pages

  • Re: Cant install components on 2003 SP1 R2 upgrade
    ... drive for .log files relating to R2 and there weren't any at all. ... The install appears to have gone smoothly, ... passive server within a 2 server active/passive cluster. ... Microsoft MVP: Windows Server ...
    (microsoft.public.windows.server.setup)
  • Re: Cant install components on 2003 SP1 R2 upgrade
    ... It's really strange that the log files were not created and the registry key ... Microsoft MVP: Windows Server ... I watched the last 10 minutes of the install which appeared to go ...
    (microsoft.public.windows.server.setup)
  • Re: OWA security/hacking
    ... There are also some Microsoft security patches for OWA itself that need to ... be run on the OWA server but not the Exchange server. ... Review the log files daily. ... Install anti-virus on the server and set it to get new definitions daily. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Cant install components on 2003 SP1 R2 upgrade
    ... It's really strange that the log files were not created and the registry key ... Did they upgrade or clean install? ... Microsoft MVP: Windows Server ...
    (microsoft.public.windows.server.setup)
  • Re: New Event Log Errors!
    ... Somehow along those lines I'd also installed the Certificate Authority ... Did you apply the last Server Pack for SBS Server? ... Please install Windows Support Tools on the win2k3 sp1 problematic ... Microsoft is providing this information only as a convenience to you: ...
    (microsoft.public.windows.server.sbs)