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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy