{"id":8327,"date":"2026-02-27T16:30:27","date_gmt":"2026-02-27T19:30:27","guid":{"rendered":"https:\/\/powertuning.com.br\/?p=8327"},"modified":"2026-04-27T15:57:17","modified_gmt":"2026-04-27T18:57:17","slug":"caso-real-power-alerts-query-simples-tambem-fazem-estrago","status":"publish","type":"post","link":"https:\/\/powertuning.com.br\/blog\/caso-real-power-alerts-query-simples-tambem-fazem-estrago\/","title":{"rendered":"Caso real Power Alerts: Query simples tamb\u00e9m fazem estrago!"},"content":{"rendered":"<p class=\"article-editor-paragraph article-editor-content__has-focus\">Uma query \u201csimples\u201d (TOP 250, sem JOIN) estava queimando recurso sem ningu\u00e9m perceber.<\/p>\n<p class=\"article-editor-paragraph\">Cada execu\u00e7\u00e3o custava ~60 GB de leituras l\u00f3gicas e ~10,5 s de CPU.<\/p>\n<p class=\"article-editor-paragraph\">Com 400+ execu\u00e7\u00f5es\/dia, o estrago era:<\/p>\n<h3 class=\"article-editor-heading\">~23,4 TB\/dia de logical reads e ~70 min\/dia de CPU<\/h3>\n<h4 class=\"article-editor-heading\">Em alguns minutos de an\u00e1lise na Power Tuning, chegamos numa alternativa que derrubou para:<\/h4>\n<h3 class=\"article-editor-heading\">~10 GB\/dia de logical reads e ~15 min\/dia de CPU<\/h3>\n<p class=\"article-editor-paragraph\">E o melhor: ainda tem espa\u00e7o pra evoluir, mas s\u00f3 esse ajuste r\u00e1pido j\u00e1 muda completamente o jogo.<\/p>\n<h3 class=\"article-editor-heading\">E o ponto aqui \u00e9: isso \u00e9 mais comum do que parece.<\/h3>\n<p class=\"article-editor-paragraph\">Muita gente tem \u201cqueries simples\u201d rodando centenas (ou milhares) de vezes por dia, consumindo recurso no autom\u00e1tico&#8230; at\u00e9 o dia que o ambiente come\u00e7a a sofrer e ningu\u00e9m entende o porqu\u00ea.<\/p>\n<p class=\"article-editor-paragraph\">Se voc\u00ea suspeita que tem algo parecido no seu SQL Server, vale a pena olhar com carinho e se precisar de ajuda, conte com a Power Tuning.<\/p>\n<p><em>Artigo desenvolvido por: Eduardo Rabelo (Tech Leader).<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Uma query \u201csimples\u201d (TOP 250, sem JOIN) estava queimando recurso sem ningu\u00e9m perceber. Cada execu\u00e7\u00e3o custava ~60 GB de leituras l\u00f3gicas e ~10,5 s de CPU. Com 400+ execu\u00e7\u00f5es\/dia, o estrago era: ~23,4 TB\/dia de logical reads e ~70 min\/dia de CPU Em alguns minutos de an\u00e1lise na Power Tuning, chegamos numa alternativa que derrubou&hellip; <br \/> <a class=\"read-more\" href=\"https:\/\/powertuning.com.br\/blog\/caso-real-power-alerts-query-simples-tambem-fazem-estrago\/\">Leia mais<\/a><\/p>\n","protected":false},"author":17,"featured_media":8329,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[62,138],"tags":[932,1034,1020,527,818,1007,1021,53,1036,1030,933,934,1006,1037,1010,918,1022,908,54,22,1040,1018,1032,1038,35,1039,942,1041,1031,1035,915,1029,1033,1005],"class_list":["post-8327","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-casos-reais-de-clientes","category-power-alerts","tag-administracao-sql-server","tag-ajuste-de-query-sql-server","tag-alta-cpu-sql-server","tag-ambiente-sql-server","tag-banco-de-dados-performance","tag-banco-de-dados-sql-server","tag-consultas-lentas-sql-server","tag-consultoria-sql-server","tag-consumo-de-cpu-sql-server","tag-cpu-alto-sql-server","tag-dba-sql-server","tag-diagnostico-sql-server","tag-eduardo-rabelo","tag-leitura-logica-sql-server","tag-logical-reads-sql-server","tag-microsoft-sql-server","tag-otimizacao-sql-server","tag-performance-database","tag-performance-sql-server","tag-power-tuning","tag-queries-pesadas-sql-server","tag-query-performance-sql-server","tag-query-simples-sql-server","tag-sql-query-tuning","tag-sql-server","tag-sql-server-health-check","tag-sql-server-internals","tag-sql-server-monitoring","tag-sql-server-optimization","tag-sql-server-resource-usage","tag-sql-server-tuning","tag-tech-leader-sql-server","tag-top-query-sql-server","tag-troubleshooting-sql-server"],"jetpack_featured_media_url":"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2026\/02\/Capa_Blog-2-3.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts\/8327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/comments?post=8327"}],"version-history":[{"count":1,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts\/8327\/revisions"}],"predecessor-version":[{"id":8330,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts\/8327\/revisions\/8330"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/media\/8329"}],"wp:attachment":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/media?parent=8327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/categories?post=8327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/tags?post=8327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}