{"id":36705,"date":"2019-10-31T22:13:15","date_gmt":"2019-10-31T19:13:15","guid":{"rendered":"https:\/\/prohoster.info\/blog\/obzor-besplatnogo-instrumenta-sqlindexmanager\/"},"modified":"2019-10-31T22:13:15","modified_gmt":"2019-10-31T19:13:15","slug":"obzor-besplatnogo-instrumenta-sqlindexmanager","status":"publish","type":"post","link":"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/obzor-besplatnogo-instrumenta-sqlindexmanager","title":{"rendered":"\u00dcberblick \u00fcber das kostenlose Tool SQLIndexManager","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>\u041a\u0430\u043a \u0438\u0437\u0432\u0435\u0441\u0442\u043d\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u044b \u0438\u0433\u0440\u0430\u044e\u0442 \u0432\u0430\u0436\u043d\u0443\u044e \u0440\u043e\u043b\u044c \u0432 \u0421\u0423\u0411\u0414, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044f \u0431\u044b\u0441\u0442\u0440\u044b\u0439 \u043f\u043e\u0438\u0441\u043a \u043a \u043d\u0443\u0436\u043d\u044b\u043c \u0437\u0430\u043f\u0438\u0441\u044f\u043c. \u041f\u043e\u0442\u043e\u043c\u0443 \u0442\u0430\u043a \u0432\u0430\u0436\u043d\u043e \u0438\u0445 \u0441\u0432\u043e\u0435\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u0442\u044c. \u041e\u0431 \u0430\u043d\u0430\u043b\u0438\u0437\u0435 \u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u043c\u043d\u043e\u0433\u043e \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u0430, \u0432 \u0442\u043e\u043c \u0447\u0438\u0441\u043b\u0435 \u0438 \u0432 \u0418\u043d\u0442\u0435\u0440\u043d\u0435\u0442\u0435. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043d\u0435\u0434\u0430\u0432\u043d\u043e \u0434\u0435\u043b\u0430\u043b\u0441\u044f \u043e\u0431\u0437\u043e\u0440 \u0434\u0430\u043d\u043d\u043e\u0439 \u0442\u0435\u043c\u044b \u0432 <noindex><a rel=\"nofollow\" href=\"https:\/\/towardsdatascience.com\/sql-server-index-analysis-and-optimization-1edd84d9da\">\u044d\u0442\u043e\u0439 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0438<\/a><\/noindex>.<\/p>\n<p>\u0421\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442 \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u043e \u043a\u0430\u043a \u043f\u043b\u0430\u0442\u043d\u044b\u0445, \u0442\u0430\u043a \u0438 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u044b\u0445 \u0440\u0435\u0448\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u044d\u0442\u043e\u0433\u043e. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0435\u0441\u0442\u044c \u0433\u043e\u0442\u043e\u0432\u043e\u0435 <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Microsoft\/tigertoolbox\/tree\/master\/AdaptiveIndexDefrag\">\u0440\u0435\u0448\u0435\u043d\u0438\u0435<\/a><\/noindex>, \u043e\u0441\u043d\u043e\u0432\u0430\u043d\u043d\u043e\u0435 \u043d\u0430 \u0430\u0434\u0430\u043f\u0442\u0438\u0432\u043d\u043e\u043c \u043c\u0435\u0442\u043e\u0434\u0435 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432.<\/p>\n<p>\u0414\u0430\u043b\u0435\u0435 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u0443\u044e \u0443\u0442\u0438\u043b\u0438\u0442\u0443 <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sergeysyrovatchenko\/SQLIndexManager\">SQLIndexManager<\/a><\/noindex>, \u0430\u0432\u0442\u043e\u0440\u043e\u043c \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/users\/alandenton\/\" class=\"user_link\">AlanDenton<\/a><\/noindex>.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\n\u041e\u0441\u043d\u043e\u0432\u043d\u043e\u0435 \u0442\u0435\u0445\u043d\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0440\u0430\u0437\u043b\u0438\u0447\u0438\u0435 \u043c\u0435\u0436\u0434\u0443 SQLIndexManager \u0438 \u0440\u044f\u0434\u0430 \u0434\u0440\u0443\u0433\u0438\u0445 \u0430\u043d\u0430\u043b\u043e\u0433\u043e\u0432 \u043f\u0440\u0438\u0432\u043e\u0434\u0438\u0442 \u0441\u0430\u043c \u0430\u0432\u0442\u043e\u0440 <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/459914\/\">\u0437\u0434\u0435\u0441\u044c<\/a><\/noindex> \u0438 <noindex><a rel=\"nofollow\" href=\"https:\/\/www.codeproject.com\/Articles\/5162340\/SQL-Index-Manager-Free-GUI-Tool-for-Index-Maintena\">\u0437\u0434\u0435\u0441\u044c<\/a><\/noindex>.<\/p>\n<p>\u0412 \u044d\u0442\u043e\u0439 \u0436\u0435 \u0441\u0442\u0430\u0442\u044c\u0435 \u0441\u043e \u0441\u0442\u043e\u0440\u043e\u043d\u044b \u0432\u0437\u0433\u043b\u044f\u043d\u0435\u043c \u043d\u0430 \u043f\u0440\u043e\u0435\u043a\u0442 \u0438 \u043d\u0430 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u044d\u043a\u0441\u043f\u043b\u0443\u0430\u0442\u0430\u0446\u0438\u0438 \u0434\u0430\u043d\u043d\u043e\u0433\u043e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043d\u043e\u0433\u043e \u0440\u0435\u0448\u0435\u043d\u0438\u044f.<\/p>\n<p>\u041e\u0431\u0441\u0443\u0436\u0434\u0430\u044e\u0442 \u0434\u0430\u043d\u043d\u0443\u044e \u0443\u0442\u0438\u043b\u0438\u0442\u0443 <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sql.ru\/forum\/1312218-1\/sql-index-manager-besplatnaya-utilita-po-obsluzhivaniu-indeksov-dlya-sql-server-i-azure\">\u0437\u0434\u0435\u0441\u044c<\/a><\/noindex>.<br \/>\n\u0421\u043e \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c \u0431\u043e\u043b\u044c\u0448\u0430\u044f \u0447\u0430\u0441\u0442\u044c \u0437\u0430\u043c\u0435\u0447\u0430\u043d\u0438\u0439 \u0438 \u0431\u0430\u0433\u043e\u0432 \u0431\u044b\u043b\u0438 \u0438\u0441\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u044b.<\/p>\n<p>\u0418\u0442\u0430\u043a, \u043f\u0435\u0440\u0435\u0439\u0434\u0435\u043c \u0442\u0435\u043f\u0435\u0440\u044c \u043a \u0441\u0430\u043c\u043e\u0439 \u0443\u0442\u0438\u043b\u0438\u0442\u0435 SQLIndexManager.<\/p>\n<p>\u041f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 C# .NET Framework 4.5 \u0432 Visual Studio 2017 \u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442 DevExpress \u0434\u043b\u044f \u0444\u043e\u0440\u043c:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/i0\/wo\/do\/i0wodozvszemgmmash24snfzrgk.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/641ddf5c0e7d84228a1e8fced89b8ac2.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u0438 \u0432\u044b\u0433\u043b\u044f\u0434\u0438\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/xc\/mf\/ac\/xcmfacmb7wxiz5pfvg5m2ybyet4.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/e3015847757749b63b3959909a5b6eab.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u0412\u0441\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0444\u043e\u0440\u043c\u0438\u0440\u0443\u044e\u0442\u0441\u044f \u0432 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0445 \u0444\u0430\u0439\u043b\u0430\u0445:<\/p>\n<ol>\n<li>Index<\/li>\n<li>Query<\/li>\n<li>QueryEngine<\/li>\n<li>ServerInfo<\/li>\n<\/ol>\n<p>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/ya\/ox\/fo\/yaoxfojk1yhfujv5nhu8wxfjx64.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/c702f6d64fd9b290f0e251253fb19c9a.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u041f\u0440\u0438 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0438 \u043a \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043a \u0421\u0423\u0411\u0414, \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u043f\u043e\u0434\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u0442\u0441\u044f \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c:<\/p>\n<pre><code class=\"1c\">ApplicationName=\u201dSQLIndexManager\u201d<\/code><\/pre>\n<p>\n\u041f\u0440\u0438 \u0437\u0430\u043f\u0443\u0441\u043a\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u043e\u0442\u043a\u0440\u043e\u0435\u0442\u0441\u044f \u043c\u043e\u0434\u0430\u043b\u044c\u043d\u043e\u0435 \u043e\u043a\u043d\u043e \u043d\u0430 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f:<br \/>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/77\/kw\/uh\/77kwuhjmxnartbvfvmpnk8fpi7k.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/0d48a916318591365bf4839fcfaf6985.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u0417\u0434\u0435\u0441\u044c \u043f\u043e\u043a\u0430 \u043d\u0435 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u043f\u043e\u0434\u0433\u0440\u0443\u0437\u043a\u0430 \u043f\u043e\u043b\u043d\u043e\u0433\u043e \u0441\u043f\u0438\u0441\u043a\u0430 \u0432\u0441\u0435\u0445 \u044d\u043a\u0437\u0435\u043c\u043f\u043b\u044f\u0440\u043e\u0432 MS SQL Server, \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0445 \u043f\u043e \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u044b\u043c \u0441\u0435\u0442\u044f\u043c.<\/p>\n<p>\u0422\u0430\u043a\u0436\u0435 \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u043c\u043e\u0436\u043d\u043e \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043a\u0440\u0430\u0439\u043d\u0435\u0439 \u043b\u0435\u0432\u043e\u0439 \u043a\u043d\u043e\u043f\u043a\u0438 \u043d\u0430 \u0433\u043b\u0430\u0432\u043d\u043e\u043c \u043c\u0435\u043d\u044e:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/id\/l0\/w_\/idl0w_a4afakmyqmegzbrbomksc.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/2d5da9ec80e4b07a73b5e4adcc8611f2.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u0414\u0430\u043b\u0435\u0435 \u0437\u0430\u043f\u0443\u0441\u0442\u044f\u0442\u0441\u044f \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u043a \u0421\u0423\u0411\u0414:<\/p>\n<ol>\n<li><b class=\"spoiler_title\">\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u043e \u0421\u0423\u0411\u0414<\/b>\n<pre><code class=\"sql\">SELECT ProductLevel  = SERVERPROPERTY('ProductLevel')\n     , Edition       = SERVERPROPERTY('Edition')\n     , ServerVersion = SERVERPROPERTY('ProductVersion')\n     , IsSysAdmin    = CAST(IS_SRVROLEMEMBER('sysadmin') AS BIT)\n<\/code><\/pre>\n<p>\n<\/li>\n<li><b class=\"spoiler_title\">\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0445 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0441 \u0438\u0445 \u043a\u0440\u0430\u0442\u043a\u0438\u043c\u0438 \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430\u043c\u0438<\/b>\n<pre><code class=\"sql\">SELECT DatabaseName = t.[name]\n     , d.DataSize\n     , DataUsedSize  = CAST(NULL AS BIGINT)\n     , d.LogSize\n     , LogUsedSize   = CAST(NULL AS BIGINT)\n     , RecoveryModel = t.recovery_model_desc\n     , LogReuseWait  = t.log_reuse_wait_desc\nFROM sys.databases t WITH(NOLOCK)\nLEFT JOIN (\n    SELECT [database_id]\n         , DataSize = SUM(CASE WHEN [type] = 0 THEN CAST(size AS BIGINT) END)\n         , LogSize  = SUM(CASE WHEN [type] = 1 THEN CAST(size AS BIGINT) END)\n    FROM sys.master_files WITH(NOLOCK)\n    GROUP BY [database_id]\n) d ON d.[database_id] = t.[database_id]\nWHERE t.[state] = 0\n    AND t.[database_id] != 2\n    AND ISNULL(HAS_DBACCESS(t.[name]), 1) = 1\n<\/code><\/pre>\n<p>\n<\/li>\n<\/ol>\n<p>\n\u041f\u043e\u0441\u043b\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0432\u044b\u0448\u0435\u0443\u043a\u0430\u0437\u0430\u043d\u043d\u044b\u0445 \u0441\u043a\u0440\u0438\u043f\u0442\u043e\u0432 \u043f\u043e\u044f\u0432\u0438\u0442\u0441\u044f \u043e\u043a\u043d\u043e, \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0449\u0435\u0435 \u043a\u0440\u0430\u0442\u043a\u0443\u044e \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u043e \u0431\u0430\u0437\u0430\u0445 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u044b\u0431\u0440\u0430\u043d\u043d\u043e\u0433\u043e \u044d\u043a\u0437\u0435\u043c\u043f\u043b\u044f\u0440\u0430 MS SQL Server:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/bc\/fy\/gz\/bcfygzsztslx32ll82uxflshfhi.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/1010b730b01baa06d6a0e81e92b5b677.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u0421\u0442\u043e\u0438\u0442 \u043e\u0442\u043c\u0435\u0442\u0438\u0442\u044c, \u0447\u0442\u043e \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u043d\u0430\u044f \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044f \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f, \u0438\u0441\u0445\u043e\u0434\u044f \u0438\u0437 \u043f\u0440\u0430\u0432. \u0415\u0441\u043b\u0438 \u0435\u0441\u0442\u044c <noindex><a rel=\"nofollow\" href=\"https:\/\/docs.microsoft.com\/ru-ru\/sql\/relational-databases\/security\/authentication-access\/server-level-roles?view=sql-server-2017\">sysadmin<\/a><\/noindex>, \u0442\u043e \u043c\u043e\u0436\u043d\u043e \u0432\u044b\u0431\u0438\u0440\u0430\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u0438\u0437 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u044f <noindex><a rel=\"nofollow\" href=\"https:\/\/docs.microsoft.com\/ru-ru\/sql\/relational-databases\/system-catalog-views\/sys-master-files-transact-sql?view=sql-server-2017\">sys.master_files<\/a><\/noindex>. \u0415\u0441\u043b\u0438 \u0442\u0430\u043a\u0438\u0445 \u043f\u0440\u0430\u0432 \u043d\u0435\u0442, \u0442\u043e \u043f\u0440\u043e\u0441\u0442\u043e \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442\u0441\u044f \u043c\u0435\u043d\u044c\u0448\u0435 \u0434\u0430\u043d\u043d\u044b\u0445, \u0447\u0442\u043e\u0431\u044b \u043d\u0435 \u0437\u0430\u043c\u0435\u0434\u043b\u044f\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441.<\/p>\n<p>\u0417\u0434\u0435\u0441\u044c \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0432\u044b\u0431\u0440\u0430\u0442\u044c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0443\u044e\u0449\u0438\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u043d\u0430\u0436\u0430\u0442\u044c \u043d\u0430 \u043a\u043d\u043e\u043f\u043a\u0443 \u201c\u041e\u041a\u201d.<\/p>\n<p>\u0414\u0430\u043b\u0435\u0435 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0441\u043a\u0440\u0438\u043f\u0442 \u0434\u043b\u044f \u043a\u0430\u0436\u0434\u043e\u0439 \u0432\u044b\u0431\u0440\u0430\u043d\u043d\u043e\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u044f \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432:<\/p>\n<p><b class=\"spoiler_title\">\u0410\u043d\u0430\u043b\u0438\u0437 \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u044f \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432<\/b><\/p>\n<pre><code class=\"sql\">declare @Fragmentation float=15;\ndeclare @MinIndexSize bigint=768;\ndeclare @MaxIndexSize bigint=1048576;\ndeclare @PreDescribeSize bigint=32768;\n\nSET NOCOUNT ON\nSET ARITHABORT ON\nSET NUMERIC_ROUNDABORT OFF\n\nIF OBJECT_ID('tempdb.dbo.#AllocationUnits') IS NOT NULL\n    DROP TABLE #AllocationUnits\n\nCREATE TABLE #AllocationUnits (\n      ContainerID   BIGINT PRIMARY KEY\n    , ReservedPages BIGINT NOT NULL\n    , UsedPages     BIGINT NOT NULL\n)\n\nINSERT INTO #AllocationUnits (ContainerID, ReservedPages, UsedPages)\nSELECT [container_id]\n     , SUM([total_pages])\n     , SUM([used_pages])\nFROM sys.allocation_units WITH(NOLOCK)\nGROUP BY [container_id]\nHAVING SUM([total_pages]) BETWEEN @MinIndexSize AND @MaxIndexSize\n\nIF OBJECT_ID('tempdb.dbo.#ExcludeList') IS NOT NULL\n    DROP TABLE #ExcludeList\n\nCREATE TABLE #ExcludeList (ID INT PRIMARY KEY)\n\nINSERT INTO #ExcludeList\nSELECT [object_id]\nFROM sys.objects WITH(NOLOCK)\nWHERE [type] IN ('V', 'U')\n    AND ( [is_ms_shipped] = 1 )\n\nIF OBJECT_ID('tempdb.dbo.#Partitions') IS NOT NULL\n    DROP TABLE #Partitions\n\nSELECT [object_id]\n     , [index_id]\n     , [partition_id]\n     , [partition_number]\n     , [rows]\n     , [data_compression]\nINTO #Partitions\nFROM sys.partitions WITH(NOLOCK)\nWHERE [object_id] &gt; 255\n    AND [rows] &gt; 0\n    AND [object_id] NOT IN (SELECT * FROM #ExcludeList)\n\nIF OBJECT_ID('tempdb.dbo.#Indexes') IS NOT NULL\n    DROP TABLE #Indexes\n\nCREATE TABLE #Indexes (\n      ObjectID         INT NOT NULL\n    , IndexID          INT NOT NULL\n    , IndexName        SYSNAME NULL\n    , PagesCount       BIGINT NOT NULL\n    , UnusedPagesCount BIGINT NOT NULL\n    , PartitionNumber  INT NOT NULL\n    , RowsCount        BIGINT NOT NULL\n    , IndexType        TINYINT NOT NULL\n    , IsAllowPageLocks BIT NOT NULL\n    , DataSpaceID      INT NOT NULL\n    , DataCompression  TINYINT NOT NULL\n    , IsUnique         BIT NOT NULL\n    , IsPK             BIT NOT NULL\n    , FillFactorValue  INT NOT NULL\n    , IsFiltered       BIT NOT NULL\n    , PRIMARY KEY (ObjectID, IndexID, PartitionNumber)\n)\n\nINSERT INTO #Indexes\nSELECT ObjectID         = i.[object_id]\n     , IndexID          = i.index_id\n     , IndexName        = i.[name]\n     , PagesCount       = a.ReservedPages\n     , UnusedPagesCount = CASE WHEN ABS(a.ReservedPages - a.UsedPages) &gt; 32 THEN a.ReservedPages - a.UsedPages ELSE 0 END\n     , PartitionNumber  = p.[partition_number]\n     , RowsCount        = ISNULL(p.[rows], 0)\n     , IndexType        = i.[type]\n     , IsAllowPageLocks = i.[allow_page_locks]\n     , DataSpaceID      = i.[data_space_id]\n     , DataCompression  = p.[data_compression]\n     , IsUnique         = i.[is_unique]\n     , IsPK             = i.[is_primary_key]\n     , FillFactorValue  = i.[fill_factor]\n     , IsFiltered       = i.[has_filter]\nFROM #AllocationUnits a\nJOIN #Partitions p ON a.ContainerID = p.[partition_id]\nJOIN sys.indexes i WITH(NOLOCK) ON i.[object_id] = p.[object_id] AND p.[index_id] = i.[index_id] \nWHERE i.[type] IN (0, 1, 2, 5, 6)\n    AND i.[object_id] &gt; 255\n\nDECLARE @files TABLE (ID INT PRIMARY KEY)\nINSERT INTO @files\nSELECT DISTINCT [data_space_id]\nFROM sys.database_files WITH(NOLOCK)\nWHERE [state] != 0\n    AND [type] = 0\n\nIF @@ROWCOUNT &gt; 0 BEGIN\n\n    DELETE FROM i\n    FROM #Indexes i\n    LEFT JOIN sys.destination_data_spaces dds WITH(NOLOCK) ON i.DataSpaceID = dds.[partition_scheme_id] AND i.PartitionNumber = dds.[destination_id]\n    WHERE ISNULL(dds.[data_space_id], i.DataSpaceID) IN (SELECT * FROM @files)\n\nEND\n\n\nDECLARE @DBID   INT\n      , @DBNAME SYSNAME\n\nSET @DBNAME = DB_NAME()\nSELECT @DBID = [database_id]\nFROM sys.databases WITH(NOLOCK)\nWHERE [name] = @DBNAME\n\nIF OBJECT_ID('tempdb.dbo.#Fragmentation') IS NOT NULL\n    DROP TABLE #Fragmentation\n\nCREATE TABLE #Fragmentation (\n      ObjectID         INT NOT NULL\n    , IndexID          INT NOT NULL\n    , PartitionNumber  INT NOT NULL\n    , Fragmentation    FLOAT NOT NULL\n    , PRIMARY KEY (ObjectID, IndexID, PartitionNumber)\n)\n\nINSERT INTO #Fragmentation (ObjectID, IndexID, PartitionNumber, Fragmentation)\nSELECT i.ObjectID\n     , i.IndexID\n     , i.PartitionNumber\n     , r.[avg_fragmentation_in_percent]\nFROM #Indexes i\nCROSS APPLY sys.dm_db_index_physical_stats(@DBID, i.ObjectID, i.IndexID, i.PartitionNumber, 'LIMITED') r\nWHERE i.PagesCount &lt;= @PreDescribeSize\n    AND r.[index_level] = 0\n    AND r.[alloc_unit_type_desc] = 'IN_ROW_DATA'\n    AND i.IndexType IN (0, 1, 2)\n\nIF OBJECT_ID('tempdb.dbo.#Columns') IS NOT NULL\n    DROP TABLE #Columns\n\nCREATE TABLE #Columns (\n      ObjectID     INT NOT NULL\n    , ColumnID     INT NOT NULL\n    , ColumnName   SYSNAME NULL\n    , SystemTypeID TINYINT NULL\n    , IsSparse     BIT\n    , IsColumnSet  BIT\n    , MaxLen       INT\n    , PRIMARY KEY (ObjectID, ColumnID)\n)\n\nINSERT INTO #Columns\nSELECT ObjectID     = [object_id]\n     , ColumnID     = [column_id]\n     , ColumnName   = [name]\n     , SystemTypeID = [system_type_id]\n     , IsSparse     = [is_sparse]\n     , IsColumnSet  = [is_column_set]\n     , MaxLen       = [max_length]\nFROM sys.columns WITH(NOLOCK)\nWHERE [object_id] IN (SELECT DISTINCT i.ObjectID FROM #Indexes i)\n\nIF OBJECT_ID('tempdb.dbo.#IndexColumns') IS NOT NULL\n    DROP TABLE #IndexColumns\n\nCREATE TABLE #IndexColumns (\n      ObjectID   INT NOT NULL\n    , IndexID    INT NOT NULL\n    , OrderID    INT NOT NULL\n    , ColumnID   INT NOT NULL\n    , IsIncluded BIT NOT NULL\n    , PRIMARY KEY (ObjectID, IndexID, ColumnID)\n)\n\nINSERT INTO #IndexColumns\nSELECT ObjectID   = [object_id]\n     , IndexID    = [index_id]\n     , OrderID    = CASE WHEN [is_included_column] = 0 THEN [key_ordinal] ELSE [index_column_id] END\n     , ColumnID   = [column_id]\n     , IsIncluded = ISNULL([is_included_column], 0)\nFROM sys.index_columns ic WITH(NOLOCK)\nWHERE EXISTS(\n        SELECT *\n        FROM #Indexes i\n        WHERE i.ObjectID = ic.[object_id]\n            AND i.IndexID = ic.[index_id]\n            AND i.IndexType IN (1, 2)\n    )\n\nIF OBJECT_ID('tempdb.dbo.#Lob') IS NOT NULL\n    DROP TABLE #Lob\n\nCREATE TABLE #Lob (\n      ObjectID    INT NOT NULL\n    , IndexID     INT NOT NULL\n    , IsLobLegacy BIT\n    , IsLob       BIT\n    , PRIMARY KEY (ObjectID, IndexID)\n)\n\nINSERT INTO #Lob (ObjectID, IndexID, IsLobLegacy, IsLob)\nSELECT c.ObjectID\n     , IndexID     = ISNULL(i.IndexID, 1)\n     , IsLobLegacy = MAX(CASE WHEN c.SystemTypeID IN (34, 35, 99) THEN 1 END)\n     , IsLob       = 0\nFROM #Columns c\nLEFT JOIN #IndexColumns i ON c.ObjectID = i.ObjectID AND c.ColumnID = i.ColumnID\nWHERE c.SystemTypeID IN (34, 35, 99)\nGROUP BY c.ObjectID\n       , i.IndexID\n\nIF OBJECT_ID('tempdb.dbo.#Sparse') IS NOT NULL\n    DROP TABLE #Sparse\n\nCREATE TABLE #Sparse (ObjectID INT PRIMARY KEY)\nINSERT INTO #Sparse\nSELECT DISTINCT ObjectID\nFROM #Columns\nWHERE IsSparse = 1\n    OR IsColumnSet = 1\n\nIF OBJECT_ID('tempdb.dbo.#AggColumns') IS NOT NULL\n    DROP TABLE #AggColumns\n\nCREATE TABLE #AggColumns (\n      ObjectID        INT NOT NULL\n    , IndexID         INT NOT NULL\n    , IndexColumns    NVARCHAR(MAX)\n    , IncludedColumns NVARCHAR(MAX)\n    , PRIMARY KEY (ObjectID, IndexID)\n)\n\nINSERT INTO #AggColumns\nSELECT t.ObjectID\n     , t.IndexID\n     , IndexColumns = STUFF((\n            SELECT ', [' + c.ColumnName + ']'\n            FROM #IndexColumns i\n            JOIN #Columns c ON i.ObjectID = c.ObjectID AND i.ColumnID = c.ColumnID\n            WHERE i.ObjectID = t.ObjectID\n                AND i.IndexID = t.IndexID\n                AND i.IsIncluded = 0\n            ORDER BY i.OrderID\n        FOR XML PATH(''), TYPE).value('(.\/text())[1]', 'NVARCHAR(MAX)'), 1, 2, '')\n     , IncludedColumns = STUFF((\n            SELECT ', [' + c.ColumnName + ']'\n            FROM #IndexColumns i\n            JOIN #Columns c ON i.ObjectID = c.ObjectID AND i.ColumnID = c.ColumnID\n            WHERE i.ObjectID = t.ObjectID\n                AND i.IndexID = t.IndexID\n                AND i.IsIncluded = 1\n            ORDER BY i.OrderID\n        FOR XML PATH(''), TYPE).value('(.\/text())[1]', 'NVARCHAR(MAX)'), 1, 2, '')\nFROM (\n    SELECT DISTINCT ObjectID, IndexID\n    FROM #Indexes\n    WHERE IndexType IN (1, 2)\n) t\n\nSELECT i.ObjectID\n     , i.IndexID\n     , i.IndexName\n     , ObjectName       = o.[name]\n     , SchemaName       = s.[name]\n     , i.PagesCount\n     , i.UnusedPagesCount\n     , i.PartitionNumber\n     , i.RowsCount\n     , i.IndexType\n     , i.IsAllowPageLocks\n     , u.TotalWrites\n     , u.TotalReads\n     , u.TotalSeeks\n     , u.TotalScans\n     , u.TotalLookups\n     , u.LastUsage\n     , i.DataCompression\n     , f.Fragmentation\n     , IndexStats       = STATS_DATE(i.ObjectID, i.IndexID)\n     , IsLobLegacy      = ISNULL(lob.IsLobLegacy, 0)\n     , IsLob            = ISNULL(lob.IsLob, 0)\n     , IsSparse         = CAST(CASE WHEN p.ObjectID IS NULL THEN 0 ELSE 1 END AS BIT)\n     , IsPartitioned    = CAST(CASE WHEN dds.[data_space_id] IS NOT NULL THEN 1 ELSE 0 END AS BIT)\n     , FileGroupName    = fg.[name]\n     , i.IsUnique\n     , i.IsPK\n     , i.FillFactorValue\n     , i.IsFiltered\n     , a.IndexColumns\n     , a.IncludedColumns\nFROM #Indexes i\nJOIN sys.objects o WITH(NOLOCK) ON o.[object_id] = i.ObjectID\nJOIN sys.schemas s WITH(NOLOCK) ON s.[schema_id] = o.[schema_id]\nLEFT JOIN #AggColumns a ON a.ObjectID = i.ObjectID AND a.IndexID = i.IndexID\nLEFT JOIN #Sparse p ON p.ObjectID = i.ObjectID\nLEFT JOIN #Fragmentation f ON f.ObjectID = i.ObjectID AND f.IndexID = i.IndexID AND f.PartitionNumber = i.PartitionNumber\nLEFT JOIN (\n    SELECT ObjectID      = [object_id]\n         , IndexID       = [index_id]\n         , TotalWrites   = NULLIF([user_updates], 0)\n         , TotalReads    = NULLIF([user_seeks] + [user_scans] + [user_lookups], 0)\n         , TotalSeeks    = NULLIF([user_seeks], 0)\n         , TotalScans    = NULLIF([user_scans], 0)\n         , TotalLookups  = NULLIF([user_lookups], 0)\n         , LastUsage     = (\n                                SELECT MAX(dt)\n                                FROM (\n                                    VALUES ([last_user_seek])\n                                         , ([last_user_scan])\n                                         , ([last_user_lookup])\n                                         , ([last_user_update])\n                                ) t(dt)\n                           )\n    FROM sys.dm_db_index_usage_stats WITH(NOLOCK)\n    WHERE [database_id] = @DBID\n) u ON i.ObjectID = u.ObjectID AND i.IndexID = u.IndexID\nLEFT JOIN #Lob lob ON lob.ObjectID = i.ObjectID AND lob.IndexID = i.IndexID\nLEFT JOIN sys.destination_data_spaces dds WITH(NOLOCK) ON i.DataSpaceID = dds.[partition_scheme_id] AND i.PartitionNumber = dds.[destination_id]\nJOIN sys.filegroups fg WITH(NOLOCK) ON ISNULL(dds.[data_space_id], i.DataSpaceID) = fg.[data_space_id] \nWHERE o.[type] IN ('V', 'U')\n    AND (\n            f.Fragmentation &gt;= @Fragmentation\n        OR\n            i.PagesCount &gt; @PreDescribeSize\n        OR\n            i.IndexType IN (5, 6)\n    )\n<\/code><\/pre>\n<p>\u041a\u0430\u043a \u0432\u0438\u0434\u043d\u043e \u0438\u0437 \u0441\u0430\u043c\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432, \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0447\u0430\u0441\u0442\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442\u0441\u044f \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b. \u042d\u0442\u043e \u0441\u0434\u0435\u043b\u0430\u043d\u043e \u0434\u043b\u044f \u0442\u043e\u0433\u043e, \u0447\u0442\u043e\u0431\u044b \u043d\u0435 \u0431\u044b\u043b\u043e \u0440\u0435\u043a\u043e\u043c\u043f\u0438\u043b\u044f\u0446\u0438\u0439, \u0438 \u0432 \u0441\u043b\u0443\u0447\u0430\u0435 \u0431\u043e\u043b\u044c\u0448\u043e\u0439 \u0441\u0445\u0435\u043c\u044b, \u043f\u043b\u0430\u043d \u043c\u043e\u0433 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u043f\u0430\u0440\u0430\u043b\u043b\u0435\u043b\u044c\u043d\u044b\u0439 \u043f\u0440\u0438 \u0432\u0441\u0442\u0430\u0432\u043a\u0435 \u0434\u0430\u043d\u043d\u044b\u0445, \u0442 \u043a \u0432\u0441\u0442\u0430\u0432\u043a\u0430 \u0441 \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u044b\u043c\u0438 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u043c\u0438 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u0430 \u0442\u043e\u043b\u044c\u043a\u043e \u0432 \u043e\u0434\u0438\u043d \u043f\u043e\u0442\u043e\u043a.<\/p>\n<p>\u041f\u043e\u0441\u043b\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0432\u044b\u0448\u0435\u0443\u043a\u0430\u0437\u0430\u043d\u043d\u043e\u0433\u043e \u0441\u043a\u0440\u0438\u043f\u0442\u0430 \u043f\u043e\u044f\u0432\u0438\u0442\u0441\u044f \u043e\u043a\u043d\u043e \u0441 \u0442\u0430\u0431\u043b\u0438\u0446\u0435\u0439 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/yd\/rl\/oh\/ydrlohqwbtggc8n8equratfkkr0.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/1cbe56e37947f0eec67b8a2c0d7b25a5.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u0422\u0430\u043a\u0436\u0435 \u0437\u0434\u0435\u0441\u044c \u043c\u043e\u0436\u043d\u043e \u0432\u044b\u0432\u0435\u0441\u0442\u0438 \u0438 \u0434\u0440\u0443\u0433\u0443\u044e \u0434\u0435\u0442\u0430\u043b\u044c\u043d\u0443\u044e \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e, \u0442\u0430\u043a\u0443\u044e \u043a\u0430\u043a:<\/p>\n<ol>\n<li>\u0431\u0430\u0437\u0430 \u0434\u0430\u043d\u043d\u044b\u0445<\/li>\n<li>\u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0441\u0435\u043a\u0446\u0438\u0439<\/li>\n<li>\u0434\u0430\u0442\u0430 \u0438 \u0432\u0440\u0435\u043c\u044f \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0433\u043e \u043e\u0431\u0440\u0430\u0449\u0435\u043d\u0438\u044f<\/li>\n<li>\u0441\u0436\u0430\u0442\u0438\u0435<\/li>\n<li>\u0444\u0430\u0439\u043b\u043e\u0432\u0430\u044f \u0433\u0440\u0443\u043f\u043f\u0430<\/li>\n<\/ol>\n<p>\n\u0438 \u0442. \u0434.<br \/>\n\u0421\u0430\u043c\u0438 \u043a\u043e\u043b\u043e\u043d\u043a\u0438 \u043c\u043e\u0436\u043d\u043e \u043d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0442\u044c:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/7z\/qw\/jf\/7zqwjfox2zagl5ox0oji648jnta.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/cf2c7a9891931f5dc253cfbd40827472.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u0412 \u044f\u0447\u0435\u0439\u043a\u0430\u0445 \u043a\u043e\u043b\u043e\u043d\u043a\u0438 Fix \u043c\u043e\u0436\u043d\u043e \u0432\u044b\u0431\u0440\u0430\u0442\u044c \u043a\u0430\u043a\u043e\u0435 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0435 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u043e \u043f\u0440\u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438. \u0422\u0430\u043a\u0436\u0435 \u043f\u0440\u0438 \u0437\u0430\u0432\u0435\u0440\u0448\u0435\u043d\u0438\u0438 \u0441\u043a\u0430\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0435 \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e \u0432\u044b\u0431\u0438\u0440\u0430\u0435\u0442\u0441\u044f \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0430\u043d\u0438\u0438 \u0432\u044b\u0431\u0440\u0430\u043d\u043d\u044b\u0445 \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/yp\/c9\/o2\/ypc9o2ooiylu7n0pw7zbdo97tbi.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/8ff4fd76be75889b00859c9c41335831.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u041d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0432\u044b\u0431\u0440\u0430\u0442\u044c \u043d\u0443\u0436\u043d\u044b\u0435 \u0438\u043d\u0434\u0435\u043a\u0441\u044b \u0434\u043b\u044f \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438.<\/p>\n<p>\u0421 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0433\u043b\u0430\u0432\u043d\u043e\u0433\u043e \u043c\u0435\u043d\u044e \u043c\u043e\u0436\u043d\u043e \u043a\u0430\u043a \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c \u0441\u043a\u0440\u0438\u043f\u0442 (\u044d\u0442\u0430 \u0436\u0435 \u043a\u043d\u043e\u043f\u043a\u0430 \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u0442 \u0441\u0430\u043c \u043f\u0440\u043e\u0446\u0435\u0441\u0441 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432):<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/tt\/tu\/fn\/tttufnve3kmo_siz_d0ahcxfew8.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/1e335fcb7f19ad380794763e3c877393.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u0442\u0430\u043a \u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0432 \u0440\u0430\u0437\u043d\u044b\u0435 \u0444\u043e\u0440\u043c\u0430\u0442\u044b (\u044d\u0442\u0430 \u0436\u0435 \u043a\u043d\u043e\u043f\u043a\u0430 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043e\u0442\u043a\u0440\u044b\u0442\u044c \u0434\u0435\u0442\u0430\u043b\u044c\u043d\u044b\u0435 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0434\u043b\u044f \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432):<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/tt\/8w\/gv\/tt8wgvpzqx1cl0a1qvkdfxf1ffm.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/d0100247e2550e6ca7057cedc664dab2.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u0422\u0430\u043a\u0436\u0435 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u043c\u043e\u0436\u043d\u043e \u043e\u0431\u043d\u043e\u0432\u0438\u0442\u044c, \u043d\u0430\u0436\u0430\u0432 \u043d\u0430 \u0442\u0440\u0435\u0442\u044c\u044e \u043a\u043d\u043e\u043f\u043a\u0443 \u0441\u043b\u0435\u0432\u0430 \u0432 \u0433\u043b\u0430\u0432\u043d\u043e\u043c \u043c\u0435\u043d\u044e \u0440\u044f\u0434\u043e\u043c \u0441 \u043b\u0443\u043f\u043e\u0439.<\/p>\n<p>\u041a\u043d\u043e\u043f\u043a\u0430 \u0441 \u043b\u0443\u043f\u043e\u0439 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0432\u044b\u0431\u0440\u0430\u0442\u044c \u043d\u0443\u0436\u043d\u044b\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u043d\u0438\u044f.<\/p>\n<p>\u041f\u043e\u043b\u043d\u043e\u0446\u0435\u043d\u043d\u043e\u0439 \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u043e\u0439 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u043d\u0430 \u0442\u0435\u043a\u0443\u0449\u0438\u0439 \u043c\u043e\u043c\u0435\u043d\u0442 \u043d\u0435\u0442. \u041f\u043e\u044d\u0442\u043e\u043c\u0443 \u043d\u0430\u0436\u0430\u0442\u0438\u0435 \u043d\u0430 \u043a\u043d\u043e\u043f\u043a\u0443 \u201c?\u201d \u0432\u044b\u0437\u043e\u0432\u0435\u0442 \u043f\u0440\u043e\u0441\u0442\u043e \u043f\u043e\u044f\u0432\u043b\u0435\u043d\u0438\u0435 \u043c\u043e\u0434\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u043e\u043a\u043d\u0430, \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0449\u0435\u0433\u043e \u043e\u0441\u043d\u043e\u0432\u043d\u0443\u044e \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u043e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043d\u043e\u043c \u043f\u0440\u043e\u0434\u0443\u043a\u0442\u0435:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/e5\/p_\/mq\/e5p_mqbcsumjihbb3qnwurxyqdk.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/5acc89d3adcdbeafe689688d8e40375f.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u041f\u043e\u043c\u0438\u043c\u043e \u0432\u0441\u0435\u0433\u043e \u0432\u044b\u0448\u0435\u043e\u043f\u0438\u0441\u0430\u043d\u043d\u043e\u0433\u043e \u0432 \u0433\u043b\u0430\u0432\u043d\u043e\u043c \u043c\u0435\u043d\u044e \u0435\u0441\u0442\u044c \u0441\u0442\u0440\u043e\u043a\u0430 \u043f\u043e\u0438\u0441\u043a\u0430:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/bm\/1c\/nn\/bm1cnnxagvohdo3a4qtprhvpqbe.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/3cf17e903913639516530d10fba0186d.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u041f\u0440\u0438 \u0437\u0430\u043f\u0443\u0441\u043a\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/qn\/xa\/en\/qnxaenzm91ifrvoc2l0aipezq5o.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/bf29950417944e73bd5f7c5cd520f634.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u0422\u0430\u043a\u0436\u0435 \u0432\u043d\u0438\u0437\u0443 \u043e\u043a\u043d\u0430 \u043c\u043e\u0436\u043d\u043e \u043f\u0440\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u043b\u043e\u0433 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c\u044b\u0445 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/wc\/aq\/zs\/wcaqzsz72m6dbuwe3bv1fxqm_3k.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/bc32533d7f7ee4eafd4ba071d05185bc.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p>\u0412 \u043e\u043a\u043d\u0435 \u0434\u0435\u0442\u0430\u043b\u044c\u043d\u044b\u0445 \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432 \u043c\u043e\u0436\u043d\u043e \u043d\u0430\u0441\u0442\u0440\u043e\u0438\u0442\u044c \u0431\u043e\u043b\u0435\u0435 \u0442\u043e\u043d\u043a\u0438\u0435 \u043e\u043f\u0446\u0438\u0438:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/kc\/6x\/gp\/kc6xgpndlhe19ueeehpobprsomc.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/dfd019e928dded5921eb1e905bd6d1b0.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<p><b>\u041f\u043e\u0436\u0435\u043b\u0430\u043d\u0438\u044f \u043a \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044e:<\/b><\/p>\n<ol>\n<li>\u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u044b\u043c \u0432\u044b\u0431\u043e\u0440\u043e\u0447\u043d\u043e \u043e\u0431\u043d\u043e\u0432\u043b\u044f\u0442\u044c \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0438 \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0434\u043b\u044f \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432 \u0438 \u0442\u0430\u043a\u0436\u0435 \u0440\u0430\u0437\u043d\u044b\u043c\u0438 \u0441\u043f\u043e\u0441\u043e\u0431\u0430\u043c\u0438 (\u043f\u043e\u043b\u043d\u043e\u0441\u0442\u044c\u044e \u043e\u0431\u043d\u043e\u0432\u043b\u044f\u0442\u044c \u0438\u043b\u0438 \u0447\u0430\u0441\u0442\u0438\u0447\u043d\u043e)<\/li>\n<li>\u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u044b\u043c \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0432\u044b\u0431\u0438\u0440\u0430\u0442\u044c \u0411\u0414, \u043d\u043e \u0438 \u0440\u0430\u0437\u043d\u044b\u0435 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 (\u044d\u0442\u043e \u043e\u0447\u0435\u043d\u044c \u0443\u0434\u043e\u0431\u043d\u043e, \u043a\u043e\u0433\u0434\u0430 \u043c\u043d\u043e\u0433\u043e \u044d\u043a\u0437\u0435\u043c\u043f\u043b\u044f\u0440\u043e\u0432 MS SQL Server)<\/li>\n<li>\u0434\u043b\u044f \u0431\u043e\u043b\u044c\u0448\u0435\u0439 \u0433\u0438\u0431\u043a\u043e\u0441\u0442\u0438 \u0432 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 \u043f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u0435\u0442\u0441\u044f \u043e\u0431\u0435\u0440\u043d\u0443\u0442\u044c \u043a\u043e\u043c\u0430\u043d\u0434\u044b \u0432 \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438, \u0438 \u0432\u044b\u0432\u0435\u0441\u0442\u0438 \u0432 \u043a\u043e\u043c\u0430\u043d\u0434\u044b PowerShell, \u043a\u0430\u043a \u044d\u0442\u043e \u0441\u0434\u0435\u043b\u0430\u043d\u043e, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0437\u0434\u0435\u0441\u044c:<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/dbatools.io\/commands\/\">dbatools.io\/commands<\/a><\/noindex><\/li>\n<li>\u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u044b\u043c \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u0442\u044c \u0438 \u0438\u0437\u043c\u0435\u043d\u044f\u0442\u044c \u043f\u0435\u0440\u0441\u043e\u043d\u0430\u043b\u044c\u043d\u044b\u0435 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u043a\u0430\u043a \u0434\u043b\u044f \u0432\u0441\u0435\u0433\u043e \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f, \u0442\u0430\u043a \u0438 \u0432 \u0441\u043b\u0443\u0447\u0430\u0435 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u0438 \u0434\u043b\u044f \u043a\u0430\u0436\u0434\u043e\u0433\u043e \u044d\u043a\u0437\u0435\u043c\u043f\u043b\u044f\u0440\u0430 MS SQL Server \u0438 \u043a\u0430\u0436\u0434\u043e\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445<\/li>\n<li>\u0438\u0437 \u043f.2 \u0438 4 \u0432\u044b\u0442\u0435\u043a\u0430\u0435\u0442 \u043f\u043e\u0436\u0435\u043b\u0430\u043d\u0438\u0435 \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0433\u0440\u0443\u043f\u043f\u044b \u043f\u043e \u0431\u0430\u0437\u0430\u043c \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u0433\u0440\u0443\u043f\u043f\u044b \u043f\u043e \u044d\u043a\u0437\u0435\u043c\u043f\u043b\u044f\u0440\u0430\u043c MS SQL Server, \u0434\u043b\u044f \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u043e\u0434\u0438\u043d\u0430\u043a\u043e\u0432\u044b\u0435<\/li>\n<li>\u0441\u0434\u0435\u043b\u0430\u0442\u044c \u043f\u043e\u0438\u0441\u043a \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u043e\u0432 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432 (\u043f\u043e\u043b\u043d\u044b\u0445 \u0438 \u043d\u0435\u043f\u043e\u043b\u043d\u044b\u0445, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043b\u0438\u0431\u043e \u043d\u0435\u0441\u0438\u043b\u044c\u043d\u043e \u043e\u0442\u043b\u0438\u0447\u0430\u044e\u0442\u0441\u044f, \u043b\u0438\u0431\u043e \u043e\u0442\u043b\u0438\u0447\u0430\u044e\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u043f\u043e \u0432\u043a\u043b\u044e\u0447\u0435\u043d\u043d\u044b\u043c \u043a\u043e\u043b\u043e\u043d\u043a\u0430\u043c)<\/li>\n<li>\u0442 \u043a SQLIndexManager \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0434\u043b\u044f \u0421\u0423\u0411\u0414 MS SQL Server, \u0442\u043e \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u043e\u0442\u0440\u0430\u0437\u0438\u0442\u044c \u044d\u0442\u043e \u0432 \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0438, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c: SQLIndexManager for MS SQL Server<\/li>\n<li>\u0432\u0441\u0435 \u0447\u0430\u0441\u0442\u0438 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u043d\u0435 GUI \u0432\u044b\u043d\u0435\u0441\u0442\u0438 \u0432 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u0435 \u043c\u043e\u0434\u0443\u043b\u0438 \u0438 \u043f\u0435\u0440\u0435\u043f\u0438\u0441\u0430\u0442\u044c \u043d\u0430 .NET Core 2.1<\/li>\n<\/ol>\n<p>\n\u041d\u0430 \u043c\u043e\u043c\u0435\u043d\u0442 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u0438\u044f \u0441\u0442\u0430\u0442\u044c\u0438 \u043f.6 \u0438\u0437 \u043f\u043e\u0436\u0435\u043b\u0430\u043d\u0438\u0439 \u0430\u043a\u0442\u0438\u0432\u043d\u043e \u0440\u0430\u0437\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u0435\u0442\u0441\u044f \u0438 \u0443\u0436\u0435 \u0435\u0441\u0442\u044c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u0432 \u0432\u0438\u0434\u0435 \u043f\u043e\u0438\u0441\u043a\u0430 \u043f\u043e\u043b\u043d\u044b\u0445 \u0438 \u043f\u043e\u0434\u043e\u0431\u043d\u044b\u0445 \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u043e\u0432:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/zk\/bw\/d3\/zkbwd3hem7xtdtj_5yuqhctasac.jpeg\"><img decoding=\"async\" alt=\"\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager\" src=\"\/wp-content\/uploads\/2019\/08\/067df3fdb192ffe67a88f66f7f1a1c96.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<h3>\u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0438<\/h3>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Microsoft\/tigertoolbox\/tree\/master\/AdaptiveIndexDefrag\">\u0430\u0434\u0430\u043f\u0442\u0438\u0432\u043d\u044b\u0439 \u043c\u0435\u0442\u043e\u0434 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sergeysyrovatchenko\/SQLIndexManager\">\u0443\u0442\u0438\u043b\u0438\u0442\u0430 SQLIndexManager<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/459914\/\">\u043a\u0440\u0430\u0442\u043a\u0438\u0439 \u0442\u0435\u0445\u043d\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u043e\u0431\u0437\u043e\u0440 \u0443\u0442\u0438\u043b\u0438\u0442\u044b SQLIndexManager<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sql.ru\/forum\/1312218-1\/sql-index-manager-besplatnaya-utilita-po-obsluzhivaniu-indeksov-dlya-sql-server-i-azure\">\u043e\u0431\u0441\u0443\u0436\u0434\u0435\u043d\u0438\u0435 \u043f\u043e \u0443\u0442\u0438\u043b\u0438\u0442\u0435 SQLIndexManager<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.codeproject.com\/Articles\/5162340\/SQL-Index-Manager-Free-GUI-Tool-for-Index-Maintena\">SQL Index Manager \u2013 Free GUI Tool for Index Maintenance on SQL Server and Azure<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/towardsdatascience.com\/sql-server-index-analysis-and-optimization-1edd84d9da\">SQL Server Index Analysis and Optimization<\/a><\/noindex><\/li>\n<\/ul>\n<p>\u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/461277\/\">habr.com<\/a><\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u0430\u043a \u0438\u0437\u0432\u0435\u0441\u0442\u043d\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u044b \u0438\u0433\u0440\u0430\u044e\u0442 \u0432\u0430\u0436\u043d\u0443\u044e \u0440\u043e\u043b\u044c \u0432 \u0421\u0423\u0411\u0414, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044f \u0431\u044b\u0441\u0442\u0440\u044b\u0439 \u043f\u043e\u0438\u0441\u043a \u043a \u043d\u0443\u0436\u043d\u044b\u043c \u0437\u0430\u043f\u0438\u0441\u044f\u043c. \u041f\u043e\u0442\u043e\u043c\u0443 \u0442\u0430\u043a \u0432\u0430\u0436\u043d\u043e \u0438\u0445 \u0441\u0432\u043e\u0435\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u0442\u044c. \u041e\u0431 \u0430\u043d\u0430\u043b\u0438\u0437\u0435 \u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u043c\u043d\u043e\u0433\u043e \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u0430, \u0432 \u0442\u043e\u043c \u0447\u0438\u0441\u043b\u0435 \u0438 \u0432 \u0418\u043d\u0442\u0435\u0440\u043d\u0435\u0442\u0435. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043d\u0435\u0434\u0430\u0432\u043d\u043e \u0434\u0435\u043b\u0430\u043b\u0441\u044f \u043e\u0431\u0437\u043e\u0440 \u0434\u0430\u043d\u043d\u043e\u0439 \u0442\u0435\u043c\u044b \u0432 \u044d\u0442\u043e\u0439 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0438. \u0421\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442 \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u043e \u043a\u0430\u043a \u043f\u043b\u0430\u0442\u043d\u044b\u0445, \u0442\u0430\u043a \u0438 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u044b\u0445 \u0440\u0435\u0448\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u044d\u0442\u043e\u0433\u043e. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0435\u0441\u0442\u044c [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":27494,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-36705","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u0430\u043a \u0438\u0437\u0432\u0435\u0441\u0442\u043d\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u044b \u0438\u0433\u0440\u0430\u044e\u0442 \u0432\u0430\u0436\u043d\u0443\u044e \u0440\u043e\u043b\u044c \u0432 \u0421\u0423\u0411\u0414, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044f \u0431\u044b\u0441\u0442\u0440\u044b\u0439 \u043f\u043e\u0438\u0441\u043a \u043a \u043d\u0443\u0436\u043d\u044b\u043c \u0437\u0430\u043f\u0438\u0441\u044f\u043c. \u041f\u043e\u0442\u043e\u043c\u0443 \u0442\u0430\u043a \u0432\u0430\u0436\u043d\u043e \u0438\u0445 \u0441\u0432\u043e\u0435\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u0442\u044c. \u041e\u0431 \u0430\u043d\u0430\u043b\u0438\u0437\u0435 \u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u043c\u043d\u043e\u0433\u043e \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u0430, \u0432 \u0442\u043e\u043c \u0447\u0438\u0441\u043b\u0435 \u0438 \u0432 \u0418\u043d\u0442\u0435\u0440\u043d\u0435\u0442\u0435. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043d\u0435\u0434\u0430\u0432\u043d\u043e \u0434\u0435\u043b\u0430\u043b\u0441\u044f \u043e\u0431\u0437\u043e\u0440 \u0434\u0430\u043d\u043d\u043e\u0439 \u0442\u0435\u043c\u044b \u0432 \u044d\u0442\u043e\u0439 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0438. \u0421\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442 \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u043e \u043a\u0430\u043a \u043f\u043b\u0430\u0442\u043d\u044b\u0445, \u0442\u0430\u043a \u0438 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u044b\u0445 \u0440\u0435\u0448\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u044d\u0442\u043e\u0433\u043e. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0435\u0441\u0442\u044c\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/obzor-besplatnogo-instrumenta-sqlindexmanager\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"de_DE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u0430\u043a \u0438\u0437\u0432\u0435\u0441\u0442\u043d\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u044b \u0438\u0433\u0440\u0430\u044e\u0442 \u0432\u0430\u0436\u043d\u0443\u044e \u0440\u043e\u043b\u044c \u0432 \u0421\u0423\u0411\u0414, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044f \u0431\u044b\u0441\u0442\u0440\u044b\u0439 \u043f\u043e\u0438\u0441\u043a \u043a \u043d\u0443\u0436\u043d\u044b\u043c \u0437\u0430\u043f\u0438\u0441\u044f\u043c. \u041f\u043e\u0442\u043e\u043c\u0443 \u0442\u0430\u043a \u0432\u0430\u0436\u043d\u043e \u0438\u0445 \u0441\u0432\u043e\u0435\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u0442\u044c. \u041e\u0431 \u0430\u043d\u0430\u043b\u0438\u0437\u0435 \u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u043c\u043d\u043e\u0433\u043e \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u0430, \u0432 \u0442\u043e\u043c \u0447\u0438\u0441\u043b\u0435 \u0438 \u0432 \u0418\u043d\u0442\u0435\u0440\u043d\u0435\u0442\u0435. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043d\u0435\u0434\u0430\u0432\u043d\u043e \u0434\u0435\u043b\u0430\u043b\u0441\u044f \u043e\u0431\u0437\u043e\u0440 \u0434\u0430\u043d\u043d\u043e\u0439 \u0442\u0435\u043c\u044b \u0432 \u044d\u0442\u043e\u0439 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0438. \u0421\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442 \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u043e \u043a\u0430\u043a \u043f\u043b\u0430\u0442\u043d\u044b\u0445, \u0442\u0430\u043a \u0438 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u044b\u0445 \u0440\u0435\u0448\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u044d\u0442\u043e\u0433\u043e. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0435\u0441\u0442\u044c\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/obzor-besplatnogo-instrumenta-sqlindexmanager\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-10-31T19:13:15+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T19:13:15+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47\u00dcberblick \u00fcber das kostenlose Tool SQLIndexManager | ProHoster","description":"Wie bekannt ist, spielen Indizes eine wichtige Rolle in Datenbanksystemen, da sie eine schnelle Suche nach den ben\u00f6tigten Datens\u00e4tzen erm\u00f6glichen. Daher ist es entscheidend, sie rechtzeitig zu warten. Es gibt bereits viele Materialien zu Analyse und Optimierung, auch im Internet. Zum Beispiel wurde k\u00fcrzlich ein \u00dcberblick zu diesem Thema in dieser Ver\u00f6ffentlichung gegeben. Es gibt zahlreiche kostenpflichtige sowie kostenlose L\u00f6sungen daf\u00fcr. Zum Beispiel gibt es","canonical_url":"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/obzor-besplatnogo-instrumenta-sqlindexmanager","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"de_DE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041e\u0431\u0437\u043e\u0440 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 SQLIndexManager | ProHoster","og:description":"\u041a\u0430\u043a \u0438\u0437\u0432\u0435\u0441\u0442\u043d\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u044b \u0438\u0433\u0440\u0430\u044e\u0442 \u0432\u0430\u0436\u043d\u0443\u044e \u0440\u043e\u043b\u044c \u0432 \u0421\u0423\u0411\u0414, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044f \u0431\u044b\u0441\u0442\u0440\u044b\u0439 \u043f\u043e\u0438\u0441\u043a \u043a \u043d\u0443\u0436\u043d\u044b\u043c \u0437\u0430\u043f\u0438\u0441\u044f\u043c. \u041f\u043e\u0442\u043e\u043c\u0443 \u0442\u0430\u043a \u0432\u0430\u0436\u043d\u043e \u0438\u0445 \u0441\u0432\u043e\u0435\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u0442\u044c. \u041e\u0431 \u0430\u043d\u0430\u043b\u0438\u0437\u0435 \u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u043c\u043d\u043e\u0433\u043e \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u0430, \u0432 \u0442\u043e\u043c \u0447\u0438\u0441\u043b\u0435 \u0438 \u0432 \u0418\u043d\u0442\u0435\u0440\u043d\u0435\u0442\u0435. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043d\u0435\u0434\u0430\u0432\u043d\u043e \u0434\u0435\u043b\u0430\u043b\u0441\u044f \u043e\u0431\u0437\u043e\u0440 \u0434\u0430\u043d\u043d\u043e\u0439 \u0442\u0435\u043c\u044b \u0432 \u044d\u0442\u043e\u0439 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0438. \u0421\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442 \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u043e \u043a\u0430\u043a \u043f\u043b\u0430\u0442\u043d\u044b\u0445, \u0442\u0430\u043a \u0438 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u044b\u0445 \u0440\u0435\u0448\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u044d\u0442\u043e\u0433\u043e. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0435\u0441\u0442\u044c","og:url":"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/obzor-besplatnogo-instrumenta-sqlindexmanager","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T19:13:15+00:00","article:modified_time":"2019-10-31T19:13:15+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"36705","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-22 04:30:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 01:40:22","updated":"2026-01-22 04:30:19"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts\/36705","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/comments?post=36705"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts\/36705\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/media\/27494"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/media?parent=36705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/categories?post=36705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/tags?post=36705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}