asked
Does Always On Availability Group supports Clustered Shared Volumes (CSV) ??
Hi All, **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. Questions: - Does AlwaysOn Availability Group supports CSVs? - Can a shrink operation became cause for the I/O issues? 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? SELECT COUNT (*) AS [PendingIOs], DB_NAME ([vfs].[database_id]) AS [DBName], [mf].[name] AS [FileName], [mf].[type_desc] AS [FileType], SUM ([pior].[io_pending_ms_ticks]) AS [TotalStall] FROM sys.dm_io_pending_io_requests AS [pior] JOIN sys.dm_io_virtual_file_stats (NULL, NULL) AS [vfs] ON [vfs].[file_handle] = [pior].[io_handle] JOIN sys.master_files AS [mf] ON [mf].[database_id] = [vfs].[database_id] AND [mf].[file_id] = [vfs].[file_id] WHERE [pior].[io_pending] = 1 GROUP BY [vfs].[database_id], [mf].[name], [mf].[type_desc] ORDER BY [vfs].[database_id], [mf].[name]; -- SELECT [log_reuse_wait_desc] FROM sys.databases --WHERE [name] = N''; GO
19 People are following this question.
