In SQL Server you can specify the path to database file (.mdf) and log file(.ldf).
When it comes to a server with high no. of transactions and full recovery mode, it is beneficial to have these two paths in two different disks.
Then it will reduce Avg. Disk Queue Length, which is the average number of both read and write requests that were queued for the selected disk during the sample interval, thus resulting a significant improvement in terms of performance.
No comments:
Post a Comment