{"id":4645,"date":"2025-06-05T09:53:12","date_gmt":"2025-06-05T12:53:12","guid":{"rendered":"https:\/\/powertuning.com.br\/?p=4645"},"modified":"2025-06-05T09:57:51","modified_gmt":"2025-06-05T12:57:51","slug":"analise-de-ambiente-com-o-power-alerts","status":"publish","type":"post","link":"https:\/\/powertuning.com.br\/blog\/analise-de-ambiente-com-o-power-alerts\/","title":{"rendered":"An\u00e1lise de ambiente com o Power Alerts"},"content":{"rendered":"<h3><strong>Como analisar a performance do ambiente com o Power Alerts?<\/strong><\/h3>\n<p>Ol\u00e1, pessoal!<\/p>\n<p>Este post tem como objetivo demonstrar um passo a passo para analisar a performance da sua inst\u00e2ncia utilizando as coletas do Power Alerts.<\/p>\n<p>Se ainda n\u00e3o tem o Power Alerts na sua inst\u00e2ncia, voc\u00ea pode fazer o seu Trial de 30 dias para conhecer melhor a ferramenta.<\/p>\n<h3><strong>Iniciando a an\u00e1lise:<\/strong><\/h3>\n<p>Geralmente temos dois principais pontos de partida para uma an\u00e1lise de performance:<\/p>\n<ol>\n<li>Usu\u00e1rio informando dificuldade para realizar alguma atividade no momento;<\/li>\n<li>Alguma ocorr\u00eancia ou chamado informando que em tal dia e hor\u00e1rio teve algum problema de lentid\u00e3o;<\/li>\n<\/ol>\n<p>Em ambos os casos, temos a notifica\u00e7\u00e3o da ocorr\u00eancia por\u00e9m n\u00e3o temos detalhes do problema.<br \/>\nEnt\u00e3o, pode onde come\u00e7ar?<\/p>\n<p>Para isso podemos executar a procedure &#8220;stpPowerReport_SQL_Performance&#8221; que ir\u00e1 nos apresentar alguns indicadores que nos dar\u00e3o o norte para nossa an\u00e1lise.<\/p>\n<p>Para fins did\u00e1ticos, vamos imaginar que houve um relato de lentid\u00e3o no dia 26\/03\/2025 por volta das 15h.<\/p>\n<p>Portanto, iremos pedir a an\u00e1lise de 14 as 16 horas, para iniciar a investiga\u00e7\u00e3o.<\/p>\n<pre class=\"lang:tsql decode:true \">DECLARE @email VARCHAR(1000) = 'mail@powertuning.com.br'\r\n    , @Dt_Start DATETIME = '2025-03-26 14:00'\r\n    , @Dt_End DATETIME = '2025-03-26 16:00'\r\n\r\nEXEC Traces.dbo.stpPowerReport_SQL_Performance @Ds_Email=@email\r\n\t,@Dt_Start=@Dt_Start\r\n\t,@Dt_End=@Dt_End,@Ds_Query = null\r\n<\/pre>\n<p>Ser\u00e1 enviado para o seu e-mail os gr\u00e1ficos de an\u00e1lise do per\u00edodo informado.<\/p>\n<p>Abaixo iremos falar mais sobre eles.<\/p>\n<ul>\n<li>\n<h3><strong>CPU<\/strong><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"4649\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/analise-de-ambiente-com-o-power-alerts\/cpu\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/CPU.png\" data-orig-size=\"1700,700\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"CPU\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/CPU-1024x422.png\" class=\"aligncenter size-large wp-image-4649\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/CPU-1024x422.png\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/CPU-1024x422.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/CPU-300x124.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/CPU-768x316.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/CPU-1536x632.png 1536w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/CPU.png 1700w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>Em CPU podemos verificar que o consumo \u00e9 relativamente linear, por\u00e9m as 15h00 de fato teve uma eleva\u00e7\u00e3o.<\/p>\n<p>Esse poderia ser o primeiro ponto de an\u00e1lise: identificar o que fez o consumo de CPU aumentar e analisar as poss\u00edveis aplica\u00e7\u00f5es de tuning.<\/p>\n<p>Para realizar essa an\u00e1lise podemos consultar as tabelas observando as colunas CPU e CPU_Delta:<\/p>\n<ul>\n<li>PowerRoutine_Log_WhoIsActive<\/li>\n<li>PowerRoutine_Queries_Profile<\/li>\n<li>PowerRoutine_CPU_Query_Use<\/li>\n<\/ul>\n<p>Para verificar o consumo de CPU por determinado per\u00edodo podemos utilizar o comando abaixo:<\/p>\n<pre class=\"lang:tsql decode:true \">SELECT *\r\nFROM vwPowerRoutine_Log_Counter\r\nWHERE Nm_Counter = 'CPU'\r\nAND Dt_Log BETWEEN '2025-01-26 14:00' AND '2025-01-26 16:00'<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<h3><strong>PLE<\/strong><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"4650\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/analise-de-ambiente-com-o-power-alerts\/ple\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/PLE.png\" data-orig-size=\"1700,700\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"PLE\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/PLE-1024x422.png\" class=\"aligncenter size-large wp-image-4650\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/PLE-1024x422.png\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/PLE-1024x422.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/PLE-300x124.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/PLE-768x316.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/PLE-1536x632.png 1536w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/PLE.png 1700w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>No gr\u00e1fico do PLE podemos notar uma queda significativa \u00e0s 15h00. Isso pode significar press\u00e3o de mem\u00f3ria.<\/p>\n<p>Ent\u00e3o, entra aqui nosso segundo ponto de an\u00e1lise: identificar o que ocorreu para ocasionar a queda do PLE.<\/p>\n<p>Pode ser alguma ou algumas queries com SCAN gigantes gerando press\u00e3o na mem\u00f3ria e derrubando o PLE, ou tamb\u00e9m pode ser alguma a\u00e7\u00e3o externa ao SQL.<\/p>\n<p>Para realizar essa an\u00e1lise podemos consultar as tabelas, observando as colunas Reads, Reads_Delta, Writes, Writes_delta e used_memory:<\/p>\n<ul>\n<li>PowerRoutine_Log_WhoIsActive<\/li>\n<li>PowerRoutine_Queries_Profile<\/li>\n<\/ul>\n<p>Para verificar os indicadores de PLE podemos utilizar o comando abaixo:<\/p>\n<pre class=\"lang:tsql decode:true\">SELECT *\r\nFROM vwPowerRoutine_Log_Counter\r\nWHERE Nm_Counter = 'Page Life Expectancy'\r\nAND Dt_Log BETWEEN '2025-01-26 14:00' AND '2025-01-26 16:00'<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<h3><strong>Batch Requests<\/strong><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"4647\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/analise-de-ambiente-com-o-power-alerts\/batch-requests\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Batch-Requests.png\" data-orig-size=\"1700,700\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Batch Requests\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Batch-Requests-1024x422.png\" class=\"aligncenter size-large wp-image-4647\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Batch-Requests-1024x422.png\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Batch-Requests-1024x422.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Batch-Requests-300x124.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Batch-Requests-768x316.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Batch-Requests-1536x632.png 1536w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Batch-Requests.png 1700w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>No gr\u00e1fico de Batch Requests ir\u00e1 nos mostrar a quantidade de requisi\u00e7\u00f5es.<\/p>\n<p>\u00c9 poss\u00edvel notar que \u00e0s 15h00 houve um aumento significativo de requisi\u00e7\u00f5es, at\u00e9 as 15h30, voltando normalizar \u00e0s 15h35.<\/p>\n<p>O aumento de requisi\u00e7\u00f5es pode demonstrar uma necessidade de melhoria tuning ou hardware, para comportar melhor hor\u00e1rios de picos.<\/p>\n<p>Para verificar como est\u00e3o os Batch Request de determinado per\u00edodo podemos utilizar o comando abaixo:<\/p>\n<pre class=\"lang:tsql decode:true \">SELECT *\r\nFROM vwPowerRoutine_Log_Counter\r\nWHERE Nm_Counter = 'BatchRequests'\r\nAND Dt_Log BETWEEN '2025-01-26 14:00' AND '2025-01-26 16:00'<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<h3><strong>Quantidade de Conex\u00f5es<\/strong><\/h3>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"4654\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/analise-de-ambiente-com-o-power-alerts\/user-connection\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/User-Connection.png\" data-orig-size=\"1700,700\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"User Connection\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/User-Connection-1024x422.png\" class=\"aligncenter size-large wp-image-4654\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/User-Connection-1024x422.png\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/User-Connection-1024x422.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/User-Connection-300x124.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/User-Connection-768x316.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/User-Connection-1536x632.png 1536w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/User-Connection.png 1700w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>As quantidades de conex\u00f5es se manteram est\u00e1veis no per\u00edodo.<\/p>\n<p>Um desbalanceamento nesse gr\u00e1fico poderia mostrar o comportamento dos usu\u00e1rios, se h\u00e1 picos em determinandos dias, hor\u00e1rios, etc.<\/p>\n<p>Para verificar as quantidade de conex\u00f5es podemos utilizar o comando abaixo:<\/p>\n<pre class=\"lang:tsql decode:true \">SELECT *\r\nFROM vwPowerRoutine_Log_Counter\r\nWHERE Nm_Counter = 'User_Connection'\r\nAND Dt_Log BETWEEN '2025-01-26 14:00' AND '2025-01-26 16:00'<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<h3><strong>Bloqueios<\/strong><\/h3>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"4648\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/analise-de-ambiente-com-o-power-alerts\/bloqueios\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Bloqueios.png\" data-orig-size=\"1700,700\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Bloqueios\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Bloqueios-1024x422.png\" class=\"aligncenter size-large wp-image-4648\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Bloqueios-1024x422.png\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Bloqueios-1024x422.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Bloqueios-300x124.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Bloqueios-768x316.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Bloqueios-1536x632.png 1536w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Bloqueios.png 1700w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>Analisando o gr\u00e1fico de bloqueios podemos identificar um ligeiro aumento na quantidade de bloqueios no per\u00edodo informando. Tanto em quantidade como em tempo.<\/p>\n<p>Isso pode sinalizar que o ambiente esteja enfrentando concorr\u00eancia por objetos e a lentid\u00e3o, na verdade, \u00e9 a espera pela libera\u00e7\u00e3o dos recursos e n\u00e3o por uma query lenta ou falta de recursos.<\/p>\n<p>Como ponto de an\u00e1lise seria identificar as queries e analisar o plano de execu\u00e7\u00e3o em busca de melhorias.<\/p>\n<p>As vezes ser\u00e1 necess\u00e1ria uma reescrita por parte da aplica\u00e7\u00e3o para evitar essas concorr\u00eancias.<\/p>\n<p>Para realizar essa an\u00e1lise podemos consultar a tabela \u201cPowerRoutine_Log_WhoIsActive\u201d, observando as colunas session_id, blocking_session_id, wait_info e wait_resource:<\/p>\n<pre class=\"lang:tsql decode:true\">SELECT *\r\nFROM PowerRoutine_Log_WhoIsActive\r\nWHERE Dt_Log BETWEEN '2025-01-26 14:00' AND '2025-01-26 16:00'\r\nORDER BY Dt_Log<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<h3><strong>Queries Demoradas<\/strong><\/h3>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"4652\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/analise-de-ambiente-com-o-power-alerts\/slow-queries-grafico\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Grafico.png\" data-orig-size=\"1700,700\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Slow Queries &amp;#8211; Grafico\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Grafico-1024x422.png\" class=\"aligncenter size-large wp-image-4652\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Grafico-1024x422.png\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Grafico-1024x422.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Grafico-300x124.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Grafico-768x316.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Grafico-1536x632.png 1536w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Grafico.png 1700w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>Podemos observar que houve um aumento na quantidade de queries demoradas (maiores que 3 segundos) no hor\u00e1rio informado. Devemos analisar a situa\u00e7\u00e3o procurando duas principais ocorr\u00eancias:<\/p>\n<ul>\n<li>Repeti\u00e7\u00f5es da mesma query: caso identifiquemos esse cen\u00e1rio, devemos atuar na melhoria dessa query para otimizar o consumo da inst\u00e2ncia<\/li>\n<li>Alto consumo: identificar queries que possam estar recrutando muitos recursos e penalizando as demais, gerando o aumento do tempo.<\/li>\n<\/ul>\n<p>Aqui \u00e9 importante ter em mente que cada caso \u00e9 um caso.<\/p>\n<p>Por isso a import\u00e2ncia de analisar e identificar os dois cen\u00e1rios descritos anteriormente mas n\u00e3o se ater somente \u00e0 eles.<\/p>\n<p>Nem sempre teremos uma query \u201cbomba\u201d ou v\u00e1rias da \u201cmesma consulta\u201d sendo executados no momento.<\/p>\n<p>As vezes teremos cen\u00e1rios homog\u00eanios e precisaremos ir priorizando por ordem de import\u00e2ncia e impacto.<\/p>\n<p>Ao identificar as query ofensoras devemos verificar seu impacto no neg\u00f3cio, pois uma query isolada pode resolver a dor do usu\u00e1rio ou do neg\u00f3cio no momento. Ou seja, deixar o ambiente mais r\u00e1pido mas, esse processo espec\u00edfico lento, n\u00e3o estaremos resolvendo o \u201cproblema de lentid\u00e3o\u201d do usu\u00e1rio em um faturamento de folha, por exemplo.<\/p>\n<p>Para realizar essa an\u00e1lise podemos consultar a tabela \u201cPowerRoutine_Queries_Profile\u201d:<\/p>\n<pre class=\"lang:tsql decode:true\">SELECT *\r\nFROM PowerRoutine_Queries_Profile\r\nWHERE StartTime BETWEEN '2025-01-26 14:00' AND '2025-01-26 16:00'\r\nORDER BY StartTime<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"4651\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/analise-de-ambiente-com-o-power-alerts\/slow-queries-concorrencia\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Concorrencia.png\" data-orig-size=\"1700,700\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Slow Queries &amp;#8211; Concorr\u00eancia\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Concorrencia-1024x422.png\" class=\"aligncenter size-large wp-image-4651\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Concorrencia-1024x422.png\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Concorrencia-1024x422.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Concorrencia-300x124.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Concorrencia-768x316.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Concorrencia-1536x632.png 1536w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/Slow-Queries-Concorrencia.png 1700w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>Nessa vis\u00e3o temos o mesmo conceito do item anterior, por\u00e9m ela nos mostrar\u00e1 as concorr\u00eancias desse per\u00edodo.<\/p>\n<p>Portanto, podemos ver que a consulta 1304757 iniciou pr\u00f3ximo \u00e0s 15h00 e j\u00e1 haviam algumas outras rodando.<\/p>\n<p>Por ser um hor\u00e1rio bem pr\u00f3ximo da reclama\u00e7\u00e3o, podemos verificar essa consulta para analisar se ela pode estar relacionada ao ocorrido no ambiente.<\/p>\n<p>A an\u00e1lise tamb\u00e9m poder\u00e1 ser feita na tabela \u201cPowerRoutine_Queries_Profile\u201d informando o ID da consulta:<\/p>\n<pre class=\"lang:tsql decode:true\">SELECT *\r\nFROM PowerRoutine_Queries_Profile\r\nWHERE StartTime BETWEEN '2025-01-26 14:00' AND '2025-01-26 16:00'\r\nAND Id_Part_Query = 1304757\r\nORDER BY StartTime<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<h3><strong>TempDB<\/strong><\/h3>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"4653\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/analise-de-ambiente-com-o-power-alerts\/tempdb\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/TempDB.png\" data-orig-size=\"1700,700\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"TempDB\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/TempDB-1024x422.png\" class=\"aligncenter size-large wp-image-4653\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/TempDB-1024x422.png\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/TempDB-1024x422.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/TempDB-300x124.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/TempDB-768x316.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/TempDB-1536x632.png 1536w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/TempDB.png 1700w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>Pelo gr\u00e1fico, podemos notar um aumento no per\u00edodo informado no consumo da TempDB.<\/p>\n<p>A utiliza\u00e7\u00e3o da tempdb est\u00e1 atrelada a utiliza\u00e7\u00e3o de tabelas tempor\u00e1rias, organiza\u00e7\u00e3o de ordem das consultas (order by), spill de mem\u00f3ria, al\u00e9m de concorr\u00eancia dentro de seus pr\u00f3prios arquivos.<\/p>\n<p>Como ela utiliza o disco, o fator hardware poder\u00e1 pesar nessa an\u00e1lise.<\/p>\n<p>Para realizar essa an\u00e1lise podemos consultar as tabelas, observando as colunas tempdb_allocations, tempdb_current, tempdb_allocations_delta e tempdb_current_delta:<\/p>\n<ul>\n<li>PowerRoutine_Log_WhoIsActive<\/li>\n<li>PowerRoutine_Tempdb_Query_Use<\/li>\n<li>PowerRoutine_Tempdb_File_Used<\/li>\n<\/ul>\n<h3><strong>Conclus\u00e3o<\/strong><\/h3>\n<p>Essas foram as principais an\u00e1lise de performance que podemos fazer em nossa inst\u00e2ncia em busca de melhorias e identificar ofensores de performances.<\/p>\n<p>H\u00e1 muitos mais outros dados coletados que podem ajudar em an\u00e1lises mais aprofundadas de ocorr\u00eancias do dia a dia.<\/p>\n<p>Se interessou? Entre em contato com o comercial e solicite j\u00e1 o seu.<\/p>\n<p>Artigo desenvolvido por David Styveen (Tech Leader).<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Como analisar a performance do ambiente com o Power Alerts? Ol\u00e1, pessoal! Este post tem como objetivo demonstrar um passo a passo para analisar a performance da sua inst\u00e2ncia utilizando as coletas do Power Alerts. Se ainda n\u00e3o tem o Power Alerts na sua inst\u00e2ncia, voc\u00ea pode fazer o seu Trial de 30 dias para&hellip; <br \/> <a class=\"read-more\" href=\"https:\/\/powertuning.com.br\/blog\/analise-de-ambiente-com-o-power-alerts\/\">Leia mais<\/a><\/p>\n","protected":false},"author":20,"featured_media":4689,"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_post_was_ever_published":false,"_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":""},"categories":[59,124,138,64,183,167,1,63],"tags":[527,520,517,530,506,13,512,514,513,509,525,508,523,518,511,54,510,141,22,516,528,515,522,529,526,35,519,524,521,531,507],"class_list":["post-4645","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tuning","category-postgresql","category-power-alerts","category-power-bi","category-power-embedded","category-power-pilot","category-sem-categoria","category-sql-server","tag-ambiente-sql-server","tag-analise-de-desempenho","tag-analise-de-instancia","tag-analise-de-lentidao","tag-analise-de-performance","tag-banco-de-dados","tag-batch-requests","tag-bloqueios-sql","tag-conexoes-sql","tag-cpu-alta","tag-indicadores-de-performance","tag-lentidao-em-sistemas","tag-monitoramento-de-sql","tag-otimizacao-de-consultas","tag-page-life-expectancy","tag-performance-sql-server","tag-ple","tag-power-alerts","tag-power-tuning","tag-powerroutine","tag-queries-demoradas","tag-queries-lentas","tag-queries-pesadas","tag-scan-sql","tag-sql-performance-troubleshooting","tag-sql-server","tag-sql-tuning","tag-stppowerreport_sql_performance","tag-tempdb","tag-tuning-de-queries","tag-tuning-de-sql"],"jetpack_featured_media_url":"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2025\/05\/capa-blog-hohe-3.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts\/4645","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\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/comments?post=4645"}],"version-history":[{"count":4,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts\/4645\/revisions"}],"predecessor-version":[{"id":4691,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts\/4645\/revisions\/4691"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/media\/4689"}],"wp:attachment":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/media?parent=4645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/categories?post=4645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/tags?post=4645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}