question

godszell avatar image
godszell 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.
always-onstoragesql 2012sharepoint
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
rvsc49 avatar image
rvsc49 answered
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
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you for the note and the query, the situation is not yet repeated and we have not shrunk the files. We will soon do it in Off Business hours and will send the output.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.