x

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.

more ▼

asked May 11 at 02:47 PM in Default

avatar image

godszell
51 2 2 7

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

 
more ▼

answered May 11 at 03:32 PM

avatar image

rvsc49
178 3

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.

May 16 at 09:20 AM godszell
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x47
x41
x30
x29

asked: May 11 at 02:47 PM

Seen: 67 times

Last Updated: May 16 at 09:20 AM

Copyright 2017 Redgate Software. Privacy Policy