swap space and tempdb

[Former Member]

Hi,

I'm having RAID 1 and RAID 5. RAID 1 is partitioned into 3 drive letters, C, D, and E. RAID 5 got only 1 partition, which is drive F. C for OS, D for SAP Kernel, E for Transaction Log and F for SAP Data.

In which drive should I allocate for swap space and tempdb? Of course for better performance I should have got separate hard disk for these, but unfortunately I can't.

Any suggestion.

BTW, my platform is Windows 2003 Enterprise and SQL Server 2005.

Rgds,

Hapizorr

[Former Member]

Dear Hapizorr,

I recommend you review this document developed by Microsoft specifically for SAP systems:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/4ab89e84-0d01-0010-cda2-82d...

This will answer your question.

Thanks

N.P.C

[Former Member]

Hello Hapizorr,

If You use BW - tempdb database is typically 1,5 times the size of the largest SAP table.

SAP recomends RAID 1 for tempdb and separate disc.

In my system tempdb is on same disc as transaction log files.

Regards,

Marcin Gajewski