SQL Server DBA

摘要：Safety FULL with Witness :Well the answer for this ‘depends on the mode in which mirroring is configured’. If mirroring is configured in High Availability mode (Full safety) then we don’t need to worry about failover as the mirror server will form a quorum with witness and will initiate an automatic 阅读全文

摘要：Windows Server 2008 R2 En Enterprise 64bitSQL Server 2008 R2 En Enterprise 64bit症状：在performance monitor中看不到Sql Server相关的性能计数器解决办法：Rebuilding the counters: cd c:\windows\system32 lodctr /R cd c:\windows\sysWOW64 lodctr /RResyncing the counters with Windows Management Instrumentation (... 阅读全文