{"id":235,"date":"2015-12-14T16:02:03","date_gmt":"2015-12-14T19:02:03","guid":{"rendered":"https:\/\/maurobernal.com.ar\/blog\/?p=235"},"modified":"2017-11-10T23:25:27","modified_gmt":"2017-11-11T02:25:27","slug":"nivel-de-fragmentacion-de-una-base-de-dato","status":"publish","type":"post","link":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/","title":{"rendered":"Nivel de Fragmentacion de una base de dato"},"content":{"rendered":"<h2>Nivel de Fragmentaci\u00f3n<\/h2>\n<p>Uno de los principales t\u00f3picos que se debe verificar es el crecimiento de los archivos que componen una base de datos, como as\u00ed tambi\u00e9n el nivel de fragmentaci\u00f3n de los \u00edndices que la componen.<\/p>\n<p>Asegurar el mejor rendimiento de una base de datos en MSSQL Server puede ser una tarea labiosa.<\/p>\n<h2>Verifica que bases de datos crecieron de manera autom\u00e1tica<\/h2>\n<p>Cuando alguno de los archivos que componen la base (mdf y ldf) se queden sin espacios, y tiene permitido autocrecer (<strong>autogrowth<\/strong>) detienen la consulta en curso,\u00a0 y autoincrementa su tama\u00f1o, y continua con la operaci\u00f3n inicial. Esto si ocurre muy seguido puede provocar que se reduzca el rendimiento de la base.<br \/>\nUna forma de detectarlo es consultando el log del SQL Server:<\/p>\n<pre title=\"Listar AutoGrowth\" class=\"lang:tsql decode:true \">SELECT\r\nDatabaseName as Base,\r\n[FileName] as Archivo,\r\nCASE EventClass\r\n\t\t\tWHEN 92 THEN 'Datos'\r\n\t\t\tWHEN 93 THEN 'Log'\r\nEND  as Tipo,\r\nCONVERT(VARCHAR(20), EndTime - StartTime, 114) as TiempoDemora,\r\nStartTime as FechaInicio,\r\nEndTime as FechaFin\r\n \r\n\r\nFROM (\r\nSELECT pt = REVERSE(SUBSTRING(REVERSE([path]), CHARINDEX('\\', REVERSE([path])), 260)) + N'log.trc'\r\nFROM sys.traces\r\nWHERE is_default = 1\r\n) p\r\nCROSS APPLY sys.fn_trace_gettable(pt, DEFAULT)\r\nWHERE EventClass IN (92, 93)\r\nORDER BY StartTime DESC<\/pre>\n<p><a href=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/12\/Autogrowth.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-237\" src=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/12\/Autogrowth-300x60.png?resize=300%2C60&#038;ssl=1\" alt=\"Autogrowth\" width=\"300\" height=\"60\" srcset=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/12\/Autogrowth.png?resize=300%2C60&amp;ssl=1 300w, https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/12\/Autogrowth.png?w=635&amp;ssl=1 635w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>De acuerdo al resultado ser\u00e1 la base en la que deberemos trabajar:<\/p>\n<ul>\n<li>Si aparece la TEMPDB la opci\u00f3n mas recomendable es: Crear un archivos de Datos (.MDF) y un archivo de LOG( ldf) por cada procesador que tiene el servidor. Y el tama\u00f1o inicial total de la base debe ser el actual + 10% . Y luego irlo ajustando a medida que se vaya necesitando.<\/li>\n<\/ul>\n<h2>Verifica el nivel de fragmentaci\u00f3n de los indices<\/h2>\n<p>El segundo punto importante es verificar que nivel de fragmentaci\u00f3n tienen cada uno de los indices que componen la base de datos. Este punto puede provocar que nuestra base de datos tenga un tama\u00f1o mayor que el real. Y provoque que las consultas se demoren un poco mas de lo que deberian:<\/p>\n<p>Para corroborarlo podemos usar el siguiente script:<\/p>\n<pre title=\"Listar nivel de fragmentaci\u00f3n\" class=\"lang:tsql decode:true \">IF OBJECT_ID('tempdb.dbo.#temp') IS NOT NULL\r\nDROP TABLE #temp\r\nGO\r\nCREATE TABLE #temp (\r\ndb SYSNAME DEFAULT DB_NAME(),\r\nflname SYSNAME,\r\nsize_after_growth DECIMAL(18,2),\r\nsize DECIMAL(18,2),\r\nspace_used DECIMAL(18,2),\r\ngrowth INT,\r\nis_percent_growth BIT,\r\nPRIMARY KEY CLUSTERED (db, flname)\r\n)\r\nDECLARE @SQL NVARCHAR(MAX)\r\nSELECT @SQL = STUFF((\r\nSELECT '\r\nUSE [' + name + ']\r\nINSERT INTO #temp (flname, size_after_growth, space_used, size, growth, is_percent_growth)\r\nSELECT\r\nname\r\n, CASE WHEN is_percent_growth = 1 THEN size * (1 + (growth \/ 100.)) ELSE size + growth END * 8. \/ 1024\r\n, space_used = FILEPROPERTY(name, ''SpaceUsed'') * 8. \/ 1024\r\n, size = size * 8. \/ 1024\r\n, CASE WHEN is_percent_growth = 1 THEN growth ELSE growth * 8. \/ 1024 END\r\n, is_percent_growth\r\nFROM sys.database_files'\r\nFROM sys.databases\r\nWHERE [state] = 0\r\nFOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 2, '')\r\nEXEC sys.sp_executesql @SQL\r\nSELECT\r\ndb\r\n, flname\r\n, size_after_growth\r\n, size\r\n, space_used\r\n, CAST(growth AS VARCHAR(10)) + CASE WHEN is_percent_growth = 1 THEN ' %' ELSE ' MB' END\r\nFROM #temp\r\nWHERE (is_percent_growth = 0 AND growth &lt; 50)\r\nOR (is_percent_growth = 1 AND growth &lt; 5)\r\nOR (size - space_used &lt; 20)<\/pre>\n<p>&nbsp;<\/p>\n<p>Para correguirlo podemos ejecutar el siguiente script por cada una de nuestras bases de datos:<\/p>\n<pre title=\"Correguir nivel de fragmentaci\u00f3n\" class=\"lang:tsql decode:true \">DECLARE @SQL NVARCHAR(MAX)\r\nSELECT @SQL = (\r\nSELECT '\r\nALTER INDEX [' + i.name + N'] ON [' + SCHEMA_NAME(o.[schema_id]) + '].[' + o.name + '] ' +\r\nCASE WHEN s.avg_fragmentation_in_percent &gt; 30\r\nTHEN 'REBUILD'\r\nELSE 'REORGANIZE'\r\nEND + ';\r\n'\r\nFROM (\r\nSELECT\r\ns.[object_id]\r\n, s.index_id\r\n, avg_fragmentation_in_percent = MAX(s.avg_fragmentation_in_percent)\r\nFROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) s\r\nWHERE s.page_count &gt; 128 -- &gt; 1 MB\r\nAND s.index_id &gt; 0 -- &lt;&gt; HEAP\r\nAND s.avg_fragmentation_in_percent &gt; 5\r\nGROUP BY s.[object_id], s.index_id\r\n) s\r\nJOIN sys.indexes i ON s.[object_id] = i.[object_id] AND s.index_id = i.index_id\r\nJOIN sys.objects o ON o.[object_id] = s.[object_id]\r\nFOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)')\r\nPRINT @SQL\r\nEXEC sys.sp_executesql @SQL<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nivel de Fragmentaci\u00f3n Uno de los principales t\u00f3picos que se debe verificar es el crecimiento de los archivos que componen una base de datos, como as\u00ed tambi\u00e9n el nivel de&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1,3],"tags":[94,93,92,8,65,16,29],"class_list":["post-235","post","type-post","status-publish","format-standard","hentry","category-blog","category-t-sql","tag-fragmentacion","tag-fragmentation","tag-index","tag-mssql-2","tag-performance","tag-sql","tag-tsql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Nivel de Fragmentacion de una base de dato &#183; devops Mauro Bernal<\/title>\n<meta name=\"description\" content=\"Mejorar el rendimiento de sus bases de datos de MS SQL Server a trav\u00e9s del an\u00e1lisis del nivel de fragmentaci\u00f3n y comandos TSQL\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nivel de Fragmentacion de una base de dato &#183; devops Mauro Bernal\" \/>\n<meta property=\"og:description\" content=\"Mejorar el rendimiento de sus bases de datos de MS SQL Server a trav\u00e9s del an\u00e1lisis del nivel de fragmentaci\u00f3n y comandos TSQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/\" \/>\n<meta property=\"og:site_name\" content=\"devops Mauro Bernal\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-14T19:02:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-11T02:25:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/12\/Autogrowth-300x60.png\" \/>\n<meta name=\"author\" content=\"Mauro Bernal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@_maurobernal\" \/>\n<meta name=\"twitter:site\" content=\"@_maurobernal\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mauro Bernal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/\"},\"author\":{\"name\":\"Mauro Bernal\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"headline\":\"Nivel de Fragmentacion de una base de dato\",\"datePublished\":\"2015-12-14T19:02:03+00:00\",\"dateModified\":\"2017-11-11T02:25:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/\"},\"wordCount\":292,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"image\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/Autogrowth-300x60.png\",\"keywords\":[\"fragmentaci\u00f3n\",\"fragmentation\",\"index\",\"mssql\",\"performance\",\"sql\",\"tsql\"],\"articleSection\":[\"Blog\",\"T-SQL\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/\",\"url\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/\",\"name\":\"Nivel de Fragmentacion de una base de dato &#183; devops Mauro Bernal\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/Autogrowth-300x60.png\",\"datePublished\":\"2015-12-14T19:02:03+00:00\",\"dateModified\":\"2017-11-11T02:25:27+00:00\",\"description\":\"Mejorar el rendimiento de sus bases de datos de MS SQL Server a trav\u00e9s del an\u00e1lisis del nivel de fragmentaci\u00f3n y comandos TSQL\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/Autogrowth.png?fit=635%2C127&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/Autogrowth.png?fit=635%2C127&ssl=1\",\"width\":635,\"height\":127},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/nivel-de-fragmentacion-de-una-base-de-dato\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Nivel de Fragmentacion de una base de dato\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/\",\"name\":\"devops Mauro Bernal\",\"description\":\"Cuando tu trabajo es hacer que las cosas funcionen bien...\",\"publisher\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\",\"name\":\"Mauro Bernal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\",\"width\":1740,\"height\":1740,\"caption\":\"Mauro Bernal\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\"},\"description\":\"Desarrollo de Sistemas en .Net, IT Callcenters, DBA de SQL Server, Mikrotik, Pentest y T\u00e9cnico consultor de Sistemas Bejerman\",\"sameAs\":[\"https:\\\/\\\/maurobernal.com.ar\",\"https:\\\/\\\/x.com\\\/_maurobernal\",\"https:\\\/\\\/youtube.com\\\/maurobernal\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Nivel de Fragmentacion de una base de dato &#183; devops Mauro Bernal","description":"Mejorar el rendimiento de sus bases de datos de MS SQL Server a trav\u00e9s del an\u00e1lisis del nivel de fragmentaci\u00f3n y comandos TSQL","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/","og_locale":"es_ES","og_type":"article","og_title":"Nivel de Fragmentacion de una base de dato &#183; devops Mauro Bernal","og_description":"Mejorar el rendimiento de sus bases de datos de MS SQL Server a trav\u00e9s del an\u00e1lisis del nivel de fragmentaci\u00f3n y comandos TSQL","og_url":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/","og_site_name":"devops Mauro Bernal","article_published_time":"2015-12-14T19:02:03+00:00","article_modified_time":"2017-11-11T02:25:27+00:00","og_image":[{"url":"https:\/\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/12\/Autogrowth-300x60.png","type":"","width":"","height":""}],"author":"Mauro Bernal","twitter_card":"summary_large_image","twitter_creator":"@_maurobernal","twitter_site":"@_maurobernal","twitter_misc":{"Escrito por":"Mauro Bernal","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/#article","isPartOf":{"@id":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/"},"author":{"name":"Mauro Bernal","@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"headline":"Nivel de Fragmentacion de una base de dato","datePublished":"2015-12-14T19:02:03+00:00","dateModified":"2017-11-11T02:25:27+00:00","mainEntityOfPage":{"@id":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/"},"wordCount":292,"commentCount":0,"publisher":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"image":{"@id":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/#primaryimage"},"thumbnailUrl":"https:\/\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/12\/Autogrowth-300x60.png","keywords":["fragmentaci\u00f3n","fragmentation","index","mssql","performance","sql","tsql"],"articleSection":["Blog","T-SQL"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/","url":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/","name":"Nivel de Fragmentacion de una base de dato &#183; devops Mauro Bernal","isPartOf":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/#primaryimage"},"image":{"@id":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/#primaryimage"},"thumbnailUrl":"https:\/\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/12\/Autogrowth-300x60.png","datePublished":"2015-12-14T19:02:03+00:00","dateModified":"2017-11-11T02:25:27+00:00","description":"Mejorar el rendimiento de sus bases de datos de MS SQL Server a trav\u00e9s del an\u00e1lisis del nivel de fragmentaci\u00f3n y comandos TSQL","breadcrumb":{"@id":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/#primaryimage","url":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/12\/Autogrowth.png?fit=635%2C127&ssl=1","contentUrl":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/12\/Autogrowth.png?fit=635%2C127&ssl=1","width":635,"height":127},{"@type":"BreadcrumbList","@id":"https:\/\/maurobernal.com.ar\/blog\/nivel-de-fragmentacion-de-una-base-de-dato\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/maurobernal.com.ar\/blog\/"},{"@type":"ListItem","position":2,"name":"Nivel de Fragmentacion de una base de dato"}]},{"@type":"WebSite","@id":"https:\/\/maurobernal.com.ar\/blog\/#website","url":"https:\/\/maurobernal.com.ar\/blog\/","name":"devops Mauro Bernal","description":"Cuando tu trabajo es hacer que las cosas funcionen bien...","publisher":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/maurobernal.com.ar\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283","name":"Mauro Bernal","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1","url":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1","contentUrl":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1","width":1740,"height":1740,"caption":"Mauro Bernal"},"logo":{"@id":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1"},"description":"Desarrollo de Sistemas en .Net, IT Callcenters, DBA de SQL Server, Mikrotik, Pentest y T\u00e9cnico consultor de Sistemas Bejerman","sameAs":["https:\/\/maurobernal.com.ar","https:\/\/x.com\/_maurobernal","https:\/\/youtube.com\/maurobernal"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/comments?post=235"}],"version-history":[{"count":3,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/235\/revisions"}],"predecessor-version":[{"id":513,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/235\/revisions\/513"}],"wp:attachment":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/media?parent=235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/categories?post=235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/tags?post=235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}