Re: datafile and log file on cluster

Tech-Archive recommends: Speed Up your PC by fixing your registry

okay thanks for the info...i was thinking that it has more to do with having
the info on different disks....not having all the eggs in one basket....in
case you lose a disk.
i wasn't looking at it from a performance standpoint.

the more i think on it...i don't know if having one would do you any good
without the other anyway....would it?

"Geoff N. Hiten" wrote:

> The performance and recovery guidelines don't change on a cluster. Using
> separate physical disks will always give better performance and
> recoverability than putting the log and data files on the same disks. If
> neither of these is important, then you have no reason to separate the
> files.
>
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "jason" <jason@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:C23E6B55-B1CF-44D9-B61C-DBD2396EF62A@xxxxxxxxxxxxxxxx
> > hi,
> > i think i know the answer...but want a sanity check.
> >
> > i have a ss cluster i use for many different dbs.
> > i have mulitple shared disk i can utilize for the dbs.
> >
> > is there big reason i should keep the data file on a different disk than i
> > keep the log file...or if i can deal with data loss up till my last
> > backup...can i just put them on the same disk?
> >
> > what would be better?
> > thanks.
>
>
>
.

Relevant Pages

  • Re: How to delete win 2k and keep only xp
    ... Let's deal with your most urgent question first: Your data files. ... Boot the machine with a Win98 boot disk from www.bootdisk.com. ... You upgrade/install operating systems without first ...
    (microsoft.public.win2000.setup)
  • Re: Mmmmmmm!
    ... >>> I'd be very tempted to move all his data files, ... avoid transferring any nasties. ... You could even put the old disk into ... > the boot sequence. ...
    (uk.rec.sheds)
  • Re: expdp very sllllllllloooooooooowwwww
    ... all partitions are located on one single disk. ... Another not always apparent issue is the true physical disk layout ... While the LUNs that the database data files ... Finally while it is possible all the backup area and database data ...
    (comp.databases.oracle.server)
  • Re: Best practice - disks/RAID
    ... You can usually get by with a Raid 1 for the OS and potentially place the transaction logs on there as well, just no data files. ... Another choice is to have a 4 disk Raid 10 for the user data and a Raid 1 for tempdb data files. ...
    (microsoft.public.sqlserver.setup)
  • Disk problem - Win 2000 Pro
    ... 38 GB disk.. ... Internet security software, so it is unlikely the problems are related to ... I am planning to use LapLink's PCMover to transfer apps and data files to ... convert the file system to NTFS ...
    (microsoft.public.win2000.general)