We have a Microsoft SQL Server (SQL Server 2012 SP3), we've noticed that transaction log I/O is very high. We do have a busy server; we're hosted at Rackspace with SSD block storage. The Logs are are their own partition, and the log is set to "auto grow" and is about 70GB in size (data file is about 100GB)
Any thoughts on how to improve I/O performance for the transaction logs? We have a sense that it's affecting performance.
- Transaction Logs are backedup every 30 minutes
- I/O on the transaction log partition is 47% during normal activity and when we run one of our jobs it goes to 90%+
- We have a 8 vCPU cloud server and we have 8 temp db and 8 temp log
- Attached performance graphsdb performance graph
I should mention that we don't have a DBA, I do have some SQL experience and we have SQL developers.
DBCC Log (info) shows 456 rows
NEW QUESTION: Could it be that my transaction log at 60GB is TOO LARGE? Would I get less I/O making the trans log smaller, say 20GB-30GB?