Hi,

Our SQL Server 7 Database (on NT) has database file, log
file, and tempdb all in one drive (RAID 0+1). We are
seeing some disk queues, and are planning on adding an
additional disk.

We have some stored procedures that frequently create temp
tables. Some people are suggesting that we move TempDB to
the new drive. Some people are suggesting that we move Log
to the new drive.

Which one should we move?

Thanks, Anna

Report this post to a moderator

I would move the log to a RAID1 and tempdb to another RAID1 volume.

--
Keith, SQL Server MVP


"Anna Lin" <lliming12@yahoo.com> wrote in message
news:228b01c28ccb$c5466590$89f
82ecf@TK2MSFTNGXA01...
> Hi,
>
> Our SQL Server 7 Database (on NT) has database file, log
> file, and tempdb all in one drive (RAID 0+1). We are
> seeing some disk queues, and are planning on adding an
> additional disk.
>
> We have some stored procedures that frequently create temp
> tables. Some people are suggesting that we move TempDB to
> the new drive. Some people are suggesting that we move Log
> to the new drive.
>
> Which one should we move?
>
> Thanks, Anna

Report this post to a moderator

Hey Keith,

Thanks for replying. If we only have one volume available.
Which one should we move?

Thanks, Anna

>-----Original Message-----
>I would move the log to a RAID1 and tempdb to another
RAID1 volume.
>
>--
>Keith, SQL Server MVP
>
>
>"Anna Lin" <lliming12@yahoo.com> wrote in message
> news:228b01c28ccb$c5466590$89f
82ecf@TK2MSFTNGXA01...
>> Hi,
>>
>> Our SQL Server 7 Database (on NT) has database file, log
>> file, and tempdb all in one drive (RAID 0+1). We are
>> seeing some disk queues, and are planning on adding an
>> additional disk.
>>
>> We have some stored procedures that frequently create
temp
>> tables. Some people are suggesting that we move TempDB
to
>> the new drive. Some people are suggesting that we move
Log
>> to the new drive.
>>
>> Which one should we move?
>>
>> Thanks, Anna
>
>
>.
>

Report this post to a moderator

Hi Anna,

It's suggested that log and data should be separated on different disk
drives. You always want to put log on a separate disk from data for both
fault-tolerance as well as performance reasons. For tempdb, ideally, it
should be placed on a separate drive other than data or log. If money is
stringent, I would at least stick in a mirror set to hold logs.


Richard



"Anna Lin" <lliming12@yahoo.com> wrote in message
news:228b01c28ccb$c5466590$89f
82ecf@TK2MSFTNGXA01...
> Hi,
>
> Our SQL Server 7 Database (on NT) has database file, log
> file, and tempdb all in one drive (RAID 0+1). We are
> seeing some disk queues, and are planning on adding an
> additional disk.
>
> We have some stored procedures that frequently create temp
> tables. Some people are suggesting that we move TempDB to
> the new drive. Some people are suggesting that we move Log
> to the new drive.
>
> Which one should we move?
>
> Thanks, Anna

Report this post to a moderator

Tempdb would probably give you the biggest bang for the buck. However you
still might have disk queueing due to the reads that you are doing on the
table.

--
Keith, SQL Server MVP


"Anna Lin" <lliming12@yahoo.com> wrote in message
news:23cc01c28ccf$60e207e0$8df
82ecf@TK2MSFTNGXA02...
> Hey Keith,
>
> Thanks for replying. If we only have one volume available.
> Which one should we move?
>
> Thanks, Anna
>
> >-----Original Message-----
> >I would move the log to a RAID1 and tempdb to another
> RAID1 volume.
> >
> >--
> >Keith, SQL Server MVP
> >
> >
> >"Anna Lin" <lliming12@yahoo.com> wrote in message
> > news:228b01c28ccb$c5466590$89f
82ecf@TK2MSFTNGXA01...
> >> Hi,
> >>
> >> Our SQL Server 7 Database (on NT) has database file, log
> >> file, and tempdb all in one drive (RAID 0+1). We are
> >> seeing some disk queues, and are planning on adding an
> >> additional disk.
> >>
> >> We have some stored procedures that frequently create
> temp
> >> tables. Some people are suggesting that we move TempDB
> to

> >> the new drive. Some people are suggesting that we move
> Log
> >> to the new drive.
> >>
> >> Which one should we move?
> >>
> >> Thanks, Anna
> >
> >
> >.
> >

Report this post to a moderator