{"id":697,"date":"2025-10-26T12:40:32","date_gmt":"2025-10-26T12:40:32","guid":{"rendered":"https:\/\/datacrazyworld.com\/?p=697"},"modified":"2025-10-26T13:39:09","modified_gmt":"2025-10-26T13:39:09","slug":"como-no-estresarse-con-sqlquerystress","status":"publish","type":"post","link":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/","title":{"rendered":"C\u00f3mo no estresarse con SQLQueryStress"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hay herramientas esenciales en la vida de un DBA y para mi una de esas es esta: <em>SQLQueryStress<\/em>. Por muchos a\u00f1os que pasen (porque ya tiene solera la herramienta) siempre llega el momento en el que acabas teniendo que recurrir a ella y por ello escribo hoy sobre ella.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfQu\u00e9 es?\u00bfPara qu\u00e9 sirve?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><em>SQLQueryStress<\/em> es una herramienta gratuita que se usa para probar el rendimiento y la carga de consultas SQL en Microsoft SQL Server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Permite simular carga sobre una base de datos SQL Server con el fin de medir el rendimiento de consultas o procedimientos almacenados. Y algunos de los escenarios \u00fatiles son:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Pruebas de rendimiento<\/li>\n\n\n\n<li>Pruebas de carga<\/li>\n\n\n\n<li>Optimizaci\u00f3n de consultas<\/li>\n\n\n\n<li>Diagn\u00f3stico de cuellos de botella<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Un poco de historia&#8230;<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">All\u00e1 por el 2006, <em>Adam Machanic<\/em> se encontraba escribiendo un libro y creo esta herramienta para los ejemplos que conten\u00eda dicho libro. Es muy interesante c\u00f3mo cuenta \u00e9l la historia <a href=\"http:\/\/dataeducation.com\/sqlquerystress-the-source-code\/\" target=\"_blank\" rel=\"noopener\" title=\"\">aqui<\/a>: desde la sorpresa que se llev\u00f3 de que algo tan simple se volviera tan popular a cuando crey\u00f3 que hab\u00eda perdido el c\u00f3digo&#8230; vamos que recomiendo su lectura.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pero la historia no acab\u00f3 ah\u00ed, luego <em>Erik Ejlskov Jensen<\/em> recogi\u00f3 el testito de Adam (que cedi\u00f3 el c\u00f3digo original) y creo el GitHub donde se sigue manteniendo la herramienta (<a href=\"https:\/\/github.com\/ErikEJ\/SqlQueryStress\" target=\"_blank\" rel=\"noopener\" title=\"\">ver<\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bueno, y ahora veamos c\u00f3mo funciona.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Instalaci\u00f3n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">En mi caso la baj\u00e9 desde la Microsoft Store<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"764\" height=\"348\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image.png\" alt=\"\" class=\"wp-image-698\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image.png 764w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-300x137.png 300w\" sizes=\"auto, (max-width: 764px) 100vw, 764px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Pero cuando he intentado replicarlo para este art\u00edculo no lo he encontrado. \u00bfEntonces? \u00a1Que no cunda el p\u00e1nico! Se puede descargar desde el GitHub.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"965\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-4-1024x965.png\" alt=\"\" class=\"wp-image-704\" style=\"width:741px;height:auto\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-4-1024x965.png 1024w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-4-300x283.png 300w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-4-768x724.png 768w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-4.png 1060w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Se descarga el archivo <em>.zip <\/em>y cuando se descomprime es tan simple como abrirla\/ejecutarla. Y si se quiere, como cualquier otra aplicaci\u00f3n, se puede anclar al men\u00fa o a la barra de tareas.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Configuraciones posibles<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Cuando se abre la aplicaci\u00f3n, se muestra esta ventana donde se puede configurar las condiciones de la prueba.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"764\" height=\"483\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-1.png\" alt=\"\" class=\"wp-image-699\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-1.png 764w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-1-300x190.png 300w\" sizes=\"auto, (max-width: 764px) 100vw, 764px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Las opciones que hay son<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Number of iterations:<\/strong> N\u00ba de veces que se quiere que se ejecute el bucle<\/li>\n\n\n\n<li><strong>Number of Threads:<\/strong> N\u00ba de hilos que se quiere lanzar. M\u00e1ximo 200<\/li>\n\n\n\n<li><strong>Delay between queries (ms): <\/strong>Millisegundos que se quiere que espere la query entre iteraciones<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Adem\u00e1s de estas opciones, se encuentran los siguientes botones que llevar\u00e1n a ventanas que permiten m\u00e1s configuraciones y son bastante intuitivos.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Bot\u00f3n Database<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Para configurar la conexi\u00f3n con la base de datos.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"665\" height=\"490\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-2.png\" alt=\"\" class=\"wp-image-700\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-2.png 665w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-2-300x221.png 300w\" sizes=\"auto, (max-width: 665px) 100vw, 665px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Server<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Cadena de conexi\u00f3n del servidor<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Authentication<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Integrated Authentication<\/strong>: autenticaci\u00f3n Windows con la que conectarse.<\/li>\n\n\n\n<li><strong>SQL Server Authentication<\/strong>: usuario y pass de Sql server. Al seleccionarlo, es cuando se habilitan los textbox de <em>Login <\/em>y <em>Password<\/em>\n<ul class=\"wp-block-list\">\n<li><em>Login<\/em>: para poner el login de sql server<\/li>\n\n\n\n<li><em>Password<\/em>: para poner el pass del login de sql server<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Default Database<\/strong>:Selecciona la BBDD a la que conectarse<\/li>\n\n\n\n<li><strong>Share Connection Settings<\/strong>: \n<ul class=\"wp-block-list\">\n<li>Si se activa esto, es para que la consulta de Paremetrizaci\u00f3n comparta la configuraci\u00f3n de BBDD.<\/li>\n\n\n\n<li>Si no se activa, se tiene que volver a configurar el Server, la Authentication,<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Bot\u00f3n Parameter Substitution<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Como pueden configurarse las iteraciones, se puede configurar para que cada iteraci\u00f3n se haga con<br>par\u00e1metros distintos, desde esta ventana.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"597\" height=\"659\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-3.png\" alt=\"\" class=\"wp-image-701\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-3.png 597w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-3-272x300.png 272w\" sizes=\"auto, (max-width: 597px) 100vw, 597px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Por ejemplo, si se quisiera ejecutar esta llamada a un procedimiento<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"878\" height=\"541\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-6.png\" alt=\"\" class=\"wp-image-706\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-6.png 878w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-6-300x185.png 300w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-6-768x473.png 768w\" sizes=\"auto, (max-width: 878px) 100vw, 878px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Se necesitar\u00eda configurar el valor de <em>@Id<\/em> y con \u00abParameter Substitution\u00bb se puede configurar para que cada llamada fuera distinta. \u00bfC\u00f3mo?<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Al pulsar el bot\u00f3n saldr\u00eda la siguiente ventana  <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"543\" height=\"607\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-7.png\" alt=\"\" class=\"wp-image-707\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-7.png 543w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-7-268x300.png 268w\" sizes=\"auto, (max-width: 543px) 100vw, 543px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A continuaci\u00f3n se escribe la query que devolver\u00e1 los distintos valores que se quieren utilizar<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"542\" height=\"612\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-11.png\" alt=\"\" class=\"wp-image-711\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-11.png 542w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-11-266x300.png 266w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Se pulsa \u00abGet Columns\u00bb para que el programa recoja los par\u00e1metros de la consulta original y as\u00ed poder asignar el par\u00e1metro con el valor correspondiente de esta consulta.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"547\" height=\"615\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-12.png\" alt=\"\" class=\"wp-image-712\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-12.png 547w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-12-267x300.png 267w\" sizes=\"auto, (max-width: 547px) 100vw, 547px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">En este ejemplo, habria que asignar <em>@id<\/em> a la columna con nombre <em>BusinessEntityID<\/em>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u00bfC\u00f3mo funciona?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Se lanza la query ah\u00ed indicada y luego coge una fila por cada una de las iteraciones.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Si la query devuelve por ejemplo los siguientes valores:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>BusinessEntityID<\/strong><\/td><\/tr><tr><td>1<\/td><\/tr><tr><td>2<\/td><\/tr><tr><td>3<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Y se ha configurado para que haga 10 iteraciones, el resultado ser\u00e1:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>BusinessEntityID<\/strong><\/td><\/tr><tr><td>1<\/td><\/tr><tr><td>2<\/td><\/tr><tr><td>3<\/td><\/tr><tr><td>1<\/td><\/tr><tr><td>2<\/td><\/tr><tr><td>3<\/td><\/tr><tr><td>1<\/td><\/tr><tr><td>2<\/td><\/tr><tr><td>3<\/td><\/tr><tr><td>1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">y si fueran s\u00f3lo 2 iteraciones, ser\u00eda:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>BusinessEntityID<\/strong><\/td><\/tr><tr><td>1<\/td><\/tr><tr><td>2<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Es decir, <strong>si en la consulta de parametrizaci\u00f3n se obtienen menos filas que el n\u00ba de<br>iteraciones, se repetir\u00e1n los valores<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Men\u00fa File<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">Options<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Configuraciones varias de c\u00f3mo establecer conexi\u00f3n con la BBDD<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"606\" height=\"273\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-13.png\" alt=\"\" class=\"wp-image-713\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-13.png 606w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2025\/10\/image-13-300x135.png 300w\" sizes=\"auto, (max-width: 606px) 100vw, 606px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Save Settings<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Permite guardar un Json con la prueba que se est\u00e1 haciendo para poder repetirla otro d\u00eda.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Load Settings<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Permite leer un Json con una prueba (guardada antes)<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Save Brenchmark<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Guarda los datos del Brenchmark en 3 posibles formatos: <em>csv<\/em>, <em>Text<\/em>, <em>Clipboard<\/em>.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>TestId<\/li>\n\n\n\n<li>TestStartTime<\/li>\n\n\n\n<li>ElapsedTime<\/li>\n\n\n\n<li>Iterations<\/li>\n\n\n\n<li>Threads<\/li>\n\n\n\n<li>Delay<\/li>\n\n\n\n<li>CompletedIterations<\/li>\n\n\n\n<li>AvgCPUSeconds<\/li>\n\n\n\n<li>AvgActualSeconds<\/li>\n\n\n\n<li>AvgClientSeconds<\/li>\n\n\n\n<li>AvgLogicalReads<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Exit<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Salir de la aplicaci\u00f3n<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><em>SQLQueryStress <\/em>es una herramienta sencilla pero a su vez muy completa que ayuda en las tareas de optimizaci\u00f3n, que una vez se comprende c\u00f3mo funciona, es una gran aliada y espero que con esta peque\u00f1a gu\u00eda haya ayudado a comprenderla mejor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hay herramientas esenciales en la vida de un DBA y para mi una de esas es esta: SQLQueryStress. Por muchos a\u00f1os que pasen (porque ya tiene solera la herramienta) siempre llega el momento en el que acabas teniendo que recurrir a ella y por ello escribo hoy sobre ella.<\/p>\n","protected":false},"author":2,"featured_media":614,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-697","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sin-categoria"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Hay herramientas esenciales en la vida de un DBA y para mi una de esas es esta: SQLQueryStress. Por muchos a\u00f1os que pasen (porque ya tiene solera la herramienta) siempre llega el momento en el que acabas teniendo que recurrir a ella y por ello escribo hoy sobre ella.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Cristina Tarabini-Castellani Ciordia\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@DataCrazyWorld\" \/>\n\t\t<meta name=\"twitter:title\" content=\"C\u00f3mo no estresarse con SQLQueryStress - Data Crazy World\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Hay herramientas esenciales en la vida de un DBA y para mi una de esas es esta: SQLQueryStress. Por muchos a\u00f1os que pasen (porque ya tiene solera la herramienta) siempre llega el momento en el que acabas teniendo que recurrir a ella y por ello escribo hoy sobre ella.\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@DataCrazyWorld\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2022\/12\/Color_Small.png\" \/>\n\t\t<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t\t<meta name=\"twitter:data1\" content=\"Cristina Tarabini-Castellani Ciordia\" \/>\n\t\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura estimado\" \/>\n\t\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/#blogposting\",\"name\":\"C\\u00f3mo no estresarse con SQLQueryStress - Data Crazy World\",\"headline\":\"C\\u00f3mo no estresarse con SQLQueryStress\",\"author\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/SQLServerPill.png\",\"width\":1200,\"height\":600},\"datePublished\":\"2025-10-26T12:40:32+00:00\",\"dateModified\":\"2025-10-26T13:39:09+00:00\",\"inLanguage\":\"es-ES\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/#webpage\"},\"articleSection\":\"Sin categor\\u00eda\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com#listItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\\\/\\\/datacrazyworld.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sin-categoria\\\/#listItem\",\"name\":\"Sin categor\\u00eda\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sin-categoria\\\/#listItem\",\"position\":2,\"name\":\"Sin categor\\u00eda\",\"item\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sin-categoria\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/#listItem\",\"name\":\"C\\u00f3mo no estresarse con SQLQueryStress\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com#listItem\",\"name\":\"Inicio\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/#listItem\",\"position\":3,\"name\":\"C\\u00f3mo no estresarse con SQLQueryStress\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sin-categoria\\\/#listItem\",\"name\":\"Sin categor\\u00eda\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#person\",\"name\":\"Cristina Tarabini-Castellani Ciordia\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Cristina Tarabini-Castellani Ciordia\"},\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/DataCrazyWorld\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/cristina-tarabini-castellani\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/\",\"name\":\"Cristina Tarabini-Castellani Ciordia\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Cristina Tarabini-Castellani Ciordia\"},\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/DataCrazyWorld\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/cristina-tarabini-castellani\\\/\"]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/#webpage\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/\",\"name\":\"C\\u00f3mo no estresarse con SQLQueryStress - Data Crazy World\",\"description\":\"Hay herramientas esenciales en la vida de un DBA y para mi una de esas es esta: SQLQueryStress. Por muchos a\\u00f1os que pasen (porque ya tiene solera la herramienta) siempre llega el momento en el que acabas teniendo que recurrir a ella y por ello escribo hoy sobre ella.\",\"inLanguage\":\"es-ES\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/SQLServerPill.png\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/#mainImage\",\"width\":1200,\"height\":600},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2025\\\/10\\\/26\\\/como-no-estresarse-con-sqlquerystress\\\/#mainImage\"},\"datePublished\":\"2025-10-26T12:40:32+00:00\",\"dateModified\":\"2025-10-26T13:39:09+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#website\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/\",\"name\":\"DataCrazyWorld\",\"description\":\"SQL Server, PowerShell, Power BI, Power Platform,... Los datos, ese mundo tan interesante, variado, divertido y ... \\u00a1Loco!\",\"inLanguage\":\"es-ES\",\"publisher\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"C\u00f3mo no estresarse con SQLQueryStress - Data Crazy World","description":"Hay herramientas esenciales en la vida de un DBA y para mi una de esas es esta: SQLQueryStress. Por muchos a\u00f1os que pasen (porque ya tiene solera la herramienta) siempre llega el momento en el que acabas teniendo que recurrir a ella y por ello escribo hoy sobre ella.","canonical_url":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/#blogposting","name":"C\u00f3mo no estresarse con SQLQueryStress - Data Crazy World","headline":"C\u00f3mo no estresarse con SQLQueryStress","author":{"@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author"},"publisher":{"@id":"https:\/\/datacrazyworld.com\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/09\/SQLServerPill.png","width":1200,"height":600},"datePublished":"2025-10-26T12:40:32+00:00","dateModified":"2025-10-26T13:39:09+00:00","inLanguage":"es-ES","mainEntityOfPage":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/#webpage"},"isPartOf":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/#webpage"},"articleSection":"Sin categor\u00eda"},{"@type":"BreadcrumbList","@id":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com#listItem","position":1,"name":"Inicio","item":"https:\/\/datacrazyworld.com","nextItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sin-categoria\/#listItem","name":"Sin categor\u00eda"}},{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sin-categoria\/#listItem","position":2,"name":"Sin categor\u00eda","item":"https:\/\/datacrazyworld.com\/index.php\/category\/sin-categoria\/","nextItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/#listItem","name":"C\u00f3mo no estresarse con SQLQueryStress"},"previousItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com#listItem","name":"Inicio"}},{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/#listItem","position":3,"name":"C\u00f3mo no estresarse con SQLQueryStress","previousItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sin-categoria\/#listItem","name":"Sin categor\u00eda"}}]},{"@type":"Person","@id":"https:\/\/datacrazyworld.com\/#person","name":"Cristina Tarabini-Castellani Ciordia","image":{"@type":"ImageObject","@id":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g","width":96,"height":96,"caption":"Cristina Tarabini-Castellani Ciordia"},"sameAs":["https:\/\/twitter.com\/DataCrazyWorld","https:\/\/www.linkedin.com\/in\/cristina-tarabini-castellani\/"]},{"@type":"Person","@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author","url":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/","name":"Cristina Tarabini-Castellani Ciordia","image":{"@type":"ImageObject","@id":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g","width":96,"height":96,"caption":"Cristina Tarabini-Castellani Ciordia"},"sameAs":["https:\/\/twitter.com\/DataCrazyWorld","https:\/\/www.linkedin.com\/in\/cristina-tarabini-castellani\/"]},{"@type":"WebPage","@id":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/#webpage","url":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/","name":"C\u00f3mo no estresarse con SQLQueryStress - Data Crazy World","description":"Hay herramientas esenciales en la vida de un DBA y para mi una de esas es esta: SQLQueryStress. Por muchos a\u00f1os que pasen (porque ya tiene solera la herramienta) siempre llega el momento en el que acabas teniendo que recurrir a ella y por ello escribo hoy sobre ella.","inLanguage":"es-ES","isPartOf":{"@id":"https:\/\/datacrazyworld.com\/#website"},"breadcrumb":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/#breadcrumblist"},"author":{"@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author"},"creator":{"@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/09\/SQLServerPill.png","@id":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/#mainImage","width":1200,"height":600},"primaryImageOfPage":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/#mainImage"},"datePublished":"2025-10-26T12:40:32+00:00","dateModified":"2025-10-26T13:39:09+00:00"},{"@type":"WebSite","@id":"https:\/\/datacrazyworld.com\/#website","url":"https:\/\/datacrazyworld.com\/","name":"DataCrazyWorld","description":"SQL Server, PowerShell, Power BI, Power Platform,... Los datos, ese mundo tan interesante, variado, divertido y ... \u00a1Loco!","inLanguage":"es-ES","publisher":{"@id":"https:\/\/datacrazyworld.com\/#person"}}]},"twitter:card":"summary_large_image","twitter:site":"@DataCrazyWorld","twitter:title":"C\u00f3mo no estresarse con SQLQueryStress - Data Crazy World","twitter:description":"Hay herramientas esenciales en la vida de un DBA y para mi una de esas es esta: SQLQueryStress. Por muchos a\u00f1os que pasen (porque ya tiene solera la herramienta) siempre llega el momento en el que acabas teniendo que recurrir a ella y por ello escribo hoy sobre ella.","twitter:creator":"@DataCrazyWorld","twitter:image":"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2022\/12\/Color_Small.png","twitter:label1":"Escrito por","twitter:data1":"Cristina Tarabini-Castellani Ciordia","twitter:label2":"Tiempo de lectura estimado","twitter:data2":"4 minutos"},"aioseo_meta_data":{"post_id":"697","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"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":"","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":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","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":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2025-10-24 06:32:08","updated":"2025-10-26 13:49:00","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/datacrazyworld.com\" title=\"Inicio\">Inicio<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/datacrazyworld.com\/index.php\/category\/sin-categoria\/\" title=\"Sin categor\u00eda\">Sin categor\u00eda<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tC\u00f3mo no estresarse con SQLQueryStress\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Inicio","link":"https:\/\/datacrazyworld.com"},{"label":"Sin categor\u00eda","link":"https:\/\/datacrazyworld.com\/index.php\/category\/sin-categoria\/"},{"label":"C\u00f3mo no estresarse con SQLQueryStress","link":"https:\/\/datacrazyworld.com\/index.php\/2025\/10\/26\/como-no-estresarse-con-sqlquerystress\/"}],"_links":{"self":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts\/697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/comments?post=697"}],"version-history":[{"count":4,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts\/697\/revisions"}],"predecessor-version":[{"id":719,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts\/697\/revisions\/719"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/media\/614"}],"wp:attachment":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/media?parent=697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/categories?post=697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/tags?post=697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}