Tempdb / sapdata files best practice - MS SQL 2012/2014

[#1]

Hi

We are migrating our BW system to MS SQL 2012 on windows.

Our approach:

C: OS + SQL Server Software

😧 SAPDATA files for BW ABAP & PORTAL (total 16 data files) + TEMP DB

E: Database Logs + Temp Logs
F: SWAP

Would like to know the following

- Placement of Tempdb, we are using flash drive, do we still need to place tempdb in a separate drive say T: drive only for Tempdb?

- Do we need to split BW ABAP Data files and Portal Datafiles in a separate drive? or they both can reside in the same drive?

-

I went thru the recent best practice guide, nowhere they have mentioned to place tempdb in a separate drive.

Your guidance is highly appreciated.

Thanks

[Former Member]

Hello,

The provisioning of Flash drives for TempDB will give you the IO required for a transactional system. However, it is still recommended to place TempDB on its own drives (data and log separate) for segregating logical R/W activity and better monitoring and reporting in case you start seeing any contention.

For a BW workload, please research Trace flags 1118

Hope this helps.