$175

Performance Tuning with Waits and Queues: a Full Day of Waits

Event Information

Share this event

Date and Time

Location

Location

Benedictine University & College

5700 College Rd

Lisle, IL 60532

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

“The database is slow!” Now what?

Start with a simple proposition: a process is either working or waiting. You can tune the working part, but are you seeing the whole picture? Your process could be waiting on many different things – a lock, memory, disk, CPU, and much more. When a process waits, SQL Server logs it. There are hundreds of wait types, and they’re a gold mine for finding and solving problems. If you’re not using this approach, then you’re flying blind. If you’ve looked at Activity Monitor and seen all those crazy codes like CXPACKET, PAGEIOLATCH_SH, LCK_M_IX, ASYNC_NETWORK_IO, WRITELOG, SLEEP_BPOOL_FLUSH, and wondered what they mean and what to do with that info, then this seminar is for you. Those cryptic codes are the key to solving performance issues with the least effort - quickly find not just what is slow, but why it is slow.

These techniques work on any size database, physical or virtual, on-prem or in the cloud.

Join Microsoft Certified Master Eddie Wuerch as he reveals the simple but critical techniques experts use to troubleshoot and tune SQL Server systems and workloads of every size. Stop guessing, start knowing!

Course Hardware and Software Requirements

Included with the seminar are a collection of tuning and monitoring scripts and a printed copy of the day’s content. Attendees will not need to bring laptops, but are encouraged to do so they may try some of the techniques as they are presented. Many attendees connect to their production systems during lunch and are amazed at what they can see after just half a day of class. Although most scripts, topics, and other content are applicable to SQL Server 2005 and up, some new SQL 2012/2014/2016 features will be covered. Differences in SQL versions as it applies to the material will be highlighted during the day.
Course does not apply to the Azure SQL DB service, but it does apply to Azure VMs (IaaS) running SQL Server.

Eddie Wuerch

With 20 years as a SQL Server specialist in a much-longer IT career, Microsoft Certified Master Eddie Wuerch spends his days at the Salesforce Marketing Cloud focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24×7 continuously-available online system accessed by millions worldwide every day.

Don't forget to visit http://www.sqlsaturday.com/719/eventhome.aspx for details about SQLSaturday Chicago!

Share with friends

Date and Time

Location

Benedictine University & College

5700 College Rd

Lisle, IL 60532

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved