Jaa

两把利器，帮你深刻洞察SQL Server Azure VM上AlwaysOn高可用（HA）方案的运行状态（Status diagnostics）

  • Artikkeli

 

??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),???:

clip_image001

??Microsoft Azure????(Management Portal)?,???????????????????:

clip_image002

??????,????AlwaysOn???????,????????????(diagnostics)?????,???????????????

??????????SQL Server Management Studio??“View AlwaysOn Health Events”,?????????????(Dashboard)???,???:

clip_image003

?????????????????????,???:

clip_image004

?????,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??,???????????,???????????????,???:

clip_image005

??,??????“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)????:

clip_image006

3. ????????,???????????,???????????????????:

clip_image007

clip_image008

”?????,?????“?????,?????????,??????,????????,???????,???????????????

Comments

  • Anonymous
    September 23, 2014
    最近，在创建Azure虚拟机的时候，我们会发现多了一些新的选择，如下图： 一个明显的变化是出现了一些D系列的虚拟机，相比A系列同编号的虚拟机，内容要大1倍。当然，按照ScottGu的博客，新的虚拟机的CPU更快
  • Anonymous
    December 11, 2014
    The comment has been removed