您好,
请检查您在执行查询时候是否发现SQL server有高资源负载情况,想高CPU 使用或者IO 使用,或者SQL 有报错log,现有的描述不太容易推断问题点,如果您的SQL server是多子网集群,请确认使用了Multisubnet Failover = True listener.
更多信息:
Flexible Failover Policy for Automatic Failover of an Availability Group (SQL Server)
http://msdn.microsoft.com/en-us/library/hh710061
SQL Server Native Client Support for High Availability, Disaster Recovery
http://msdn.microsoft.com/en-us/library/gg471494(v=sql.110).aspx
谢谢。
Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com