zsy001 发表于 2016-11-2 08:58:10

SQL Server 2005CPU占用高100%

truncate table


SELECT
object_name(a.object_id)
,a.index_id
,name
,avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats
(
DB_ID()
, NULL
, NULL, NULL, NULL
) AS a
JOIN sys.indexes AS b
ON a.object_id = b.object_id AND a.index_id = b.index_id;


ALTER INDEX ALL ON .
REBUILD WITH (
SORT_IN_TEMPDB = ON
,STATISTICS_NORECOMPUTE = ON
,ONLINE = ON);
页: [1]
查看完整版本: SQL Server 2005CPU占用高100%