На сервере MS SQL посмотреть процент фрагментации ключей:
SELECT a.index_id, name, avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats(DB_ID(N'DBname1'), OBJECT_ID(N'dbo.Регистрация'), NULL, NULL, NULL) AS a JOIN
sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = b.index_id;
SELECT a.index_id, name, avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats(DB_ID(N'DBname1'), OBJECT_ID(N'dbo.Регистрация'), NULL, NULL, NULL) AS a JOIN
sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = b.index_id;
Комментариев нет:
Отправить комментарий