http://wiki.mstech.com.br/index.php?action=history&feed=atom&title=Identifica_as_querys_com_custo_elevado_de_processamento 2026-05-07T17:44:20Z Histórico de revisões para esta página neste wiki MediaWiki 1.26.2 http://wiki.mstech.com.br/index.php?title=Identifica_as_querys_com_custo_elevado_de_processamento&diff=2118&oldid=prev 2016-08-23T16:27:23Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='pt-BR'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Edição anterior</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Edição das 16h27min de 23 de agosto de 2016</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Linha 1:</td> <td colspan="2" class="diff-lineno">Linha 1:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Este script retorna as '''querys''' que mais consomem tempo de execução pelo SQL Server.</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Este script retorna as '''querys''' que mais consomem tempo de execução pelo SQL Server.</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&lt;syntaxhighlight lang=&quot;sql<del class="diffchange diffchange-inline">&quot; line=&quot;1</del>&quot; &gt;</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&lt;syntaxhighlight lang=&quot;sql&quot;&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>SELECT TOP 15</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>SELECT TOP 15</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> </table>

Daniel.alves http://wiki.mstech.com.br/index.php?title=Identifica_as_querys_com_custo_elevado_de_processamento&diff=1733&oldid=prev 2016-08-04T18:00:15Z

<p>Criou página com &#039;Este script retorna as &#039;&#039;&#039;querys&#039;&#039;&#039; que mais consomem tempo de execução pelo SQL Server. &lt;syntaxhighlight lang=&quot;sql&quot; line=&quot;1&quot; &gt; SELECT TOP 15 SUM(query_stats.total_wor...&#039;</p> <p><b>Página nova</b></p><div>Este script retorna as '''querys''' que mais consomem tempo de execução pelo SQL Server.<br /> <br /> &lt;syntaxhighlight lang=&quot;sql&quot; line=&quot;1&quot; &gt;<br /> SELECT TOP 15<br /> <br /> SUM(query_stats.total_worker_time) / SUM(query_stats.execution_count) AS &quot;Avg CPU Time&quot;,<br /> MIN(query_stats.statement_text) AS &quot;Statement Text&quot;<br /> FROM<br /> (SELECT QS.*,<br /> SUBSTRING(ST.text, (QS.statement_start_offset/2) + 1,<br /> ((CASE statement_end_offset<br /> WHEN -1 THEN DATALENGTH(st.text)<br /> ELSE QS.statement_end_offset END <br /> - QS.statement_start_offset)/2) + 1) AS statement_text<br /> FROM sys.dm_exec_query_stats AS QS<br /> CROSS APPLY sys.dm_exec_sql_text(QS.sql_handle) as ST) as query_stats<br /> GROUP BY query_stats.query_hash<br /> ORDER BY 1 DESC;<br /> &lt;/syntaxhighlight&gt;</div>

Daniel.alves