两把利器，帮你深刻洞察SQL Server Azure VM上AlwaysOn高可用（HA）方案的运行状态（Status diagnostics）
??Microsoft Azure????????(Business Critical),???????????????;???Azure IaaS(???????),?Azure VM???SQL Server???,????????,??AlwaysOn?????????(Failover Cluster)????????????
??,????????????????(Microsoft Virtual Academy,MVA)?????,???:«?Windows Azure VM???SQL Server?????????»,????????Azure VM???SQL Server AlwaysOn????????????,?????:
https://www.microsoftvirtualacademy.com/training-courses/835
?????Azure???,??????????AlwaysOn Failover??,?????SQL Server 2012?SQL Server 2014???,???????????(Virtual Network)?????????(Domain Controller),???:
??Microsoft Azure????(Management Portal)?,???????????????????:
??????,????AlwaysOn???????,????????????(diagnostics)?????,???????????????
??????????SQL Server Management Studio??“View AlwaysOn Health Events”,?????????????(Dashboard)???,???:
?????????????????????,???:
?????,AlwaysOn???????,?????????????????????????,?????????????????
????????????????????????????????
?????:?SQL Server?ErrLog???????????????:
SQL Server 2014:
<Data Drive>:\Program Files\Microsoft SQL Server\MSSQL12.<instance name>\MSSQL\Log
SQL Server 2012:
<Data Drive>:\Program Files\Microsoft SQL Server\MSSQL11.<instance name>\MSSQL\Log
??,<Data Drive>?SQL Server???????;<instance name>?????????????????????????
?????,???????ERRLOG??,???????????,???????????????,???:
??,??????“AlwaysOn”?“Availability”?“fail”???,???????????????
?????SQL Server AlwaysOn?????,???Failover Cluster???,?????????????????
???????????????????,?????:
1. ?SQL Server??????Administrator??,??PowerShell????
2. ???????:
Get-ClusterLog -Destination <Destination Directory>
??,<Destination Directory>???????????????????,??e:\
????????,??:https://technet.microsoft.com/en-us/library/ee461045.aspx
??????,???????????????????,?????????(????????????????,????????????100M)????:
3. ????????,???????????,???????????????????:
”?????,?????“?????,?????????,??????,????????,???????,???????????????