{"id":2608,"date":"2023-07-19T17:43:14","date_gmt":"2023-07-19T20:43:14","guid":{"rendered":"https:\/\/powertuning.com.br\/?p=2608"},"modified":"2023-07-22T08:48:58","modified_gmt":"2023-07-22T11:48:58","slug":"power-alerts-now-supports-amazon-rds-for-sql-server","status":"publish","type":"post","link":"https:\/\/powertuning.com.br\/blog\/power-alerts-now-supports-amazon-rds-for-sql-server\/","title":{"rendered":"Power Alerts now supports Amazon RDS for SQL Server"},"content":{"rendered":"<p>Fala Pessoal,<\/p>\n<p>Essa dica \u00e9 para voc\u00ea que tem seu ambiente <strong>SQL Server<\/strong> no <strong>RDS<\/strong> da Amazon.<\/p>\n<p>O <strong>Power Alerts<\/strong> j\u00e1 est\u00e1 em produ\u00e7\u00e3o em clientes da Power Tuning monitorando SQL Server no RDS.<\/p>\n<h3><strong>Cliente: Porque ter o Power Alerts no RDS?<\/strong><\/h3>\n<p>R: Para ter um monitoramento muito mais completo do SQL Server, identificar mais f\u00e1cil os gargalos, melhorar a performance e reduzir custos no RDS (reduzindo m\u00e1quina ou crescendo m\u00e1quina de forma mais devagar ao longo do tempo).<\/p>\n<p>No Power Alerts temos:<\/p>\n<ul>\n<li>Dezenas de alertas espec\u00edficos do SQL Server que voc\u00ea n\u00e3o vai encontrar no portal do RDS.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"2004\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/lista-power-alerta\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/Lista-Power-Alerta.png\" data-orig-size=\"1000,571\" 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=\"Lista-Power-Alerta\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/Lista-Power-Alerta.png\" class=\" wp-image-2004 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/Lista-Power-Alerta-300x171.png\" alt=\"\" width=\"708\" height=\"403\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/Lista-Power-Alerta-300x171.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/Lista-Power-Alerta.png 1000w\" sizes=\"auto, (max-width: 708px) 100vw, 708px\" \/><\/p>\n<ul>\n<li>Os Alertas j\u00e1 vem com informa\u00e7\u00f5es que o DBA teria que logar no SQL Server para ver. Isso aumenta a produtividade dele e a agilidade na atua\u00e7\u00e3o dos problemas. Al\u00e9m disso, temos gr\u00e1ficos nos e-mails de alertas.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1951\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/attachment\/31\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/31.png\" data-orig-size=\"603,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=\"31\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/31.png\" class=\" wp-image-1951 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/31-300x255.png\" alt=\"\" width=\"524\" height=\"445\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/31-300x255.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/31.png 603w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><\/p>\n<ul>\n<li>+25 rotinas criadas no SQL Server para monitorar e logar informa\u00e7\u00f5es que voc\u00ea vai precisar ter quando acontecer uma lentid\u00e3o no seu ambiente e a diretoria pedir explica\u00e7\u00e3o do motivo:\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"list-style-type: none;\">\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<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>Caso use Power Bi na sua empresa, ainda pode ter esse Dash que nosso time de BI fez:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"2517\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/9-anos-de-power-tuning-nosso-escopo-aumentou-e-agora-podemos-ajudar-muito-mais-empresas\/power-monitor-cliente\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/07\/power-monitor-cliente.png\" data-orig-size=\"1536,857\" 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=\"power monitor cliente\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/07\/power-monitor-cliente-1024x571.png\" class=\" wp-image-2517 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/07\/power-monitor-cliente-300x167.png\" alt=\"\" width=\"867\" height=\"482\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/07\/power-monitor-cliente-300x167.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/07\/power-monitor-cliente-1024x571.png 1024w\" sizes=\"auto, (max-width: 867px) 100vw, 867px\" \/><\/p>\n<ul>\n<li>Ter\u00e1 procedures que chamamos de Power Reports para gerar gr\u00e1ficos e ajudar a an\u00e1lise de lentid\u00e3o pela pessoa respons\u00e1vel por monitorar o SQL Server.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1979\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/attachment\/50\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/50.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=\"50\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/50-1024x422.png\" class=\" wp-image-1979 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/50-300x124.png\" alt=\"\" width=\"571\" height=\"236\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/50-300x124.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/50-1024x422.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/50-768x316.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/50-1536x632.png 1536w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/50.png 1700w\" sizes=\"auto, (max-width: 571px) 100vw, 571px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1983\" data-permalink=\"https:\/\/powertuning.com.br\/blog\/poweralerts\/attachment\/54\/\" data-orig-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/54.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=\"54\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/54-1024x422.png\" class=\" wp-image-1983 aligncenter\" src=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/54-300x124.png\" alt=\"\" width=\"544\" height=\"225\" srcset=\"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/54-300x124.png 300w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/54-1024x422.png 1024w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/54-768x316.png 768w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/54-1536x632.png 1536w, https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/03\/54.png 1700w\" sizes=\"auto, (max-width: 544px) 100vw, 544px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Cliente: Gostei. Pode me dar mais informa\u00e7\u00f5es do Power Alerts?<\/strong><\/h3>\n<p>R: Nesse link tem todas as informa\u00e7\u00f5es, inclusive com o valor do investimento para ter o Power Alerts: <a href=\"https:\/\/powertuning.com.br\/poweralerts\/\" target=\"_blank\" rel=\"noopener\">P\u00e1gina Power Alerts<\/a><\/p>\n<p>Segue tamb\u00e9m alguns v\u00eddeos que gravamos para conhecerem o poder do Power Alerts:<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong>Compara\u00e7\u00e3o r\u00e1pida com os alertas antigos:<\/strong> <a href=\"https:\/\/www.youtube.com\/watch?v=go7yt68LYNE&amp;list=PLZZcZLEIKFuKh66-2DM4UzNzwwyJzdcij&amp;index=12\" target=\"_blank\" rel=\"noopener\">https:\/\/www.youtube.com\/watch?v=go7yt68LYNE&amp;list=PLZZcZLEIKFuKh66-2DM4UzNzwwyJzdcij&amp;index=12<\/a><\/li>\n<li><strong>Power Reports:<\/strong> <a href=\"https:\/\/www.youtube.com\/watch?v=-49lQP0SLXI&amp;t=4s\" target=\"_blank\" rel=\"noopener\">https:\/\/www.youtube.com\/watch?v=-49lQP0SLXI&amp;t=4s<\/a><\/li>\n<li><strong>Power Monitor:<\/strong> <a href=\"https:\/\/www.youtube.com\/watch?v=3-e-_mkKr3k&amp;list=PLZZcZLEIKFuKh66-2DM4UzNzwwyJzdcij&amp;index=13\" target=\"_blank\" rel=\"noopener\">https:\/\/www.youtube.com\/watch?v=3-e-_mkKr3k&amp;list=PLZZcZLEIKFuKh66-2DM4UzNzwwyJzdcij&amp;index=13<\/a><\/li>\n<li><strong>V\u00eddeo completo sobre o Power Alerts:<\/strong> <a href=\"https:\/\/www.youtube.com\/watch?v=hZ3TCH4dgCg&amp;list=PLZZcZLEIKFuKh66-2DM4UzNzwwyJzdcij&amp;index=9\" target=\"_blank\" rel=\"noopener\">https:\/\/www.youtube.com\/watch?v=hZ3TCH4dgCg&amp;list=PLZZcZLEIKFuKh66-2DM4UzNzwwyJzdcij&amp;index=9<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Ficou interessado no Power Alerts?<\/p>\n<p>Entre em contato com nosso time comercial pelo e-mail <strong>comercial@powertuning.com.br<\/strong><\/p>\n<p>Tamb\u00e9m podemos agendar uma call para tirar suas d\u00favidas.<\/p>\n<p><strong>Fabr\u00edcio Lima,<\/strong><\/p>\n<p><strong>CEO Power Tuning<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fala Pessoal, Essa dica \u00e9 para voc\u00ea que tem seu ambiente SQL Server no RDS da Amazon. O Power Alerts j\u00e1 est\u00e1 em produ\u00e7\u00e3o em clientes da Power Tuning monitorando SQL Server no RDS. Cliente: Porque ter o Power Alerts no RDS? R: Para ter um monitoramento muito mais completo do SQL Server, identificar mais&hellip; <br \/> <a class=\"read-more\" href=\"https:\/\/powertuning.com.br\/blog\/power-alerts-now-supports-amazon-rds-for-sql-server\/\">Leia mais<\/a><\/p>\n","protected":false},"author":6,"featured_media":2631,"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":[138,63],"tags":[142,146,139,143,140,147,141,144,145],"class_list":["post-2608","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-alerts","category-sql-server","tag-alertas-sql-server","tag-amazon-rds","tag-monitoramento","tag-monitoramento-rds","tag-monitoramento-sql-server","tag-performance-rds","tag-power-alerts","tag-rds","tag-rds-for-sql-server"],"jetpack_featured_media_url":"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2023\/07\/MicrosoftTeams-image-38.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts\/2608","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/comments?post=2608"}],"version-history":[{"count":19,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts\/2608\/revisions"}],"predecessor-version":[{"id":2646,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts\/2608\/revisions\/2646"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/media\/2631"}],"wp:attachment":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/media?parent=2608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/categories?post=2608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/tags?post=2608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}