Should I move an Audit Database to a different drive.
Hi, I recently added another LUN to my Production Cluster where I moved some Archive Databases. I also have an audit database which is rarely read. It is mostly updated by triggers. Currently Its mdf file is on the same LUN as the rest of the OLTP databases. Would I Gain if I moved the Audit Database to the new Drive ?
The short answer is yes. You'll always gain performance by throwing disks at your databases. The longer answer is to look to the performance metrics of the system to see if you're hitting bottlenecks and if those bottlenecks are being caused by this database. Start with the wait statistics to understand what is causing the system to run slowly, then correlate those with the query statistics captured through extended events to see which queries are causing those same waits. That'll let you know if that database is the issue and if that issue is focused on the I/O performance.