{"id":1942,"date":"2023-03-20T22:15:31","date_gmt":"2023-03-21T01:15:31","guid":{"rendered":"https:\/\/powertuning.com.br\/?page_id=1942"},"modified":"2025-01-27T10:10:28","modified_gmt":"2025-01-27T13:10:28","slug":"poweralerts","status":"publish","type":"page","link":"https:\/\/powertuning.com.br\/blog\/poweralerts\/","title":{"rendered":"Power Alerts for SQL Server"},"content":{"rendered":"<p><a href=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts.pdf\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3228\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/baixe-o-pdf-completo-aqui\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Baixe-o-pdf-completo-aqui.png\" data-orig-size=\"300,127\" 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=\"Baixe-o-pdf-completo-aqui\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Baixe-o-pdf-completo-aqui.png\" class=\"alignnone size-full wp-image-3228 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Baixe-o-pdf-completo-aqui.png\" alt=\"\" width=\"300\" height=\"127\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>O objetivo desse trabalho \u00e9 realizar a implanta\u00e7\u00e3o do nosso sistema de alertas, o Power Alerts.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1994\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/whatsapp-image-2023-03-20-at-23-06-10\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/WhatsApp-Image-2023-03-20-at-23.06.10.jpeg\" data-orig-size=\"1280,537\" 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=\"WhatsApp Image 2023-03-20 at 23.06.10\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/WhatsApp-Image-2023-03-20-at-23.06.10-1024x430.jpeg\" class=\"size-medium wp-image-1994 alignright\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/WhatsApp-Image-2023-03-20-at-23.06.10-300x126.jpeg\" alt=\"\" width=\"300\" height=\"126\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/WhatsApp-Image-2023-03-20-at-23.06.10-300x126.jpeg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/WhatsApp-Image-2023-03-20-at-23.06.10-1024x430.jpeg 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/WhatsApp-Image-2023-03-20-at-23.06.10-768x322.jpeg 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/WhatsApp-Image-2023-03-20-at-23.06.10.jpeg 1280w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<h3><strong>1. O que \u00e9 o Power Alerts?<\/strong><\/h3>\n<p>\u00c9 uma ferramenta de 62 mil linhas de c\u00f3digo em T-SQL (e crescendo) criada de DBA SQL Server para DBA SQL Server com dezenas de Alertas para monitorar seu banco de dados e, agora, com a feature de gr\u00e1ficos para facilitar sua visualiza\u00e7\u00e3o e entendimento do ambiente.<\/p>\n<p>O Power Alerts \u00e9 um complemento de qualquer ferramenta de monitoramento porque ele j\u00e1 retorna informa\u00e7\u00f5es detalhadas e com gr\u00e1ficos no pr\u00f3prio e-mail (sem que voc\u00ea tenha que olhar uma tela de monitoramento ou logar no ambiente). Quem tem um SQL Server, vai ficar feliz de ter esses alertas e logs que s\u00e3o gerados para o DBA.<\/p>\n<p><strong>Nessa live demos mais detalhes sobre o Power Alerts:<\/strong><\/p>\n<div class=\"lyte-wrapper fourthree\" style=\"width:420px;max-width:100%;margin:5px;\"><div class=\"lyMe\" id=\"WYL_hZ3TCH4dgCg\"><div id=\"lyte_hZ3TCH4dgCg\" data-src=\"\/\/i.ytimg.com\/vi\/hZ3TCH4dgCg\/hqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\"><\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/hZ3TCH4dgCg\" rel=\"nofollow\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i.ytimg.com\/vi\/hZ3TCH4dgCg\/0.jpg\" alt=\"YouTube video thumbnail\" width=\"420\" height=\"295\" \/><br \/>Assista a este v\u00eddeo no YouTube<\/a><\/noscript><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:420px;margin:5px;\"><\/div><\/p>\n<div class=\"espaco\"><\/div>\n<p>N\u00e3o existe nada parecido com isso hoje aqui no Brasil (e nem l\u00e1 fora at\u00e9 onde sabemos).<\/p>\n<p><strong>Dash com os clientes que j\u00e1 receberam o Power Alerts:<\/strong><\/p>\n<ul>\n<li><a href=\"http:\/\/powertuning.com.br\/clientes-poweralerts\">http:\/\/powertuning.com.br\/clientes-poweralerts<\/a><\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" width=\"100%\" height=\"600px\" src=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiNzc3NmE2YmItZjY4Mi00OWYwLWExN2UtMjk4MmQ2NTM5MDIxIiwidCI6Ijc2OGM1NWMwLWViNjktNDhiZC04ODYyLWQ2ODYwZjU4NWVkNiJ9\" data-mce-fragment=\"1\"><\/iframe><\/p>\n<h3><\/h3>\n<h3><strong>2. Alertas criados<\/strong><\/h3>\n<p>Esses s\u00e3o os Alertas que s\u00e3o criados na Implementa\u00e7\u00e3o do Power Alerts:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3175\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/alertas-2\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/alertas.png\" data-orig-size=\"1065,816\" 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=\"alertas\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/alertas-1024x785.png\" class=\"wp-image-3175 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/alertas-1024x785.png\" alt=\"\" width=\"946\" height=\"725\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/alertas-1024x785.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/alertas-300x230.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/alertas-768x588.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/alertas.png 1065w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Plus 1: Criamos tamb\u00e9m um e-mail mensal<\/strong> com informa\u00e7\u00f5es da inst\u00e2ncia para ser utilizado em caso de desastre como uma documenta\u00e7\u00e3o para saber como estava a inst\u00e2ncia antes do ambiente.<\/p>\n<p>Isso ajuda a reinstalar o ambiente sem impactos de mudan\u00e7as (ajuda demais em casos de desastre).<\/p>\n<p><strong>Plus 2: Cria\u00e7\u00e3o de um Checklist di\u00e1rio do ambiente com gr\u00e1ficos<\/strong> para enviar informa\u00e7\u00f5es da inst\u00e2ncia diariamente e ajudar na an\u00e1lise e compara\u00e7\u00e3o de informa\u00e7\u00f5es em per\u00edodos diferentes.<\/p>\n<p>Usamos bastante para dar uma analisada r\u00e1pida no ambiente ou para comparar como est\u00e3o os valores entre duas datas distintas.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong>3. Exemplo de um Alerta de Log FULL<\/strong><\/h3>\n<p>Esse \u00e9 o cabe\u00e7alho do alerta que possui v\u00e1rias informa\u00e7\u00f5es \u00fateis:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3176\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/criticidade\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/criticidade.png\" data-orig-size=\"700,593\" 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=\"criticidade\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/criticidade.png\" class=\"size-full wp-image-3176 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/criticidade.png\" alt=\"\" width=\"700\" height=\"593\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/criticidade.png 700w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/criticidade-300x254.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>Conforme podemos ver abaixo, no pr\u00f3prio e-mail j\u00e1 mostra o motivo do log estar preso (nesse caso \u00e9 falta de backup do log \u2013 Coluna \u201cLog Reuse Wait\u201d com o valor \u201cLOG_BACKUP\u201d).<\/p>\n<p>Tamb\u00e9m mostra o disco que esse log est\u00e1 e o espa\u00e7o livre dele para te deixar mais tranquilo ou preocupado quando chegar esse alerta.<\/p>\n<p>Ainda temos o quanto esse log vai crescer e se ele est\u00e1 limitado (para ver se ele est\u00e1 crescendo muito ou pouco isso ajuda bastante).<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3209\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/top-10-log-2\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-10-log-1.png\" data-orig-size=\"899,315\" 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=\"top 10 log\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-10-log-1.png\" class=\"size-full wp-image-3209 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-10-log-1.png\" alt=\"\" width=\"899\" height=\"315\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-10-log-1.png 899w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-10-log-1-300x105.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-10-log-1-768x269.png 768w\" sizes=\"auto, (max-width: 899px) 100vw, 899px\" \/><\/p>\n<p>As primeiras informa\u00e7\u00f5es que o DBA teria que logar e descobrir em um alerta como esse j\u00e1 est\u00e3o mastigadas no alerta. Produtividade e economia de horas do DBA ($).<\/p>\n<p>Seguindo no e-mail, temos um gr\u00e1fico para facilitar sua visualiza\u00e7\u00e3o de quando o log come\u00e7ou a crescer e o tempo que ele levou para estourar.<\/p>\n<p>\u00daltimos 60 minutos para ver o comportamento recente do log:<\/p>\n<p><strong> <img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3205\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_08_image_0004\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_08_Image_0004.jpg\" data-orig-size=\"945,391\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_08_Image_0004\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_08_Image_0004.jpg\" class=\"size-full wp-image-3205 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_08_Image_0004.jpg\" alt=\"\" width=\"945\" height=\"391\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_08_Image_0004.jpg 945w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_08_Image_0004-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_08_Image_0004-768x318.jpg 768w\" sizes=\"auto, (max-width: 945px) 100vw, 945px\" \/><\/strong><\/p>\n<p>\u00daltimas 48 horas para ter uma vis\u00e3o mais longa do comportamento do log:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3204\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_09_image_0002\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0002.jpg\" data-orig-size=\"957,400\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_09_Image_0002\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0002.jpg\" class=\"alignnone size-full wp-image-3204 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0002.jpg\" alt=\"\" width=\"957\" height=\"400\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0002.jpg 957w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0002-300x125.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0002-768x321.jpg 768w\" sizes=\"auto, (max-width: 957px) 100vw, 957px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Seguindo ainda no e-mail, temos um gr\u00e1fico para facilitar a visualiza\u00e7\u00e3o de como est\u00e1 o consumo do disco onde est\u00e1 esse arquivo de log. Se ele est\u00e1 acabando r\u00e1pido ou devagar. Nenhum alerta de log por a\u00ed na internet tr\u00e1s essa informa\u00e7\u00e3o.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3203\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_09_image_0003\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0003.jpg\" data-orig-size=\"784,157\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_09_Image_0003\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0003.jpg\" class=\"alignnone size-full wp-image-3203 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0003.jpg\" alt=\"\" width=\"784\" height=\"157\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0003.jpg 784w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0003-300x60.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0003-768x154.jpg 768w\" sizes=\"auto, (max-width: 784px) 100vw, 784px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3202\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_09_image_0004\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0004.jpg\" data-orig-size=\"946,387\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_09_Image_0004\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0004.jpg\" class=\"alignnone size-full wp-image-3202 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0004.jpg\" alt=\"\" width=\"946\" height=\"387\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0004.jpg 946w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0004-300x123.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_09_Image_0004-768x314.jpg 768w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Como um dos problemas comuns pode ser a falta de backup, o alerta tamb\u00e9m mostra quando foi o \u00faltimo backup do log da base com Log FULL:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3201\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_10_image_0002\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_10_Image_0002.jpg\" data-orig-size=\"849,203\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_10_Image_0002\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_10_Image_0002.jpg\" class=\"alignnone size-full wp-image-3201 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_10_Image_0002.jpg\" alt=\"\" width=\"849\" height=\"203\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_10_Image_0002.jpg 849w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_10_Image_0002-300x72.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_10_Image_0002-768x184.jpg 768w\" sizes=\"auto, (max-width: 849px) 100vw, 849px\" \/> <img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3200\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_10_image_0003\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_10_Image_0003.jpg\" data-orig-size=\"532,148\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_10_Image_0003\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_10_Image_0003.jpg\" class=\"alignnone size-full wp-image-3200 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_10_Image_0003.jpg\" alt=\"\" width=\"532\" height=\"148\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_10_Image_0003.jpg 532w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_10_Image_0003-300x83.jpg 300w\" sizes=\"auto, (max-width: 532px) 100vw, 532px\" \/><\/p>\n<p>Menos uma informa\u00e7\u00e3o que o DBA teria que conferir (mais produtividade).<\/p>\n<p>Al\u00e9m disso, mostramos as queries que possuem uma transa\u00e7\u00e3o aberta e est\u00e3o consumindo o log para que o DBA possa analisar e ir atr\u00e1s do respons\u00e1vel para saber se pode<br \/>\nmatar a conex\u00e3o ou n\u00e3o:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3210\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/top-10-log-usado-por-session-id\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-10-log-usado-por-session-id.png\" data-orig-size=\"897,708\" 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=\"top 10 log usado por session id\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-10-log-usado-por-session-id.png\" class=\"alignnone size-full wp-image-3210 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-10-log-usado-por-session-id.png\" alt=\"\" width=\"897\" height=\"708\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-10-log-usado-por-session-id.png 897w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-10-log-usado-por-session-id-300x237.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-10-log-usado-por-session-id-768x606.png 768w\" sizes=\"auto, (max-width: 897px) 100vw, 897px\" \/><\/p>\n<p>O DBA teria que achar nos scripts dele qual query mostra quem est\u00e1 consumindo mais log para depois rodar e descobrir. No Power Alerts j\u00e1 apareceu o insert que coloquei para encher o Log usando 3.8 GB de log.<\/p>\n<p>Ainda mostramos o que est\u00e1 rodando naquele momento com uma foto da whoisactive:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3211\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/top-20-processos-executados\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-20-processos-executados.png\" data-orig-size=\"892,840\" 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=\"top 20 processos executados\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-20-processos-executados.png\" class=\"alignnone size-full wp-image-3211 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-20-processos-executados.png\" alt=\"\" width=\"892\" height=\"840\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-20-processos-executados.png 892w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-20-processos-executados-300x283.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/top-20-processos-executados-768x723.png 768w\" sizes=\"auto, (max-width: 892px) 100vw, 892px\" \/><\/p>\n<p>Podemos ver novamente o insert enchendo o log.<\/p>\n<p>Para finalizar, ainda conseguimos ver o gr\u00e1fico de alertas por dia e por horas nos ajudando a identificar como est\u00e1 o hist\u00f3rico desse alerta.<\/p>\n<p>Se tenho muitos alertas por dia chegando, temos que tentar fazer algo para reduzir:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3195\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_12_image_0002\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_12_Image_0002.jpg\" data-orig-size=\"946,390\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_12_Image_0002\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_12_Image_0002.jpg\" class=\"alignnone size-full wp-image-3195 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_12_Image_0002.jpg\" alt=\"\" width=\"946\" height=\"390\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_12_Image_0002.jpg 946w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_12_Image_0002-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_12_Image_0002-768x317.jpg 768w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><\/p>\n<p>Tamb\u00e9m conseguimos identificar se tem algum hor\u00e1rio do dia que mais gera o alerta para ajudar a encontrar a rotina culpada:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3194\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_12_image_0003\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_12_Image_0003.jpg\" data-orig-size=\"946,394\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_12_Image_0003\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_12_Image_0003.jpg\" class=\"alignnone size-full wp-image-3194 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_12_Image_0003.jpg\" alt=\"\" width=\"946\" height=\"394\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_12_Image_0003.jpg 946w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_12_Image_0003-300x125.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_12_Image_0003-768x320.jpg 768w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><\/p>\n<p>No final do email tem a logo e nossa info de registro do alerta: Este \u00e9 um produto licenciado pela Power Tuning no INPI (Instituto Nacional da Propriedade Industrial), sob o n\u00famero 512022002100-5, e n\u00e3o pode ser compartilhado ou utilizado sem um contrato de compra ou autoriza\u00e7\u00e3o pr\u00e9via.<\/p>\n<h3><strong>4. Rotinas de DBA criadas<\/strong><\/h3>\n<p>Muito al\u00e9m dos gr\u00e1ficos bonitos, nosso sistema de alertas tamb\u00e9m cria mais de 25 rotinas que armazenam dados em tabelas e ajudam o DBA a monitorar e atuar com mais efici\u00eancia no ambiente. Essas rotinas s\u00e3o utilizadas pelo Power Alerts para envio dos e-mails e gr\u00e1ficos.<\/p>\n<p><strong>Rotinas de DBA que s\u00e3o criadas no ambiente (+25 rotinas):<\/strong><\/p>\n<ul>\n<li>Rotina para monitorar Deadlocks.<\/li>\n<li>Rotina para monitorar erros de Scripts que acontecem nas bases de dados.<\/li>\n<li>Rotina para monitorar os maiores waits do ambiente em um determinado intervalo de tempo.<\/li>\n<li>Rotina para monitorar se as estat\u00edsticas est\u00e3o atualizadas.<\/li>\n<li>Rotina para monitorar as queries que est\u00e3o usando o tempdb.<\/li>\n<li>Rotina para monitorar o crescimento do arquivo de dados do tempdb.<\/li>\n<li>Rotina para acompanhar o crescimento das tabelas e databases. Com isso, podemos prever o crescimento do ambiente e realizar novos investimentos somente quando necess\u00e1rio.<\/li>\n<li>Rotina para monitorar contadores do SQL Server.<\/li>\n<li>Rotina para monitorar as queries mais demoradas do ambiente.<\/li>\n<li>Rotina para monitorar o uso de mem\u00f3ria do ambiente.<\/li>\n<li>Rotina para monitorar as falhas de Logins.<\/li>\n<li>Rotina para monitorar o que est\u00e1 rodando no ambiente a cada um minuto (whoisactive).<\/li>\n<li>Rotina para monitorar o crescimento do Log das Databases.<\/li>\n<li>Rotina para monitorar o hist\u00f3rico de jobs.<\/li>\n<li>Rotina para monitorar a utiliza\u00e7\u00e3o dos \u00edndices do ambiente.<\/li>\n<li>Rotina para monitorar a fragmenta\u00e7\u00e3o dos \u00edndices.<\/li>\n<li>Rotina para monitorar se tem colunas Identity estourando.<\/li>\n<li>Rotina para monitorar a fila de I\/O pending no SQL Server.<\/li>\n<li>Rotina para monitorar o tempo de resposta e uso dos arquivos de dados e logs do SQL Server.<\/li>\n<li>Rotina para monitorar o Error Log do SQL Server.<\/li>\n<li>Rotina para monitorar o espa\u00e7o em disco.<\/li>\n<li>Rotina para monitorar o uso de CPU.<\/li>\n<li>Rotina para monitorar as queries que est\u00e3o usando mais CPU.<\/li>\n<li>Rotina para monitorar a execu\u00e7\u00e3o do CheckDB nas bases.<\/li>\n<li>Rotina para monitorar o hist\u00f3rico dos backups.<\/li>\n<li>Se tiver cluster, rotina para monitorar o status dos n\u00f3s do cluster.<\/li>\n<li>Se tiver Mirror, rotina para monitorar o status e performance do mirror.<\/li>\n<li>Se tiver AlwaysOn AG, rotina para monitorar o status e performance do AG.<\/li>\n<li>Rotina para deletar dados antigos de todos os logs criados.<\/li>\n<\/ul>\n<p>Estamos criando o Power Monitor que re\u00fane as informa\u00e7\u00f5es de todas essas rotinas e em breve estar\u00e1 dispon\u00edvel para uso de nossos clientes com Power Alerts:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3193\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_14_image_0002\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_14_Image_0002.jpg\" data-orig-size=\"946,528\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_14_Image_0002\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_14_Image_0002.jpg\" class=\"alignnone size-full wp-image-3193 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_14_Image_0002.jpg\" alt=\"\" width=\"946\" height=\"528\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_14_Image_0002.jpg 946w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_14_Image_0002-300x167.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_14_Image_0002-768x429.jpg 768w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><\/p>\n<p><em>*A implanta\u00e7\u00e3o do Power Monitor n\u00e3o est\u00e1 inclu\u00edda nessa proposta. Colocamos aqui para que possam ver como os logs que o Power Alerts gera s\u00e3o importantes e tamb\u00e9m o que podem ter ap\u00f3s implantar o Power Alerts.<\/em><\/p>\n<h3><strong><span style=\"background-color: transparent;\">5. Power Reports<\/span>\u00a0<\/strong><\/h3>\n<p>Al\u00e9m de melhorar muito o core dos alertas e incluir gr\u00e1ficos sensacionais, tamb\u00e9m criamos algumas procedures de relat\u00f3rios (Power Report) para ajudar na an\u00e1lise do ambiente no dia a dia.<\/p>\n<p>Basta passar seu e-mail e os par\u00e2metros de data inicial e final para obter a informa\u00e7\u00e3o desejada (quando for o caso).<\/p>\n<p>Exemplo real de uso do Power Reports:<\/p>\n<p>Queremos ver como foi a performance do ambiente entre 18h do dia 27\/11 e 18h do dia 28\/11.<\/p>\n<p>Ao inv\u00e9s do DBA entrar no ambiente, procurar v\u00e1rias queries e validar manualmente as informa\u00e7\u00f5es do que aconteceu naquele per\u00edodo, criamos uma procedure que ele passa o e-mail, a data de in\u00edcio e a data de fim e v\u00e1rios gr\u00e1ficos como os abaixo ser\u00e3o enviados para o e-mail dele.<\/p>\n<p>Com menos de 5 min, ele j\u00e1 tem muita informa\u00e7\u00e3o dispon\u00edvel para an\u00e1lise e de forma visual.<\/p>\n<p><em>EXEC stpPowerReport_SQL_Performance<\/em><br \/>\n<em>@Ds_Email= \u2019fabricio.lima@powertuning.com.br\u2019,@Dt_Start=\u201920221127 18:32\u2019,<\/em><br \/>\n<em>@Dt_End=\u201920221127 18:32\u2019,@Ds_Query = NULL<\/em><\/p>\n<p>O resultado da execu\u00e7\u00e3o dessa procedure gera todos os pr\u00f3ximos gr\u00e1ficos.<\/p>\n<p><strong>Gr\u00e1fico com informa\u00e7\u00f5es de CPU:<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3192\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_15_image_0002\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_15_Image_0002.jpg\" data-orig-size=\"944,389\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_15_Image_0002\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_15_Image_0002.jpg\" class=\"alignnone size-full wp-image-3192 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_15_Image_0002.jpg\" alt=\"\" width=\"944\" height=\"389\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_15_Image_0002.jpg 944w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_15_Image_0002-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_15_Image_0002-768x316.jpg 768w\" sizes=\"auto, (max-width: 944px) 100vw, 944px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Gr\u00e1fico com informa\u00e7\u00f5es do contador de mem\u00f3ria PLE:<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3191\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_16_image_0002\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0002.jpg\" data-orig-size=\"1192,491\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_16_Image_0002\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0002-1024x422.jpg\" class=\"size-large wp-image-3191 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0002-1024x422.jpg\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0002-1024x422.jpg 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0002-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0002-768x316.jpg 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0002.jpg 1192w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Gr\u00e1fico com informa\u00e7\u00f5es de conex\u00f5es no SQL Server:<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3190\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_16_image_0003\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0003.jpg\" data-orig-size=\"1326,548\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_16_Image_0003\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0003-1024x423.jpg\" class=\"size-large wp-image-3190 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0003-1024x423.jpg\" alt=\"\" width=\"1024\" height=\"423\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0003-1024x423.jpg 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0003-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0003-768x317.jpg 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0003.jpg 1326w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Gr\u00e1fico com a quantidade de queries na tabela com o Log da Whoisactive:<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3189\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_16_image_0004\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0004.jpg\" data-orig-size=\"1207,497\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_16_Image_0004\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0004-1024x422.jpg\" class=\"alignnone size-large wp-image-3189 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0004-1024x422.jpg\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0004-1024x422.jpg 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0004-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0004-768x316.jpg 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_16_Image_0004.jpg 1207w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Gr\u00e1fico com informa\u00e7\u00f5es de contador I\/O pendentes:<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3188\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_17_image_0002\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0002.jpg\" data-orig-size=\"1214,500\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_17_Image_0002\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0002-1024x422.jpg\" class=\"size-large wp-image-3188 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0002-1024x422.jpg\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0002-1024x422.jpg 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0002-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0002-768x316.jpg 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0002.jpg 1214w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Gr\u00e1fico com informa\u00e7\u00f5es de contador de mem\u00f3ria f\u00edsica dispon\u00edvel:<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3187\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_17_image_0003\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0003.jpg\" data-orig-size=\"1203,497\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_17_Image_0003\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0003-1024x423.jpg\" class=\"size-large wp-image-3187 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0003-1024x423.jpg\" alt=\"\" width=\"1024\" height=\"423\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0003-1024x423.jpg 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0003-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0003-768x317.jpg 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0003.jpg 1203w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Gr\u00e1fico com a quantidade de queries demorando mais de 3 segundos (e a m\u00e9dia delas):<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3186\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_17_image_0004\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0004.jpg\" data-orig-size=\"1181,486\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_17_Image_0004\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0004-1024x421.jpg\" class=\"size-large wp-image-3186 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0004-1024x421.jpg\" alt=\"\" width=\"1024\" height=\"421\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0004-1024x421.jpg 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0004-300x123.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0004-768x316.jpg 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_17_Image_0004.jpg 1181w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Gr\u00e1fico com informa\u00e7\u00f5es do crescimento do tempdb (dados):<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3185\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_18_image_0002\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0002.jpg\" data-orig-size=\"1129,448\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_18_Image_0002\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0002-1024x406.jpg\" class=\"size-large wp-image-3185 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0002-1024x406.jpg\" alt=\"\" width=\"1024\" height=\"406\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0002-1024x406.jpg 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0002-300x119.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0002-768x305.jpg 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0002.jpg 1129w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Gr\u00e1fico com informa\u00e7\u00f5es das queries mais demoradas:<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3184\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_18_image_0003\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0003.jpg\" data-orig-size=\"946,385\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_18_Image_0003\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0003.jpg\" class=\"size-full wp-image-3184 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0003.jpg\" alt=\"\" width=\"946\" height=\"385\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0003.jpg 946w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0003-300x122.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0003-768x313.jpg 768w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><\/strong><\/p>\n<p>*Ap\u00f3s esse chart vem parte do c\u00f3digo das queries no e-mail (Id Query). N\u00e3o mostramos aqui para economizar espa\u00e7o.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Gr\u00e1fico com informa\u00e7\u00f5es dos jobs mais demorados:<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3183\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_18_image_0004\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0004.jpg\" data-orig-size=\"946,390\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_18_Image_0004\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0004.jpg\" class=\"size-full wp-image-3183 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0004.jpg\" alt=\"\" width=\"946\" height=\"390\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0004.jpg 946w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0004-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_18_Image_0004-768x317.jpg 768w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><\/strong><\/p>\n<p>*Ap\u00f3s esse chart vem o nome dos Jobs no e-mail (Id Job). N\u00e3o mostramos aqui para economizar espa\u00e7o.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Gr\u00e1fico com informa\u00e7\u00f5es dos maiores waits do SQL Server:<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3182\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_19_image_0002\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0002.jpg\" data-orig-size=\"1251,513\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_19_Image_0002\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0002-1024x420.jpg\" class=\"alignnone size-large wp-image-3182 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0002-1024x420.jpg\" alt=\"\" width=\"1024\" height=\"420\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0002-1024x420.jpg 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0002-300x123.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0002-768x315.jpg 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0002.jpg 1251w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Aqui finaliza os gr\u00e1ficos que conseguimos enviar com apenas um F5 na procedure: <strong>stpPowerReport_SQL_Performance<\/strong><\/p>\n<p>Quanto tempo o DBA demoraria para levantar todas essas informa\u00e7\u00f5es?<\/p>\n<p>Mais uma vez damos produtividade e economia de horas do DBA ($).<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>Outros Power Reports que podem utilizar no dia a dia:<\/strong><\/p>\n<p>Report com o crescimento de uma base de dados:<\/p>\n<p><em><strong>EXEC [dbo].[stpPowerReport_Database_Size] @Nm_Database=@Database_Name,@Ds_Email=@email<\/strong><\/em><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3181\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_19_image_0003\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0003.jpg\" data-orig-size=\"1365,562\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_19_Image_0003\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0003-1024x422.jpg\" class=\"alignnone size-large wp-image-3181 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0003-1024x422.jpg\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0003-1024x422.jpg 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0003-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0003-768x316.jpg 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_19_Image_0003.jpg 1365w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/strong><\/p>\n<p>Report com o crescimento de uma tabela:<\/p>\n<p><em><strong>EXEC [dbo].[stpPowerReport_Table_Size] @Nm_Database=Nome_DB, @Nm_Table = Nome_Tabela, @Ds_Email = Seu_Email<\/strong><\/em><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3180\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_20_image_0002\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0002.jpg\" data-orig-size=\"1294,533\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_20_Image_0002\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0002-1024x422.jpg\" class=\"alignnone size-large wp-image-3180 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0002-1024x422.jpg\" alt=\"\" width=\"1024\" height=\"422\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0002-1024x422.jpg 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0002-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0002-768x316.jpg 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0002.jpg 1294w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/strong><\/p>\n<p>Report para acompanhar a fragmenta\u00e7\u00e3o dos \u00edndices atual do banco. Empresas de ERP pedem muito isso quando abrem chamado de lentid\u00e3o.<\/p>\n<p><em><strong>EXEC [dbo].[stpPowerReport_Index_Fragmentation] @Ds_Email = Seu_Email<\/strong><\/em><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3179\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_20_image_0003\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0003.jpg\" data-orig-size=\"945,390\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_20_Image_0003\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0003.jpg\" class=\"alignnone size-full wp-image-3179 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0003.jpg\" alt=\"\" width=\"945\" height=\"390\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0003.jpg 945w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0003-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_20_Image_0003-768x317.jpg 768w\" sizes=\"auto, (max-width: 945px) 100vw, 945px\" \/><\/strong><\/p>\n<p>Report para validar como est\u00e3o as estat\u00edsticas no ambiente. Na opini\u00e3o da Power Tuning, estat\u00edsticas atualizadas s\u00e3o muito mais importantes do que \u00edndices desfragmentados. Esse job tem que ser prioridade.<\/p>\n<p><em><strong>EXEC [dbo].[stpPowerReport_Update_Statistics] @Ds_Email = Seu_Email<\/strong><\/em><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3178\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/proposta-sistema-de-alertas-para-sql-server-power-alerts_page_21_image_0002\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_21_Image_0002.jpg\" data-orig-size=\"945,390\" 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=\"Proposta Sistema de Alertas para SQL Server &amp;#8211; Power Alerts_Page_21_Image_0002\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_21_Image_0002.jpg\" class=\"alignnone size-full wp-image-3178 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_21_Image_0002.jpg\" alt=\"\" width=\"945\" height=\"390\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_21_Image_0002.jpg 945w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_21_Image_0002-300x124.jpg 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/Proposta-Sistema-de-Alertas-para-SQL-Server-Power-Alerts_Page_21_Image_0002-768x317.jpg 768w\" sizes=\"auto, (max-width: 945px) 100vw, 945px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>6. Feedbacks de clientes<\/strong><\/h3>\n<p>Segue abaixo alguns prints de feedbacks de clientes que coletamos ao longo de nossas implanta\u00e7\u00f5es:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3230\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/4-8\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/4.png\" data-orig-size=\"866,1260\" 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=\"4\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/4-704x1024.png\" class=\"size-large wp-image-3230 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/4-704x1024.png\" alt=\"\" width=\"704\" height=\"1024\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/4-704x1024.png 704w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/4-206x300.png 206w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/4-768x1117.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/4-742x1080.png 742w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/4.png 866w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/> <img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3232\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/3-fabio\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/3-fabio.png\" data-orig-size=\"868,922\" 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=\"3 fabio\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/3-fabio.png\" class=\"wp-image-3232 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/3-fabio.png\" alt=\"\" width=\"714\" height=\"819\" \/> <img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3233\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/2-gustavo\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/2-gustavo.png\" data-orig-size=\"1053,695\" 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=\"2 gustavo\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/2-gustavo-1024x676.png\" class=\"wp-image-3233 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/2-gustavo-1024x676.png\" alt=\"\" width=\"711\" height=\"470\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/2-gustavo-1024x676.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/2-gustavo-300x198.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/2-gustavo-768x507.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/2-gustavo.png 1053w\" sizes=\"auto, (max-width: 711px) 100vw, 711px\" \/> <img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3234\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/1-guilherme\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/1-guilherme.png\" data-orig-size=\"1051,789\" 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=\"1 guilherme\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/1-guilherme-1024x769.png\" class=\"wp-image-3234 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/1-guilherme-1024x769.png\" alt=\"\" width=\"688\" height=\"517\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/1-guilherme-1024x769.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/1-guilherme-300x225.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/1-guilherme-768x577.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/1-guilherme.png 1051w\" sizes=\"auto, (max-width: 688px) 100vw, 688px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>7. Investimento Power Alerts<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3231\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/8-investimento\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/8-investimento.png\" data-orig-size=\"872,459\" 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=\"8 investimento\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/8-investimento.png\" class=\"size-full wp-image-3231 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/8-investimento.png\" alt=\"\" width=\"872\" height=\"459\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/8-investimento.png 872w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/8-investimento-300x158.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2024\/06\/8-investimento-768x404.png 768w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\" \/><\/p>\n<p><strong>Clientes que possuem suporte mensal com a Power Tuning:<\/strong><br \/>\n\u2022 Clientes que possuem contrato de monitoramento com a Power Tuning (onde n\u00f3s recebemos e-mail do ambiente) n\u00e3o pagam nada a mais no m\u00eas pelo Power Alerts.<\/p>\n<p>Tamb\u00e9m existe um custo \u00fanico de R$ 1.400,00 para o trabalho de instala\u00e7\u00e3o e configura\u00e7\u00e3o para a realidade do ambiente e monitoramento inicial. Esse valor \u00fanico n\u00e3o tem desconto pois s\u00e3o horas do DBA que ter\u00e3o que ser trabalhadas sempre.<\/p>\n<p>Esse \u00e9 um produto que continuar\u00e1 evoluindo ao longo do tempo e o cliente ter\u00e1 direito a todas as melhorias.<\/p>\n<p><strong>O que n\u00e3o est\u00e1 incluso nessa proposta:<\/strong><\/p>\n<ul>\n<li>Atua\u00e7\u00f5es de melhorias t\u00e9cnicas no ambiente ap\u00f3s a implanta\u00e7\u00e3o dos Alertas:\n<ul>\n<li><span style=\"background-color: transparent;\">Disco Cheio<\/span><\/li>\n<li>Log Full<\/li>\n<li>Base sem Backup<\/li>\n<li>Ambiente com Lentid\u00e3o<\/li>\n<li>Outros problemas comuns do dia a dia de DBA<\/li>\n<\/ul>\n<\/li>\n<li><span style=\"background-color: transparent;\">Implanta\u00e7\u00e3o de rotinas pesadas de Administra\u00e7\u00e3o:<\/span>\n<ul>\n<li>N\u00e3o ser\u00e3o implementadas rotinas de manuten\u00e7\u00e3o de \u00edndices, atualiza\u00e7\u00e3o de estat\u00edsticas e CheckDB no ambiente.<br \/>\nAjudar nessas atividades est\u00e1 no escopo do nosso outro modelo de proposta de DBA.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><strong>Quero contratar esse produto<\/strong><\/h3>\n<p>Ficou interessado no Power Alerts?<br \/>\nPreencha o formul\u00e1rio abaixo ou entre em contato com nosso time comercial pelo e-mail <strong>comercial@powertuning.com.br<\/strong><\/p>\n<p><script charset=\"utf-8\" type=\"text\/javascript\" src=\"\/\/js.hsforms.net\/forms\/embed\/v2.js\"><\/script><br \/>\n<script>\n  hbspt.forms.create({\n    portalId: \"48453815\",\n    formId: \"c77054f5-392c-47b1-a27a-ba80f602ce07\"\n  });\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; O objetivo desse trabalho \u00e9 realizar a implanta\u00e7\u00e3o do nosso sistema de alertas, o Power Alerts. 1. O que \u00e9 o Power Alerts? \u00c9 uma ferramenta de 62 mil linhas de c\u00f3digo em T-SQL (e crescendo) criada de DBA SQL Server para DBA SQL Server com dezenas de Alertas para monitorar seu banco de&hellip; <br \/> <a class=\"read-more\" href=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/\">Leia mais<\/a><\/p>\n","protected":false},"author":6,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"content-type":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"class_list":["post-1942","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/pages\/1942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/comments?post=1942"}],"version-history":[{"count":60,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/pages\/1942\/revisions"}],"predecessor-version":[{"id":4275,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/pages\/1942\/revisions\/4275"}],"wp:attachment":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/media?parent=1942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}