Shulou(Shulou.com)06/01 Report--

Environment:

Sqlserver2014 alwayson architecture

1 master node

1 secondary standby node

6 auxiliary query nodes

Problem phenomenon:

A script never gets out of the master node.

But in the auxiliary query node quickly ran out.

The query found that the statistics of a key large table were stale in the SQL statement that the master node could not get out of all the time.

The statistics of this table are updated at the master node.

UPDATE STATISTICS table1

After updating the statistics of the table, the script ran out of the master node very quickly.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.