4 Steps to Faster SQL Server Applications

Have slow SQL Server applications? We’ll show you a way to find and fix the worst offenders, and fast.

Course Summary

** Why take this course?**

Everyone tells you that SQL Server can be really fast. It’s used in tier-one organizations. So why are your SQL Server applications so slow?

Are they getting even slower when more data is added?

Do you know which queries to try to fix? Do you know how to fix them?

Chances are high that you have a basic indexing or repetitive query issue. In this short course, Greg will take you through an easy 4 step process to get back on track by fixing the most common issues.

Installing our free tools
Capturing what’s happening
Analyzing what happened
Fixing the worst offenders

In so many cases, doing just these four steps will let you fix the main problems, quickly - and without the need to buy expensive monitoring tools.

Enroll now for FREE !

Modules and Lessons

Module 0: Getting Started

Who is this course for?
Who is Greg ?
Why is indexing such a big issue?
Why are repetitive queries also such an issue?
Why do developers need to care about query performance more than ever?
What will I learn to do in this course?

Module 1: Get our free tools

What you need before you start
Introduction to SDU Tools
Downloading SDU Tools
Create a database and install SDU Tools

Module 2: Capture what’s happening

Introduction to capturing traces
Using SDU Tools to capture traces
Starting the capture at a later time
Working with traces captured elsewhere (or the sample trace)

Module 3: Analyze what’s going on

Normalized queries vs actual queries
Loading and normalizing a captured trace
Analyzing a loaded trace
Making sense of the numbers

Module 4: Fix the worst offenders

Finding how SQL Server executes a query
Finding and creating missing indexes
Indexes are an overhead
How many indexes are too many?
Rationalizing your indexes
Fixing repetitive queries

Module 5: Next steps

How do I learn more about indexing?

Enroll now for FREE !