Sample Header Ad - 728x90

Performance of temp db files on SAN

1 vote
1 answer
263 views
It is generally recommended to put the tempdb database on disks that differ from those that are used by user databases. I have 4 databases on my sql server, ranging from 5GB to 300GB in size. D: drive is used for user dbs E: drive for log files F: drive for tempdb Note: the drives are logical. They are not physically separate drives because they belong to SAN. Effectively this means that - based on SAN/RAID level, the data will be physically stored/spread across multiple disks. Is this a concern and going against the above recommendation?
Asked by variable (3590 rep)
Oct 31, 2021, 01:46 AM
Last activity: Nov 1, 2021, 02:57 PM