Hi Meg,

I haven't done any testing to quantify but my experience is that it is a good thing. You will have less disk contention. The flip side is that if you have data bases on the array with the tempdb or tempdb log, etc or you have several logical arrays which use the same physical disks, etc, then your mileage may vary. A rule of thumb is different disks (and controllers if you can) for the logs, tempdb, and database. Just to confuse the issue, some of the Oracle folks opt for striping of all the drives and just put everything on the logical drive (this assumes a very high end system).

. . .Tom

On 06/10/2002 12:29:32 PM Meg Hardy wrote:
> Hi everyone,
>
> Do you know if it is bad to have the tempdb log on one disk array and tempdb
> data on another?
>
> Thanks
> Meg
>
>
> **********************************************************************
> DISCLAIMER
> Any opinions expressed in this email are those of the individual and not
> necessarily of Mondial Assistance (UK) Ltd. This email and any files
> transmitted with it, including replies and forwarded copies (which may contain
> alterations) subsequently transmitted from the Company, are confidential and
> solely for the use of the intended recipient. If you are not the intended
> recipient or the person responsible for delivering to the intended recipient,
> be advised that you have received this email in error and that any use is
> strictly prohibited.
>
> If you have received this email in error please notify the IT support desk by
> telephone on +44 (0)208 2393984 or via email to
> [Email Address Removed] including a copy of this message. Please
> then delete this email and destroy any copies of it. Thank you.
>
> Mondial Assistance (UK) Ltd
> Mondial House
> 102 George Street
> Croydon
> CR9 1AJ
>
> Mondial Assistance (UK) Ltd Registered in England No.1710361 Registered
> office as above
> **********************************************************************
>
>
> This message has been checked for all known viruses by the
> MessageLabs Virus Scanning Service. For further information visit
> http://www.messagelabs.com/
>


. . . Tom

Tom Zeblisky
Reuters
631 851 6138




-----------------------------------------------------------------
Visit our Internet site at http://www.reuters.com

Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.
MS Sql Server LazyDBA home page