Hi

We have a server setup as Raid 1 for the OS C drive
and Raid 5 for the Datafiles and transaction logs D drive.
We have a 3rd party app that creates lots of temporary tables and slows the
server down,

There is over 20 gb free on the C drive do you think it would improve
performance for now if I moved the Tempdb onto the C drive, we have no money
to purchase extra drives or new raid arrays.
Thanks for any Sammy.

That would be a 'workable' solution.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Sammy" <Sammy@discussions.microsoft.com> wrote in message
news5A5179E-C3B5-445C-AEBB-30C33AAFE188@microsoft.com...
> Hi
>
> We have a server setup as Raid 1 for the OS C drive
> and Raid 5 for the Datafiles and transaction logs D drive.
> We have a 3rd party app that creates lots of temporary tables and slows
> the
> server down,
>
> There is over 20 gb free on the C drive do you think it would improve
> performance for now if I moved the Tempdb onto the C drive, we have no
> money
> to purchase extra drives or new raid arrays.
> Thanks for any Sammy.
>
>
>

You might consider moving the log files for both the user db and tempdb to
the C: drive instead. You should test both ways but if you have lots of
writes this may .

--
Andrew J. Kelly SQL MVP

"Sammy" <Sammy@discussions.microsoft.com> wrote in message
news5A5179E-C3B5-445C-AEBB-30C33AAFE188@microsoft.com...
> Hi
>
> We have a server setup as Raid 1 for the OS C drive
> and Raid 5 for the Datafiles and transaction logs D drive.
> We have a 3rd party app that creates lots of temporary tables and slows
> the
> server down,
>
> There is over 20 gb free on the C drive do you think it would improve
> performance for now if I moved the Tempdb onto the C drive, we have no
> money
> to purchase extra drives or new raid arrays.
> Thanks for any Sammy.
>
>
>

I would rather see the log files moved to the C: drive.

Regards,
Hank Arnold

Sammy wrote:
> Hi
>
> We have a server setup as Raid 1 for the OS C drive
> and Raid 5 for the Datafiles and transaction logs D drive.
> We have a 3rd party app that creates lots of temporary tables and slows the
> server down,
>
> There is over 20 gb free on the C drive do you think it would improve
> performance for now if I moved the Tempdb onto the C drive, we have no money
> to purchase extra drives or new raid arrays.
> Thanks for any Sammy.
>
>
>

I do not agree. The RAID-1 array would offer a much better write
performance than the RAID-5 array, even with the O/S contention.

I think the OP solution is the best scenario in the situation, unless
he can break his RAID-5 in multiple RAID-1 and separate the transaction
logs, databases and tempdb.

Regards,
lucm

Andrew J. Kelly wrote:
> You might consider moving the log files for both the user db and tempdb to
> the C: drive instead. You should test both ways but if you have lots of
> writes this may .
>

> > We have a server setup as Raid 1 for the OS C drive
> > and Raid 5 for the Datafiles and transaction logs D drive.
> > We have a 3rd party app that creates lots of temporary tables and slows
> > the
> > server down,
> >
> > There is over 20 gb free on the C drive do you think it would improve
> > performance for now if I moved the Tempdb onto the C drive, we have no
> > money
> > to purchase extra drives or new raid arrays.
> > Thanks for any Sammy.
> >
> >
> >

Well without testing you can say for sure either way. If his app is write
intensive then the logs may be causing a lot of the perf issues. It's hard
to say without knowing more about the system and how it is used. If he has
enough ram then not all the tempdb writes will be physical but the logs will
always be written to disk.

--
Andrew J. Kelly SQL MVP

"lucm" <lucm@iqato.com> wrote in message
news:1163457802.025032.110620@h48g2000cwc.googlegr oups.com...
>
> I do not agree. The RAID-1 array would offer a much better write
> performance than the RAID-5 array, even with the O/S contention.
>
> I think the OP solution is the best scenario in the situation, unless
> he can break his RAID-5 in multiple RAID-1 and separate the transaction
> logs, databases and tempdb.
>
> Regards,
> lucm
>
> Andrew J. Kelly wrote:
>> You might consider moving the log files for both the user db and tempdb
>> to
>> the C: drive instead. You should test both ways but if you have lots of
>> writes this may .
>>
>
>> > We have a server setup as Raid 1 for the OS C drive
>> > and Raid 5 for the Datafiles and transaction logs D drive.
>> > We have a 3rd party app that creates lots of temporary tables and slows
>> > the
>> > server down,
>> >
>> > There is over 20 gb free on the C drive do you think it would improve
>> > performance for now if I moved the Tempdb onto the C drive, we have no
>> > money
>> > to purchase extra drives or new raid arrays.
>> > Thanks for any Sammy.
>> >
>> >
>> >
>