Deprecated: implode(): Passing glue string after array is deprecated. Swap the parameters in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\util\crayon_util.class.php on line 73
protheus – Fabricio Lima | Consultoria e Treinamento SQL Server
Loading…

Melhorando a Performance de Consultas no Totvs Protheus – Parte 8


Deprecated: implode(): Passing glue string after array is deprecated. Swap the parameters in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\util\crayon_util.class.php on line 73

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Fala Pessoal, Estamos de volta com novos episódios da série de análise de queries de ambientes Totvs Protheus. Antes de lerem esse post, caso ainda não tenham lido os anteriores, sugiro que façam: https://www.fabriciolima.net/blog/2017/12/11/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-1/ https://www.fabriciolima.net/blog/2017/12/18/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-2/ https://www.fabriciolima.net/blog/2018/01/08/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-3/ https://www.fabriciolima.net/blog/2018/01/16/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-4/ https://www.fabriciolima.net/blog/2018/01/23/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-5/ https://www.fabriciolima.net/blog/2018/01/30/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-6/ https://www.fabriciolima.net/blog/2018/02/07/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-7/ No post de hoje vamos analisar esse pequeno monstro que estava demorando 4 minutos para […]

Melhorando a Performance de Consultas no Totvs Protheus – Parte 7


Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Fala pessoal, Como tudo que é bom dura, pouco, esse é o último episódio da nossa série de artigos de Tuning de consultas no Totvs Protheus. Lembrando que essas dicas valem para queries de outros sistemas também. Antes de lerem esse post, caso ainda não tenham lido os anteriores, sugiro que façam para seguirem a […]

Melhorando a Performance de Consultas no Totvs Protheus – Parte 6


Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Fala pessoal, Antes de lerem esse post, caso ainda não tenham lido os anteriores, sugiro que façam para seguirem a linha de raciocínio: https://www.fabriciolima.net/blog/2017/12/11/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-1/ https://www.fabriciolima.net/blog/2017/12/18/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-2/ https://www.fabriciolima.net/blog/2018/01/08/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-3/ https://www.fabriciolima.net/blog/2018/01/16/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-4/ https://www.fabriciolima.net/blog/2018/01/23/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-5/ Hoje vamos analisar a query abaixo que está fazendo um número muito alto de leituras no banco:

Segue o custo dessa query:

3 milhões de […]

Melhorando a Performance de Consultas no Totvs Protheus – Parte 5


Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Fala pessoal, Antes de lerem esse post, caso ainda não tenham lido os anteriores, sugiro que façam para seguirem a linha de raciocínio: https://www.fabriciolima.net/blog/2017/12/11/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-1/ https://www.fabriciolima.net/blog/2017/12/18/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-2/ https://www.fabriciolima.net/blog/2018/01/08/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-3/ https://www.fabriciolima.net/blog/2018/01/16/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-4/ Hoje vamos analisar a query abaixo que estava demorando 28 segundos em um cliente e foi executada mais de 100 vezes em um dia:

Plano:   Mais […]

Melhorando a Performance de Consultas no Totvs Protheus – Parte 4


Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Fala pessoal, Antes de lerem esse post, caso ainda não tenham lido os anteriores, sugiro que façam para seguirem a linha de raciocínio: https://www.fabriciolima.net/blog/2017/12/11/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-1/ https://www.fabriciolima.net/blog/2017/12/18/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-2/ https://www.fabriciolima.net/blog/2018/01/08/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-3/ Pegando mais uma query no Traces de queries demoradas. Essa query está demorando 18 segundos e fazendo um número absurdo de leituras na tabela SF2090. Query:

Leituras:

[…]

Melhorando a Performance de Consultas no Totvs Protheus – Parte 3


Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Fala pessoal, Antes de lerem esse post, caso ainda não tenham lido os anteriores, sugiro que façam para seguirem a linha de raciocínio: https://www.fabriciolima.net/blog/2017/12/11/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-1/ https://www.fabriciolima.net/blog/2017/12/18/melhorando-a-performance-de-consultas-no-totvs-protheus-parte-2/ Pegando mais uma quey no Traces de queries demoradas. Durante a semana, essa query apareceu várias vezes demorando mais de 3 segundos. Contudo, no fim de semana, ao rodar ela […]

Melhorando a Performance de Consultas no Totvs Protheus – Parte 2


Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Fala pessoal, Estamos aqui para o segundo post da nossa série que tem um episódio novo a cada semana. Antes de lerem esse post, sugiro verem o anterior para que sigam a sequência correta da série: Melhorando a Performance de Consultas no Totvs Protheus – Parte 1 Agora que já sabem do que se trata […]

Melhorando a Performance de Consultas no Totvs Protheus – Parte 1


Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 118

Notice: A non well formed numeric value encountered in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\crayon_formatter.class.php on line 119

Fala Pessoal, No meu dia a dia de Consultor SQL Server, atendo muitos clientes com Totvs Protheus e SQL Server. Inclusive já compartilhei algumas experiências com vocês aqui no Blog: 5 motivos para quem utiliza o Protheus (Totvs) contratar um DBA SQL Server Migrando um SQL Server 2008 Totvs Protheus para o SQL Server 2016 […]

Migrando um SQL Server 2008 Totvs Protheus para o SQL Server 2016 Standard

Fala Pessoal, Hoje vou compartilhar com vocês sobre uma migração que fiz em um cliente no início do mês. Cenário Antigo: Windows Server 2008 SQL Server 2008 R2 Standard Servidor único (migração para o mesmo Hardware) Novo Cenário: Windows Server 2012 R2 SQL Server 2016 Standard Edition Como não tínhamos um hardware em paralelo para […]

Tem SQL Server Standard na sua empresa? Hora de planejar a migração para o SQL Server 2016!!!

Olá Pessoal, Você certamente já deve ter visto a notícia bombástica que a microsoft liberou semana passada. Se não viu, segue um post com a notícia completa: https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/ Agora a versão Standard SP1 do SQL Server 2016 ganhou MUITAS funcionalidades que antes só funcionavam na versão Enterprise ($$$). Atendo clientes com versão Enterprise, mas a […]