May 16, 2016 at 9:36 am
I have the following issue. I have a SQL 2012 server shared storage failover cluster install on a windows 2008R2 cluster server. I have been noticing that the following file has been filling up my drive
<HOSTNAME>_<INSTANCENAME>_SQLDIAG_X_XXXXXXXXX.xel
According to MS this is the AlwaysOn Health Diagnostics Log. I need to set the parameters for this, ie number of files, size of file etc. But cannot find this information anywhere.
May 17, 2016 at 7:44 am
what FailureConditionLevel do you have set for the Availability group
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 17, 2016 at 7:54 am
VerboseLogging = 0
SqlDumperDumpFlags = 0
SqlDumperDumpPath = ''
SqlDumpTimeOut = 0
SqlPreStatupActionsFlags = 0
FailureConditionLevel = 3
HealthCheckTimeout=60000
SqlDMVScriptTimeOut = 0
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply