patternsqlMinor
is there any point of moving tempdb files into different disk drive if all LUNs are from the same RAID pool?
Viewed 0 times
fromsametheraidtempdbdiskpointallintoany
Problem
According to best practices, it is recommended to move all
I have a virtual server which had originally 4 LUNs from the same
Now the question is, will it make any difference by moving
tempdb (not just tempdb) files into different physical disk. I have a virtual server which had originally 4 LUNs from the same
RAID 10 pool. By the help of volume manager, I converted those 4 LUNs into 4 different volumes. Now the question is, will it make any difference by moving
tempdb into separate volume, or it is just fine to keep them with other SQL Server files in terms of performance?Solution
There are several potential benefits.
- Constraining TempDb Growth
- Making disk-level performance counters more informative.
- Separating the IO Queues so a log write IO never waits behind TempDB IOs in Windows.
- Simplifying storage reconfiguration both in Windows and on the SAN.
- Scaling across SAN controllers and enabling per-lun SAN optimizations.
Context
StackExchange Database Administrators Q#268825, answer score: 4
Revisions (0)
No revisions yet.