This is a discussion on TempDB Disk placement with Log files? within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello, I've a couple of questions on setting up my lovely new server... I've decided on R1 (2*36GB) for ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello, I've a couple of questions on setting up my lovely new server... I've decided on R1 (2*36GB) for the OS, R1 (2*73GB) primarily for the Log Files and R5 (5*73GB) for the Data files. I was wondering if I could increase performance by partitioning off/ creating a new volume on my log array and placing on there the tempdb and possibly another volume for the indexes.ndf. Any ideas on whether its OK to have other volumes use the same pysical disks as the log array? And, is it best to have as many data files for each database as there are on your disk array, so 5 in my case (or is it 4 as it's R5 , i.e. 1-n disks). Setup Ideas welcomed! Rob |