SQL Server Performance Tuning Precon

Published On: 2020-01-27By:

On April 3rd, 2020 I’ll be presenting a Precon at SQL Saturday Croatia.

In this session, you will learn about SQL Server 2008 R2 through SQL Server 2017 performance tuning and optimization. Industry Expert Denny Cherry will guide you through tools and best practices for tuning queries and improving performance within Microsoft SQL Server. This session will guide you through real-life performance problems that have been gathered and tuned using industry-standard best practices and real-world skills.

This session starts off with reviewing the various native tools which are available to you from Microsoft with your SQL Server License and how all of these tools can be used to help you performance tune your SQL Server installation. These tools include SQL Profiler, Extended Events, Database Tuning Advisor and more. We will use these tools to identify problem areas within the SQL Server database engine and how to solve these problems.

We will discuss some scale-out options which are available with Microsoft SQL Server both within the database by using table partitioning to spread the workload to multiple disks, as well as AlwaysOn Availability Groups and how they can be used to scale a database out across multiple servers.

Registering

In order to register for the precon click over to the registration page, fill out the form and away you go; and I’ll see you on April 3rd.

Denny

The post SQL Server Performance Tuning Precon appeared first on SQL Server with Mr. Denny.

Contact the Author | Contact DCAC

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner    Microsoft MVP    Microsoft Certified Master    VMWare vExpert
   Best Full-Service Cloud Technology Consulting Company    Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers
Share via
Copy link