SQL Server性能的提高，可通过DBCC DBREINDEX重建索引
复制DBCC SHOWCONTIG scanning ’Employee’ table... Table: ’Employee’ (1195151303); index ID: 1,提高 database ID: 53 TABLE level scan performed. - Pages Scanned................................: 179 - Extents Scanned..............................: 24 - Extent Switches..............................: 24 - Avg. Pages per Extent........................: 7.5 - Scan Density [Best Count:Actual Count].......: 92.00% [23:25] - Logical Scan Fragmentation ..................: 0.56% - Extent Scan Fragmentation ...................: 12.50% - Avg. Bytes Free per Page.....................: 552.3 - Avg. Page Density (full).....................: 93.18% DBCC execution completed. If DBCC printed error messages, contact your system administrator. 1.2.3.4.5.6.7.8.9.10.11.
本文地址：http://www.bzve.cn/news/429a9699474.html
版权声明
本文仅代表作者观点，不代表本站立场。
本文系作者授权发表，未经许可，不得转载。