asked
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.
Thanks Grant, I don't currently see it as a bottleneck, these are the I/O stats that I look at Database Name physical_name GLPAudit S:\SQLDATA\GLPAudit.mdf num_of_reads avg_read_stall_ms num_of_writes avg_write_stall_ms 521286 37.0 97197 10.4 hope that is legible It was only after the disk was presented did I stat thinking about moving it Ger
It's always hard to know if numbers like that are good or bad based on a single reading, but it doesn't seem like that database is seeing much in the way of waits.
12 People are following this question.
