In recent days past, there was a Performance gain by placing data files, log files, tempdb and backups on different drives. But if my server and all drives are on the same virtual drives/storage....there is no performance gain, right?
-Kevin
There can be, you need to understand what hardware you have, and what the disk specs are.
Data files are random IO based patterns, where are Log files are sequential IO based patterns.
So having physical underlying disks who's specs are better for random IO for the data, and then different physical disks for sequential IO for the logs can give you a lot better performance.
But then there are disks who's random/sequential IO specs are roughly the same so then it doesn't matter.
Heck even in the world of SQL on Azure VM's MSFT are still telling you to separate the data and logs due to benefits in disk caching technologies which are good for the data but bad for the log. Then also to place TempDB on the ephemeral drive. So even in the world of cloud computing the old guidelines are still relevant.
It essentially comes down to knowing your infrastructure and architecture, what you have vs what you don't have and doing load tests with IO simulators to see what you can get out of the various different setups you can get with your hardware, so test with 1 large LUN with everything carved out, test with different LUNs for data and a different LUNs for logs etc and see what you get the better performance out of.
So there's no right or wrong answer, just comes down to knowing what you have and testing the scenarios.
April 1, 2024 at 4:55 am
This was removed by the editor as SPAM
April 1, 2024 at 4:56 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply