Shulou(Shulou.com)05/31 Report--

This article shows you how to solve the problem of Sqlserver table statistics loss, the content is concise and easy to understand, can definitely brighten your eyes, through the detailed introduction of this article, I hope you can get something.

Query the database information of the remote server from the linked server and report an error:

Local database server: 10.0.0.100

Remote database server: 10.0.0.101

Select Company,billno from [10.0.0.101]. Edi.abb.bill where LastUpdateTime between convert (char (10), '2017-09-01) and convert (char (10),' 2017-09-10)

DBCC execution completed. If DBCC outputs an error message, contact your system administrator.

Message 2767, level 16, status 1, procedure sp_table_statistics2_rowset, line 105

The statistics'_ WA_Sys_000000A1_10773619' could not be found in the system directory.

DBCC execution completed. If DBCC outputs an error message, contact your system administrator.

Indicates that statistics are lost on 10.0.0.101.

Temporary solution:

10.0.0.101 is the secondary node of alwayson.

Alwayson has three nodes:

Master node: 10.0.0.105

Secondary Node 1Rank 10.0.0.104

Secondary Node 2Rank 10.0.0.101

Statistics loss occurred on both the secondary node 1RV 10.0.0.104 and the secondary node 2RV 10.0.0.101.

You need to drop this statistic on the primary node.

Drop statistics Abb.Bill._WA_Sys_000000A1_10773619

10.0.0.100 query the same data of the remote database server 10.0.0.101 again will no longer report an error and return to normal.

The above content is how to solve the problem of loss of Sqlserver statistics. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.