{"id":8457,"date":"2026-05-27T14:24:13","date_gmt":"2026-05-27T17:24:13","guid":{"rendered":"https:\/\/powertuning.com.br\/blog\/?p=8457"},"modified":"2026-05-27T14:24:13","modified_gmt":"2026-05-27T17:24:13","slug":"protheus-lento-4-cases-reais-de-cliente-que-provam-o-caminho-mais-rapido-e-barato-e-o-banco-de-dados","status":"publish","type":"post","link":"https:\/\/powertuning.com.br\/blog\/protheus-lento-4-cases-reais-de-cliente-que-provam-o-caminho-mais-rapido-e-barato-e-o-banco-de-dados\/","title":{"rendered":"Protheus lento? 4 cases reais de cliente que provam: o caminho mais r\u00e1pido e barato \u00e9 o banco de dados"},"content":{"rendered":"<p><!-- ===== RESUMO: Otimiza&ccedil;&atilde;o de Banco de Dados Protheus (SQL Server) ===== --><\/p>\n<div style=\"max-width: 780px; margin: 0 auto; padding: 0 8px; box-sizing: border-box; font-family: Georgia, 'Times New Roman', serif; color: #1a1a2e; line-height: 1.8;\">\n<p><!-- HEADER \/ CAPA --><\/p>\n<div style=\"background: linear-gradient(135deg, #0D1B40 0%, #1a3a6b 50%, #2d5a9e 100%); border-radius: 16px; padding: 28px 24px; margin-bottom: 36px; position: relative; overflow: hidden;\">\n<div style=\"position: relative; z-index: 1;\">\n<div style=\"display: inline-block; background: rgba(255,215,61,0.15); border: 1px solid rgba(255,215,61,0.45); border-radius: 100px; padding: 6px 18px; margin-bottom: 20px;\"><span style=\"color: #ffd93d; font-size: 13px; font-family: Verdana,sans-serif; letter-spacing: 1.5px; text-transform: uppercase;\">\ud83c\udfa7 Resumo de Live<\/span><\/div>\n<h1 style=\"color: #ffffff; font-size: 26px; font-weight: bold; margin: 0 0 16px 0; line-height: 1.3;\">Otimiza\u00e7\u00e3o de Banco de Dados Protheus (SQL Server)<\/h1>\n<p style=\"color: #a8c4e6; font-size: 15px; margin: 0 0 20px 0; font-family: Verdana,sans-serif;\"><span style=\"font-weight: bold;\"><a style=\"color: #8bb8ff; text-decoration: none;\" href=\"https:\/\/www.linkedin.com\/in\/fabriciofrancalima\/\" target=\"_blank\" rel=\"noopener\">Fabr\u00edcio Lima<\/a><\/span> \u00a0\u00b7\u00a0 Abril 2026<\/p>\n<div style=\"display: inline-block; background: rgba(255,215,61,0.15); border: 1px solid rgba(255,215,61,0.3); border-radius: 10px; padding: 12px 22px;\"><span style=\"font-family: Verdana,sans-serif; font-size: 13px; color: #a8c4e6;\">Live original: <\/span><span style=\"font-family: Verdana,sans-serif; font-size: 22px; font-weight: bold; color: #ffd93d;\">1h 30min<\/span><span style=\"font-family: Verdana,sans-serif; font-size: 13px; color: #a8c4e6;\"> \u00a0\u00b7\u00a0 Leitura deste resumo: <\/span><span style=\"font-family: Verdana,sans-serif; font-size: 22px; font-weight: bold; color: #ffffff;\">10 min<\/span><\/div>\n<\/div>\n<\/div>\n<p><!-- APRESENTADOR --><\/p>\n<div style=\"background: #f9fafb; border: 1px solid #e8edf5; border-radius: 12px; padding: 18px 20px; margin-bottom: 28px;\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #999; text-transform: uppercase; letter-spacing: 1px;\">Apresentador<\/p>\n<p style=\"margin: 0; font-size: 16px;\"><strong style=\"color: #1a3a6b;\">Fabr\u00edcio Lima<\/strong> \u00a0\u00b7\u00a0 <a style=\"color: #2d5a9e; text-decoration: none; font-family: Verdana,sans-serif; font-size: 13px;\" href=\"https:\/\/www.linkedin.com\/in\/fabriciofrancalima\/\" target=\"_blank\" rel=\"noopener\">LinkedIn \u2197<\/a> \u00a0\u00b7\u00a0 <a style=\"color: #c0392b; text-decoration: none; font-family: Verdana,sans-serif; font-size: 13px;\" href=\"https:\/\/www.youtube.com\/@FabricioLimaNegociosDadosIA\" target=\"_blank\" rel=\"noopener\">YouTube \u2197<\/a><\/p>\n<\/div>\n<p><!-- INFO BOX --><\/p>\n<div style=\"background: #f0f4ff; border-left: 4px solid #2d5a9e; border-radius: 0 12px 12px 0; padding: 18px 20px; margin-bottom: 32px;\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 13px; color: #2d5a9e; font-weight: bold; text-transform: uppercase; letter-spacing: 1px;\">Sobre o que \u00e9<\/p>\n<p style=\"margin: 0; font-size: 17px; color: #1a1a2e;\">Uma live t\u00e9cnica sobre como resolver lentid\u00e3o no ERP Protheus atuando diretamente no banco de dados SQL Server. Cobre a arquitetura de \u00edndices, an\u00e1lise de queries reais, compress\u00e3o de dados (com redu\u00e7\u00f5es de 60% a 80%) e rotinas essenciais para o DBA manter o ambiente saud\u00e1vel.<\/p>\n<\/div>\n<p><!-- PRINCIPAIS INSIGHTS --><\/p>\n<div style=\"margin-bottom: 36px;\">\n<h2 style=\"font-size: 21px; color: #0d1b40; margin: 0 0 20px 0; padding-bottom: 12px; border-bottom: 2px solid #e8edf5;\">\ud83d\udca1 Principais Insights<\/h2>\n<div style=\"background: #ffffff; border: 1px solid #e8edf5; border-radius: 12px; padding: 24px; margin-bottom: 16px; box-shadow: 0 2px 8px rgba(0,0,0,0.04);\">\n<h3 style=\"margin: 0 0 8px 0; font-size: 18px; color: #1a3a6b;\">Banco de dados \u00e9 o caminho mais r\u00e1pido e barato<\/h3>\n<p style=\"margin: 0; font-size: 16px; color: #444;\">Quando o Protheus fica lento, as empresas geralmente tentam comprar mais hardware ou reescrever c\u00f3digo AdvPL. Ambos s\u00e3o caros e demorados. A atua\u00e7\u00e3o no banco de dados \u2014 principalmente cria\u00e7\u00e3o e otimiza\u00e7\u00e3o de \u00edndices \u2014 resolve lentid\u00f5es pontuais de forma r\u00e1pida, barata e eficiente.<\/p>\n<\/div>\n<div style=\"background: #ffffff; border: 1px solid #e8edf5; border-radius: 12px; padding: 24px; margin-bottom: 16px; box-shadow: 0 2px 8px rgba(0,0,0,0.04);\">\n<h3 style=\"margin: 0 0 8px 0; font-size: 18px; color: #1a3a6b;\">SELECT * \u00e9 o inimigo n\u00famero 1<\/h3>\n<p style=\"margin: 0; font-size: 16px; color: #444;\">Quando se solicita todas as colunas de uma tabela gigante, o SQL Server \u00e9 for\u00e7ado a fazer Key Lookup para cada linha. Com milhares de linhas, o otimizador desiste do \u00edndice e faz Table Scan \u2014 lendo a tabela toda. A li\u00e7\u00e3o: solicite apenas as colunas estritamente necess\u00e1rias.<\/p>\n<\/div>\n<div style=\"background: #ffffff; border: 1px solid #e8edf5; border-radius: 12px; padding: 24px; margin-bottom: 16px; box-shadow: 0 2px 8px rgba(0,0,0,0.04);\">\n<h3 style=\"margin: 0 0 8px 0; font-size: 18px; color: #1a3a6b;\">Compress\u00e3o: de 242GB para 50GB<\/h3>\n<p style=\"margin: 0; font-size: 16px; color: #444;\">O Protheus preenche colunas vazias com espa\u00e7os em branco em vez de NULL, desperdi\u00e7ando espa\u00e7o massivamente. A compress\u00e3o nativa do SQL Server elimina esses vazios, reduzindo bancos entre 60% e 80%. O benef\u00edcio vai al\u00e9m do disco: mais dados cabem na RAM, e leitura em mem\u00f3ria \u00e9 ordens de grandeza mais r\u00e1pida que em disco.<\/p>\n<\/div>\n<div style=\"background: #ffffff; border: 1px solid #e8edf5; border-radius: 12px; padding: 24px; margin-bottom: 16px; box-shadow: 0 2px 8px rgba(0,0,0,0.04);\">\n<h3 style=\"margin: 0 0 8px 0; font-size: 18px; color: #1a3a6b;\">\u00cdndices no JOIN, n\u00e3o s\u00f3 no WHERE<\/h3>\n<p style=\"margin: 0; font-size: 16px; color: #444;\">Ao juntar tabelas gigantes do Protheus (como SC5 e SC6), n\u00e3o basta ter \u00edndices nos filtros do WHERE. \u00c9 crucial garantir \u00edndices nas colunas de jun\u00e7\u00e3o (cl\u00e1usula ON\/JOIN), como Filial e N\u00famero do Pedido.<\/p>\n<\/div>\n<div style=\"background: #ffffff; border: 1px solid #e8edf5; border-radius: 12px; padding: 24px; margin-bottom: 16px; box-shadow: 0 2px 8px rgba(0,0,0,0.04);\">\n<h3 style=\"margin: 0 0 8px 0; font-size: 18px; color: #1a3a6b;\">Updates\/Deletes em massa: sempre em lotes<\/h3>\n<p style=\"margin: 0; font-size: 16px; color: #444;\">Nunca execute comandos que afetem milh\u00f5es de linhas de uma vez. Isso trava a tabela, expande o LDF descontroladamente e, se cancelado, o rollback pode levar horas. A pr\u00e1tica correta: fazer em lotes menores (loops).<\/p>\n<\/div>\n<div style=\"background: #ffffff; border: 1px solid #e8edf5; border-radius: 12px; padding: 24px; margin-bottom: 16px; box-shadow: 0 2px 8px rgba(0,0,0,0.04);\">\n<h3 style=\"margin: 0 0 8px 0; font-size: 18px; color: #1a3a6b;\">Power Alerts + Tuning: a dupla que resolve<\/h3>\n<p style=\"margin: 0; font-size: 16px; color: #444;\">Sem monitoramento voc\u00ea est\u00e1 no escuro \u2014 esperando o usu\u00e1rio reclamar. O Power Alerts identifica queries lentas, locks, sess\u00f5es sleeping e acompanha rotinas cr\u00edticas como custo m\u00e9dio, saldo cont\u00e1bil e faturamento. Power Alerts + Tuning de queries \u00e9 a solu\u00e7\u00e3o mais r\u00e1pida e barata para lentid\u00e3o no Protheus \u2014 muito melhor que comprar mais infra.<\/p>\n<\/div>\n<\/div>\n<p><!-- CITA&Ccedil;&Otilde;ES --><\/p>\n<div style=\"margin-bottom: 36px;\">\n<h2 style=\"font-size: 21px; color: #0d1b40; margin: 0 0 20px 0; padding-bottom: 12px; border-bottom: 2px solid #e8edf5;\">\ud83d\udcac Frases que Marcaram<\/h2>\n<div style=\"background: linear-gradient(135deg, #f8f6ff 0%, #f0f4ff 100%); border-left: 4px solid #2d5a9e; border-radius: 0 12px 12px 0; padding: 18px 20px; margin: 0 0 16px 0; font-style: italic; font-size: 18px; color: #1a1a2e;\">\u275d &#8220;SELECT * \u00e9 o inimigo n\u00famero um da performance.&#8221;<\/div>\n<div style=\"background: linear-gradient(135deg, #f8f6ff 0%, #f0f4ff 100%); border-left: 4px solid #2d5a9e; border-radius: 0 12px 12px 0; padding: 18px 20px; margin: 0 0 16px 0; font-style: italic; font-size: 18px; color: #1a1a2e;\">\u275d &#8220;Compress\u00e3o no Protheus \u00e9 mandat\u00f3ria. N\u00e3o \u00e9 opcional.&#8221;<\/div>\n<div style=\"background: linear-gradient(135deg, #f8f6ff 0%, #f0f4ff 100%); border-left: 4px solid #2d5a9e; border-radius: 0 12px 12px 0; padding: 18px 20px; margin: 0 0 16px 0; font-style: italic; font-size: 18px; color: #1a1a2e;\">\u275d &#8220;Atuar no banco de dados \u00e9 a forma mais r\u00e1pida, barata e eficiente de resolver lentid\u00e3o.&#8221;<\/div>\n<\/div>\n<p><!-- RESUMO DETALHADO --><\/p>\n<div style=\"margin-bottom: 36px;\">\n<h2 style=\"font-size: 21px; color: #0d1b40; margin: 0 0 20px 0; padding-bottom: 12px; border-bottom: 2px solid #e8edf5;\">\ud83d\udcd6 Resumo Detalhado<\/h2>\n<h3 style=\"font-size: 19px; color: #1a3a6b; margin: 28px 0 12px 0;\">O Problema da Lentid\u00e3o: 3 Caminhos<\/h3>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 16px 0;\">Quando o Protheus fica lento, as empresas tentam resolver de tr\u00eas formas diferentes. Cada uma com custo, prazo e efetividade muito distintos:<\/p>\n<table style=\"width: 100%; border-collapse: separate; border-spacing: 8px 0; margin: 0 0 16px 0;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr><!-- CAMINHO 1: HARDWARE --><\/p>\n<td style=\"background: #fff5f5; border: 2px solid #e8b4b4; border-radius: 12px; padding: 18px;\" valign=\"top\" width=\"33%\">\n<p style=\"margin: 0 0 6px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #c0392b; font-weight: bold; text-transform: uppercase; letter-spacing: 1px;\">Caminho 1<\/p>\n<p style=\"margin: 0 0 8px 0; font-size: 18px; font-weight: bold; color: #c0392b; font-family: Georgia,serif;\">\ud83d\udcca Hardware<\/p>\n<p style=\"margin: 0 0 10px 0; font-size: 13px; color: #888; font-family: Verdana,sans-serif;\">Mais CPU, mem\u00f3ria, SSD<\/p>\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #999; text-transform: uppercase; letter-spacing: 1px;\">Custo<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 14px; font-weight: bold; color: #c0392b;\">Alto<\/p>\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #999; text-transform: uppercase; letter-spacing: 1px;\">Prazo<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 14px; font-weight: bold; color: #c0392b;\">Semanas a meses<\/p>\n<p style=\"margin: 0; font-size: 13px; color: #555; font-family: Verdana,sans-serif; line-height: 1.5;\">\u26a0 Problema costuma voltar conforme o banco cresce<\/p>\n<\/td>\n<p><!-- CAMINHO 2: ADVPL --><\/p>\n<td style=\"background: #fffbf0; border: 2px solid #e6dcc0; border-radius: 12px; padding: 18px;\" valign=\"top\" width=\"33%\">\n<p style=\"margin: 0 0 6px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #8a7020; font-weight: bold; text-transform: uppercase; letter-spacing: 1px;\">Caminho 2<\/p>\n<p style=\"margin: 0 0 8px 0; font-size: 18px; font-weight: bold; color: #8a7020; font-family: Georgia,serif;\">\ud83d\udcdd AdvPL<\/p>\n<p style=\"margin: 0 0 10px 0; font-size: 13px; color: #888; font-family: Verdana,sans-serif;\">Reescrever c\u00f3digo do ERP<\/p>\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #999; text-transform: uppercase; letter-spacing: 1px;\">Custo<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 14px; font-weight: bold; color: #8a7020;\">M\u00e9dio-alto<\/p>\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #999; text-transform: uppercase; letter-spacing: 1px;\">Prazo<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 14px; font-weight: bold; color: #8a7020;\">Demorado<\/p>\n<p style=\"margin: 0; font-size: 13px; color: #555; font-family: Verdana,sans-serif; line-height: 1.5;\">\u26a0 Cria depend\u00eancia de terceiros<\/p>\n<\/td>\n<p><!-- CAMINHO 3: BANCO DE DADOS --><\/p>\n<td style=\"background: #f0fff0; border: 2px solid #2d6b2d; border-radius: 12px; padding: 18px; position: relative;\" valign=\"top\" width=\"33%\"><span style=\"position: absolute; top: -10px; right: 10px; background: #2d6b2d; color: #ffd93d; font-family: Verdana,sans-serif; font-size: 10px; font-weight: bold; padding: 3px 10px; border-radius: 100px; letter-spacing: 1px;\">\u2605 FOCO DA LIVE<\/span><\/p>\n<p style=\"margin: 0 0 6px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #2d6b2d; font-weight: bold; text-transform: uppercase; letter-spacing: 1px;\">Caminho 3<\/p>\n<p style=\"margin: 0 0 8px 0; font-size: 18px; font-weight: bold; color: #2d6b2d; font-family: Georgia,serif;\">\ud83d\udcbe Banco de Dados<\/p>\n<p style=\"margin: 0 0 10px 0; font-size: 13px; color: #888; font-family: Verdana,sans-serif;\">\u00cdndices, compress\u00e3o, queries<\/p>\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #999; text-transform: uppercase; letter-spacing: 1px;\">Custo<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 14px; font-weight: bold; color: #2d6b2d;\">Baixo<\/p>\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #999; text-transform: uppercase; letter-spacing: 1px;\">Prazo<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 14px; font-weight: bold; color: #2d6b2d;\">Minutos a horas<\/p>\n<p style=\"margin: 0; font-size: 13px; color: #555; font-family: Verdana,sans-serif; line-height: 1.5;\">\u2705 Resolve a causa, sem mexer no ERP<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 16px 0;\">A terceira via \u00e9 o foco da live: atuar no banco de dados \u00e9 a forma mais r\u00e1pida, barata e eficiente de resolver lentid\u00f5es pontuais \u2014 principalmente atrav\u00e9s da cria\u00e7\u00e3o e otimiza\u00e7\u00e3o de \u00edndices.<\/p>\n<h3 style=\"font-size: 19px; color: #1a3a6b; margin: 28px 0 12px 0;\">A Arquitetura e a M\u00e1gica dos \u00cdndices<\/h3>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 16px 0;\">O n\u00facleo da otimiza\u00e7\u00e3o reside no uso adequado de \u00edndices, divididos em duas categorias:<\/p>\n<div style=\"background: #f9fafb; border: 1px solid #e8edf5; border-radius: 12px; padding: 24px; margin: 0 0 12px 0;\">\n<p style=\"margin: 0 0 6px 0; font-size: 15px; font-family: Verdana,sans-serif; color: #2d5a9e; font-weight: bold;\">\u00cdndice Clustered (F\u00edsico)<\/p>\n<p style=\"margin: 0; font-size: 15px; color: #444;\">A pr\u00f3pria tabela organizada em formato de \u00e1rvore. No Protheus, \u00e9 sempre a coluna R_E_C_N_O_. S\u00f3 pode existir um por tabela \u2014 ele define a ordem f\u00edsica dos dados no disco.<\/p>\n<\/div>\n<div style=\"background: #f9fafb; border: 1px solid #e8edf5; border-radius: 12px; padding: 24px; margin: 0 0 16px 0;\">\n<p style=\"margin: 0 0 6px 0; font-size: 15px; font-family: Verdana,sans-serif; color: #2d5a9e; font-weight: bold;\">\u00cdndices Nonclustered (L\u00f3gicos)<\/p>\n<p style=\"margin: 0; font-size: 15px; color: #444;\">Estruturas de \u00e1rvore separadas para facilitar buscas por outras colunas (Nome, Data, Filial). O Protheus possui dezenas desses \u00edndices por tabela.<\/p>\n<\/div>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 16px 0;\">Tr\u00eas conceitos fundamentais de leitura:<\/p>\n<div style=\"background: #fff5f5; border: 1px solid #f0d0d0; border-radius: 12px; padding: 24px; margin: 0 0 12px 0;\">\n<p style=\"margin: 0 0 6px 0; font-size: 16px; color: #333;\"><strong style=\"color: #c0392b;\">\u26a0 Scan (pior cen\u00e1rio)<\/strong><\/p>\n<p style=\"margin: 0; font-size: 15px; color: #555;\">SQL l\u00ea a tabela inteira para encontrar um dado. Como ler um livro inteiro para achar uma palavra.<\/p>\n<\/div>\n<div style=\"background: #f0fff0; border: 1px solid #c4e6c4; border-radius: 12px; padding: 24px; margin: 0 0 12px 0;\">\n<p style=\"margin: 0 0 6px 0; font-size: 16px; color: #333;\"><strong style=\"color: #2d6b2d;\">\u2705 Seek (cen\u00e1rio ideal)<\/strong><\/p>\n<p style=\"margin: 0; font-size: 15px; color: #555;\">SQL vai direto ao ponto usando a \u00e1rvore do \u00edndice. M\u00e1xima performance.<\/p>\n<\/div>\n<div style=\"background: #fffbf0; border: 1px solid #e6dcc0; border-radius: 12px; padding: 24px; margin: 0 0 16px 0;\">\n<p style=\"margin: 0 0 6px 0; font-size: 16px; color: #333;\"><strong style=\"color: #8a7020;\">\u26a0 Key Lookup (intermedi\u00e1rio)<\/strong><\/p>\n<p style=\"margin: 0; font-size: 15px; color: #555;\">SQL encontra a linha pelo \u00edndice nonclustered, mas precisa &#8220;pular&#8221; para o clustered para buscar colunas adicionais n\u00e3o presentes no \u00edndice.<\/p>\n<\/div>\n<h3 style=\"font-size: 19px; color: #1a3a6b; margin: 28px 0 12px 0;\">O Perigo do SELECT *<\/h3>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 16px 0;\">Quando se solicita todas as colunas de uma tabela gigante, o SQL Server faz Key Lookup para cada linha encontrada. Com milhares de linhas, o otimizador percebe que milhares de lookups \u00e9 excessivo e decide ignorar o \u00edndice \u2014 optando por um Table Scan, que l\u00ea a tabela toda e degrada severamente a performance. <strong>Li\u00e7\u00e3o fundamental: solicite apenas as colunas estritamente necess\u00e1rias.<\/strong><\/p>\n<h3 style=\"font-size: 19px; color: #1a3a6b; margin: 28px 0 12px 0;\">\u00cdndices nos JOINs, N\u00e3o S\u00f3 no WHERE<\/h3>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 16px 0;\">Ao juntar tabelas gigantes do Protheus (como SC5 e SC6), n\u00e3o basta ter \u00edndices nos filtros do WHERE. \u00c9 crucial garantir \u00edndices nas colunas de jun\u00e7\u00e3o (cl\u00e1usula ON\/JOIN), como Filial e N\u00famero do Pedido. Sem esses \u00edndices, o SQL Server \u00e9 for\u00e7ado a fazer Scans em tabelas enormes.<\/p>\n<h3 style=\"font-size: 19px; color: #1a3a6b; margin: 28px 0 12px 0;\">Ordem das Colunas no \u00cdndice Composto<\/h3>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 16px 0;\">A ordem importa muito. A regra geral: a coluna mais seletiva (que filtra mais dados, como C\u00f3digo do Produto) deve vir antes de colunas menos seletivas (como Filial, que tem muitos valores repetidos).<\/p>\n<h3 style=\"font-size: 19px; color: #1a3a6b; margin: 28px 0 12px 0;\">Compress\u00e3o de Dados: O Segundo Trunfo<\/h3>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 16px 0;\">O Protheus preenche colunas vazias com espa\u00e7os em branco em vez de NULL \u2014 desperdi\u00e7ando espa\u00e7o massivamente. A compress\u00e3o nativa do SQL Server elimina esses vazios, com redu\u00e7\u00f5es reais entre 60% e 80%:<\/p>\n<div style=\"background: #f0fff0; border: 1px solid #c4e6c4; border-radius: 12px; padding: 24px; margin: 0 0 16px 0;\">\n<p style=\"margin: 0 0 8px 0; font-size: 15px; font-family: Verdana,sans-serif; color: #2d6b2d; font-weight: bold;\">Casos reais de compress\u00e3o:<\/p>\n<p style=\"font-size: 15px; color: #444; margin: 0 0 4px 0;\">\u25cf 242 GB \u2192 <strong>50 GB<\/strong> (redu\u00e7\u00e3o de 79%)<\/p>\n<p style=\"font-size: 15px; color: #444; margin: 0 0 0 0;\">\u25cf 565 GB \u2192 <strong>181 GB<\/strong> (redu\u00e7\u00e3o de 68%)<\/p>\n<\/div>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 16px 0;\">O benef\u00edcio vai al\u00e9m do disco: com o banco menor, muito mais dados cabem na RAM (Buffer Pool). Leitura em mem\u00f3ria \u00e9 ordens de grandeza mais r\u00e1pida que em disco \u2014 a performance geral d\u00e1 um salto gigantesco.<\/p>\n<h3 style=\"font-size: 19px; color: #1a3a6b; margin: 28px 0 12px 0;\">Rotinas Essenciais para o DBA<\/h3>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 12px 0;\"><strong>Queries Sleeping:<\/strong> Consultas que o sistema &#8220;esqueceu&#8221; abertas e que ficam segurando Locks (travando tabelas). Devem ser monitoradas e encerradas para evitar travamentos em cadeia.<\/p>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 12px 0;\"><strong>Updates\/Deletes em massa:<\/strong> Nunca execute comandos que afetem milh\u00f5es de linhas de uma vez. Isso trava a tabela, expande o LDF descontroladamente e, se cancelado, o rollback pode levar horas. Fa\u00e7a sempre em lotes (loops).<\/p>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 16px 0;\"><strong>Collation:<\/strong> No contexto do Protheus, a collation Latin1_General_BIN \u00e9 significativamente mais r\u00e1pida que as op\u00e7\u00f5es padr\u00e3o, pois o SQL n\u00e3o precisa validar acentua\u00e7\u00e3o e diferen\u00e7as entre mai\u00fasculas\/min\u00fasculas nas compara\u00e7\u00f5es de strings.<\/p>\n<h3 style=\"font-size: 19px; color: #1a3a6b; margin: 28px 0 12px 0;\">Monitoramento: Saia do Escuro com o Power Alerts<\/h3>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 16px 0;\">Tuning sem monitoramento \u00e9 tiro no escuro. Antes de otimizar qualquer coisa, voc\u00ea precisa <strong>enxergar<\/strong> o que est\u00e1 acontecendo no ambiente. O <strong>Power Alerts<\/strong> \u00e9 fundamental para ambientes Protheus porque entrega exatamente essa visibilidade:<\/p>\n<div style=\"background: #f0f4ff; border: 1px solid #d0daf0; border-radius: 12px; padding: 24px; margin: 0 0 12px 0;\">\n<p style=\"margin: 0 0 6px 0; font-size: 16px; color: #333;\"><strong style=\"color: #2d5a9e;\">\ud83d\udd0d Queries mais demoradas<\/strong><\/p>\n<p style=\"margin: 0; font-size: 15px; color: #555;\">Identifica automaticamente as consultas que mais consomem CPU, fazem mais leituras e as que mais se repetem. \u00c9 assim que voc\u00ea encontra as queries para otimizar.<\/p>\n<\/div>\n<div style=\"background: #f0f4ff; border: 1px solid #d0daf0; border-radius: 12px; padding: 24px; margin: 0 0 12px 0;\">\n<p style=\"margin: 0 0 6px 0; font-size: 16px; color: #333;\"><strong style=\"color: #2d5a9e;\">\ud83d\udd12 Locks e sess\u00f5es sleeping<\/strong><\/p>\n<p style=\"margin: 0; font-size: 15px; color: #555;\">Monitora travamentos em tempo real e identifica sess\u00f5es esquecidas abertas que est\u00e3o segurando locks desnecessariamente.<\/p>\n<\/div>\n<div style=\"background: #f0f4ff; border: 1px solid #d0daf0; border-radius: 12px; padding: 24px; margin: 0 0 12px 0;\">\n<p style=\"margin: 0 0 6px 0; font-size: 16px; color: #333;\"><strong style=\"color: #2d5a9e;\">\u2699 Rotinas cr\u00edticas do Protheus<\/strong><\/p>\n<p style=\"margin: 0; font-size: 15px; color: #555;\">Acompanha a performance de rotinas como custo m\u00e9dio, saldo cont\u00e1bil, faturamento e outras \u2014 alertando quando algo sai do padr\u00e3o.<\/p>\n<\/div>\n<div style=\"background: #0D1B40; border-radius: 12px; padding: 24px; margin: 0 0 16px 0;\">\n<p style=\"margin: 0; font-size: 16px; color: #ffffff; line-height: 1.7;\"><span style=\"font-weight: bold; color: #ffd93d;\">Power Alerts + Tuning de queries \u00e9 a solu\u00e7\u00e3o mais r\u00e1pida e barata para lentid\u00e3o em ambiente Protheus.<\/span> Muito melhor que comprar mais infraestrutura \u2014 e sem ficar no escuro esperando o usu\u00e1rio reclamar.<\/p>\n<\/div>\n<\/div>\n<p><!-- CASES REAIS --><\/p>\n<div style=\"margin-bottom: 36px;\">\n<h2 style=\"font-size: 21px; color: #0d1b40; margin: 0 0 20px 0; padding-bottom: 12px; border-bottom: 2px solid #e8edf5;\">\ud83d\udcc8 Cases Reais: O Poder de um \u00cdndice<\/h2>\n<p style=\"font-size: 16px; color: #333; margin: 0 0 20px 0;\">Pra ilustrar o impacto real dessas t\u00e9cnicas, separei 4 cases de clientes reais demonstrados na live. Em todos, a otimiza\u00e7\u00e3o levou minutos \u2014 o impacto, anos de tranquilidade pra equipe de TI.<\/p>\n<p><!-- ============================================================ --><br \/>\n<!-- CASE 1: CT2010 --><br \/>\n<!-- ============================================================ --><\/p>\n<div style=\"background: #f9fafb; border: 1px solid #e8edf5; border-radius: 12px; padding: 24px; margin-bottom: 20px;\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #999; text-transform: uppercase; letter-spacing: 1.5px; font-weight: bold;\">Case 1 \u00b7 CT2010 (48 milh\u00f5es de registros)<\/p>\n<h3 style=\"margin: 0 0 12px 0; font-size: 18px; color: #1a3a6b;\">O \u00edndice sugerido nem sempre \u00e9 o melhor<\/h3>\n<p style=\"font-size: 15px; color: #444; margin: 0 0 16px 0;\">Query filtrava por CT2_CREDIT. O SQL Server sugeriu um \u00edndice gigante com muitas colunas no INCLUDE \u2014 seria caro de manter numa tabela desse tamanho. A solu\u00e7\u00e3o: um \u00edndice menor, apenas pela coluna seletiva CT2_CREDIT (420MB, criado em 5 minutos).<\/p>\n<p><!-- Visual Antes\/Depois --><\/p>\n<table style=\"width: 100%; border-collapse: separate; border-spacing: 8px 0;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"background: #fff5f5; border: 2px solid #e8b4b4; border-radius: 12px; padding: 16px; text-align: center;\" valign=\"top\" width=\"50%\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #c0392b; font-weight: bold; text-transform: uppercase; letter-spacing: 1px;\">\u274c Antes<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 32px; font-weight: bold; color: #c0392b;\">5,7s<\/p>\n<p style=\"margin: 0; font-size: 13px; color: #888; font-family: Verdana,sans-serif;\">91.143 leituras \u00b7 CPU 10.531ms<\/p>\n<\/td>\n<td style=\"background: #f0fff0; border: 2px solid #8bc88b; border-radius: 12px; padding: 16px; text-align: center;\" valign=\"top\" width=\"50%\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #2d6b2d; font-weight: bold; text-transform: uppercase; letter-spacing: 1px;\">\u2705 Depois<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 32px; font-weight: bold; color: #2d6b2d;\">0,07s<\/p>\n<p style=\"margin: 0; font-size: 13px; color: #888; font-family: Verdana,sans-serif;\">4 leituras \u00b7 CPU 0ms<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"margin: 14px 0 0 0; font-size: 14px; color: #8a7020; font-family: Verdana,sans-serif;\"><strong>\ud83d\udca1 Li\u00e7\u00e3o:<\/strong> \u00edndice menor e mais seletivo pode ser melhor que o sugerido pelo SQL.<\/p>\n<\/div>\n<p><!-- ============================================================ --><br \/>\n<!-- CASE 2: SD2010 --><br \/>\n<!-- ============================================================ --><\/p>\n<div style=\"background: #f9fafb; border: 1px solid #e8edf5; border-radius: 12px; padding: 24px; margin-bottom: 20px;\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #999; text-transform: uppercase; letter-spacing: 1.5px; font-weight: bold;\">Case 2 \u00b7 SD2010 (86M de leituras no tempdb)<\/p>\n<h3 style=\"margin: 0 0 12px 0; font-size: 18px; color: #1a3a6b;\">6 subqueries id\u00eanticas + TempDB massivo<\/h3>\n<p style=\"font-size: 15px; color: #444; margin: 0 0 16px 0;\">Query com 6 subqueries id\u00eanticas no CASE e no WHERE, todas buscando na SD2010 sem \u00edndice por D2_COD. O operador Spool gerava 86 milh\u00f5es de leituras no tempdb. A solu\u00e7\u00e3o: 1 \u00fanico \u00edndice estrat\u00e9gico cobrindo o padr\u00e3o das subqueries.<\/p>\n<table style=\"width: 100%; border-collapse: separate; border-spacing: 8px 0;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"background: #fff5f5; border: 2px solid #e8b4b4; border-radius: 12px; padding: 16px; text-align: center;\" valign=\"top\" width=\"50%\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #c0392b; font-weight: bold; text-transform: uppercase; letter-spacing: 1px;\">\u274c Antes<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 32px; font-weight: bold; color: #c0392b;\">4m 05s<\/p>\n<p style=\"margin: 0; font-size: 13px; color: #888; font-family: Verdana,sans-serif;\">86M tempdb \u00b7 CPU 362s<\/p>\n<\/td>\n<td style=\"background: #f0fff0; border: 2px solid #8bc88b; border-radius: 12px; padding: 16px; text-align: center;\" valign=\"top\" width=\"50%\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #2d6b2d; font-weight: bold; text-transform: uppercase; letter-spacing: 1px;\">\u2705 Depois<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 32px; font-weight: bold; color: #2d6b2d;\">3s<\/p>\n<p style=\"margin: 0; font-size: 13px; color: #888; font-family: Verdana,sans-serif;\">4.504 tempdb \u00b7 CPU 12,6s<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"margin: 14px 0 0 0; font-size: 14px; color: #8a7020; font-family: Verdana,sans-serif;\"><strong>\ud83d\udca1 Li\u00e7\u00e3o:<\/strong> um \u00edndice bem posicionado resolve m\u00faltiplas subqueries de uma vez.<\/p>\n<\/div>\n<p><!-- ============================================================ --><br \/>\n<!-- CASE 3: SC5+SC6+SC9 --><br \/>\n<!-- ============================================================ --><\/p>\n<div style=\"background: #f9fafb; border: 1px solid #e8edf5; border-radius: 12px; padding: 24px; margin-bottom: 20px;\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #999; text-transform: uppercase; letter-spacing: 1.5px; font-weight: bold;\">Case 3 \u00b7 SC5 + SC6 + SC9 (Pedidos)<\/p>\n<h3 style=\"margin: 0 0 12px 0; font-size: 18px; color: #1a3a6b;\">481 milh\u00f5es de leituras + Locks travando o banco<\/h3>\n<p style=\"font-size: 15px; color: #444; margin: 0 0 16px 0;\">Query com m\u00faltiplos JOINs entre Pedidos (SC5), Itens (SC6) e Composi\u00e7\u00e3o (SC9). Realizava 481 milh\u00f5es de leituras na SC9 e \u2014 o pior \u2014 causava Locks que travavam outros processos do banco inteiro. Solu\u00e7\u00e3o &#8220;sniper&#8221;: 3 \u00edndices estrat\u00e9gicos focados nas colunas de filtro e JOIN.<\/p>\n<table style=\"width: 100%; border-collapse: separate; border-spacing: 8px 0;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"background: #fff5f5; border: 2px solid #e8b4b4; border-radius: 12px; padding: 16px; text-align: center;\" valign=\"top\" width=\"50%\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #c0392b; font-weight: bold; text-transform: uppercase; letter-spacing: 1px;\">\u274c Antes<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 32px; font-weight: bold; color: #c0392b;\">2m 40s<\/p>\n<p style=\"margin: 0; font-size: 13px; color: #888; font-family: Verdana,sans-serif;\">481M leituras \u00b7 CPU 1.183s<\/p>\n<\/td>\n<td style=\"background: #f0fff0; border: 2px solid #8bc88b; border-radius: 12px; padding: 16px; text-align: center;\" valign=\"top\" width=\"50%\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #2d6b2d; font-weight: bold; text-transform: uppercase; letter-spacing: 1px;\">\u2705 Depois<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 32px; font-weight: bold; color: #2d6b2d;\">4s<\/p>\n<p style=\"margin: 0; font-size: 13px; color: #888; font-family: Verdana,sans-serif;\">Locks eliminados<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"margin: 14px 0 0 0; font-size: 14px; color: #8a7020; font-family: Verdana,sans-serif;\"><strong>\ud83d\udca1 Li\u00e7\u00e3o:<\/strong> \u00edndices nos JOINs s\u00e3o t\u00e3o importantes quanto nos filtros WHERE.<\/p>\n<\/div>\n<p><!-- ============================================================ --><br \/>\n<!-- CASE 4: SCT3W0 SUBSTRING --><br \/>\n<!-- ============================================================ --><\/p>\n<div style=\"background: #f9fafb; border: 1px solid #e8edf5; border-radius: 12px; padding: 24px; margin-bottom: 20px;\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #999; text-transform: uppercase; letter-spacing: 1.5px; font-weight: bold;\">Case 4 \u00b7 SCT3W0 (15 minutos de execu\u00e7\u00e3o)<\/p>\n<h3 style=\"margin: 0 0 12px 0; font-size: 18px; color: #1a3a6b;\">SUBSTRING no WHERE mata o \u00edndice<\/h3>\n<p style=\"font-size: 15px; color: #444; margin: 0 0 16px 0;\">O filtro usava SUBSTRING(CT_DATA, 1, 6) = &#8216;202101&#8217;. Quando voc\u00ea aplica uma fun\u00e7\u00e3o numa coluna do WHERE, o SQL n\u00e3o consegue usar \u00edndice \u2014 precisa aplicar a fun\u00e7\u00e3o em CADA linha. Resultado: Table Scan completo. Solu\u00e7\u00e3o: reescrever o filtro sem fun\u00e7\u00e3o (CT_DATA &gt;= &#8216;20210101&#8217; AND CT_DATA &lt; &#8216;20210201&#8217;) + \u00edndice otimizado.<\/p>\n<table style=\"width: 100%; border-collapse: separate; border-spacing: 8px 0;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"background: #fff5f5; border: 2px solid #e8b4b4; border-radius: 12px; padding: 16px; text-align: center;\" valign=\"top\" width=\"50%\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #c0392b; font-weight: bold; text-transform: uppercase; letter-spacing: 1px;\">\u274c Antes<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 32px; font-weight: bold; color: #c0392b;\">15 min<\/p>\n<p style=\"margin: 0; font-size: 13px; color: #888; font-family: Verdana,sans-serif;\">Table Scan completo<\/p>\n<\/td>\n<td style=\"background: #f0fff0; border: 2px solid #8bc88b; border-radius: 12px; padding: 16px; text-align: center;\" valign=\"top\" width=\"50%\">\n<p style=\"margin: 0 0 4px 0; font-family: Verdana,sans-serif; font-size: 11px; color: #2d6b2d; font-weight: bold; text-transform: uppercase; letter-spacing: 1px;\">\u2705 Depois<\/p>\n<p style=\"margin: 0 0 8px 0; font-family: Verdana,sans-serif; font-size: 32px; font-weight: bold; color: #2d6b2d;\">segundos<\/p>\n<p style=\"margin: 0; font-size: 13px; color: #888; font-family: Verdana,sans-serif;\">Seek eficiente no \u00edndice<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"margin: 14px 0 0 0; font-size: 14px; color: #8a7020; font-family: Verdana,sans-serif;\"><strong>\ud83d\udca1 Li\u00e7\u00e3o:<\/strong> NUNCA use fun\u00e7\u00f5es em colunas do WHERE. Reescreva o filtro.<\/p>\n<\/div>\n<p><!-- CTA pro post completo de 10 cases --><\/p>\n<div style=\"background: #fffbf0; border: 1px solid #e6dcc0; border-radius: 12px; padding: 20px; margin-bottom: 16px;\">\n<p style=\"margin: 0; font-size: 15px; color: #555;\"><strong style=\"color: #8a7020;\">\ud83d\udd17 Quer ver mais?<\/strong> Estes 4 s\u00e3o uma amostra. <a style=\"color: #2d5a9e; font-weight: bold;\" href=\"https:\/\/www.fabriciolima.net\/blog\" target=\"_blank\" rel=\"noopener\">Veja o post completo com 10 cases reais de melhoria de performance no Protheus \u2192<\/a><\/p>\n<\/div>\n<\/div>\n<p><!-- PARA QUEM --><\/p>\n<div style=\"background: linear-gradient(135deg, #0D1B40 0%, #1a3a6b 100%); border-radius: 12px; padding: 22px; margin-bottom: 36px;\">\n<h2 style=\"font-size: 20px; color: #ffffff; margin: 0 0 16px 0;\">\ud83c\udfaf Pra quem \u00e9 essa live?<\/h2>\n<p style=\"font-size: 16px; color: #c4d6ef; margin: 0; line-height: 1.8;\">DBAs que administram ambientes Protheus e precisam melhorar performance. Analistas de infraestrutura que recebem chamados de lentid\u00e3o do ERP. Desenvolvedores AdvPL que querem entender como o banco processa suas queries. E gestores de TI avaliando se devem investir em hardware ou em otimiza\u00e7\u00e3o.<\/p>\n<\/div>\n<p><!-- TAKEAWAYS --><\/p>\n<div style=\"background: #f8faf8; border: 1px solid #d4e6d4; border-radius: 12px; padding: 22px; margin-bottom: 36px;\">\n<h2 style=\"font-size: 20px; color: #2d6b2d; margin: 0 0 20px 0;\">\u2705 Takeaways R\u00e1pidos<\/h2>\n<div style=\"font-size: 15px; color: #333; font-family: Verdana,sans-serif; line-height: 2.2;\">\u2713 Evite SELECT * \u2014 \u00e9 o inimigo #1 da performance<br \/>\n\u2713 Crie \u00edndices nos JOINs, n\u00e3o s\u00f3 nos filtros WHERE<br \/>\n\u2713 Coluna mais seletiva primeiro no \u00edndice composto<br \/>\n\u2713 Compress\u00e3o de dados no Protheus \u00e9 mandat\u00f3ria<br \/>\n\u2713 Monitore e encerre Queries Sleeping<br \/>\n\u2713 Deletes\/Updates em massa: sempre em lotes (loops)<br \/>\n\u2713 Use collation Latin1_General_BIN para Protheus<br \/>\n\u2713 <strong>Power Alerts + Tuning = solu\u00e7\u00e3o mais r\u00e1pida e barata<\/strong><br \/>\n\u2713 Otimize o banco antes de comprar mais hardware<\/div>\n<\/div>\n<p><!-- LINK ORIGINAL --><\/p>\n<div style=\"text-align: center; margin-bottom: 40px;\"><a style=\"display: inline-block; background: #2d5a9e; color: #ffffff; text-decoration: none; padding: 14px 36px; border-radius: 100px; font-family: Verdana,sans-serif; font-size: 15px; font-weight: bold; letter-spacing: 0.5px;\" href=\"https:\/\/www.youtube.com\/watch?v=T5eh5ORMT2A\" target=\"_blank\" rel=\"noopener\">\u25b6\u00a0 Assistir \u00e0 Live Completa<\/a><\/div>\n<p><!-- RODAP&Eacute; --><\/p>\n<div style=\"text-align: center; padding: 24px 0; border-top: 1px solid #e8edf5;\">\n<p style=\"font-size: 13px; color: #999; font-family: Verdana,sans-serif; margin: 0;\">Resumo por <strong style=\"color: #0d1b40;\">Power Tuning<\/strong> \u00a0\u00b7\u00a0 <a style=\"color: #2d5a9e; text-decoration: none;\" href=\"https:\/\/www.powertuning.com.br\">powertuning.com.br<\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\ud83c\udfa7 Resumo de Live Otimiza\u00e7\u00e3o de Banco de Dados Protheus (SQL Server) Fabr\u00edcio Lima \u00a0\u00b7\u00a0 Abril 2026 Live original: 1h 30min \u00a0\u00b7\u00a0 Leitura deste resumo: 10 min Apresentador Fabr\u00edcio Lima \u00a0\u00b7\u00a0 LinkedIn \u2197 \u00a0\u00b7\u00a0 YouTube \u2197 Sobre o que \u00e9 Uma live t\u00e9cnica sobre como resolver lentid\u00e3o no ERP Protheus atuando diretamente no banco de&hellip; <br \/> <a class=\"read-more\" href=\"https:\/\/powertuning.com.br\/blog\/protheus-lento-4-cases-reais-de-cliente-que-provam-o-caminho-mais-rapido-e-barato-e-o-banco-de-dados\/\">Leia mais<\/a><\/p>\n","protected":false},"author":6,"featured_media":8523,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[176,62,59,138,63],"tags":[890,873,887,881,879,880,889,888,547,876,875,877,189,884,208,188,141,22,185,872,885,886,882,35,883,878,521,187,874],"class_list":["post-8457","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-banco-de-dados","category-casos-reais-de-clientes","category-tuning","category-power-alerts","category-sql-server","tag-advpl","tag-banco-de-dados-protheus","tag-cases-reais-protheus","tag-collation-latin1_general_bin","tag-compressao-sql-server","tag-data-compression","tag-dba-protheus","tag-erp-totvs","tag-fabricio-lima","tag-index-seek","tag-indices-sql-server","tag-key-lookup","tag-lentidao-protheus","tag-locks-sql-server","tag-otimizacao-protheus","tag-performance-protheus","tag-power-alerts","tag-power-tuning","tag-protheus","tag-protheus-tuning","tag-queries-sleeping","tag-r_e_c_n_o_","tag-select","tag-sql-server","tag-substring-where","tag-table-scan","tag-tempdb","tag-totvs-protheus","tag-tuning-sql-server"],"jetpack_featured_media_url":"https:\/\/powertuning.com.br\/blog\/wp-content\/uploads\/2026\/04\/Capa_Blog.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts\/8457","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=8457"}],"version-history":[{"count":3,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts\/8457\/revisions"}],"predecessor-version":[{"id":8524,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/posts\/8457\/revisions\/8524"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/media\/8523"}],"wp:attachment":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/media?parent=8457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/categories?post=8457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/tags?post=8457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}