ASE Database forum - Win 2003 and tempdb

Author

Win 2003 and tempdb

Guy Bourdon

2006-01-15, 8:24 pm

Installing ASE 12.5.3 with the latest EBF on a HP Proliant ML370 running
Windows 2003 Server.

What is the best location to create tempdb devices. Raid 5 or Raid 0?

Is it possible and advisable to create tempdb devices on the 'swap space'
like "/tmp" on Sun Solaris?

Further is it possible and advisable to create multiple tempdb's on Win
2003?

thanks

Guy Bourdon
Solase Incorporated
Ottawa Ontario Canada

Jason L. Froebe [Team Sybase]

2006-01-16, 11:29 am

Guy Bourdon wrote:
> Installing ASE 12.5.3 with the latest EBF on a HP Proliant ML370 running
> Windows 2003 Server.
>
> What is the best location to create tempdb devices. Raid 5 or Raid 0?
>
> Is it possible and advisable to create tempdb devices on the 'swap space'
> like "/tmp" on Sun Solaris?
>
> Further is it possible and advisable to create multiple tempdb's on Win
> 2003?
>
> thanks
>
> Guy Bourdon
> Solase Incorporated
> Ottawa Ontario Canada
>
>

Hi Guy,

Place tempdb on RAID 0 as we don't have to worry about the recovery of
tempdb (it is just database for temporary data).

--
Jason L. Froebe
http://jfroebe.livejournal.com
Team Sybase

Sponsored Links