Environment - SQL 2012 Enterprise SP3 Stand-Alone Storage - CSVs
We are using AlwaysOn Availability Group setup for SharePoint Databases and from last 2 instances we noticed when we do Transaction Log Shrink operation (small chunks ~500MB) there are I/O issues recorded in the SQL Error Logs and the SharePoint goes down for couple of minutes.
Thank you in advance for your answers, I'll be awaiting to hear about it.
Can a shrink operation become the cause for the I/O issues? It is probably more the opposite - I/O issues are causing shrink operation or other performance issues. Can you run these queries and post the results when the shrink operation is occurring?
answered May 11, 2017 at 03:32 PM