Welcome to Chi-SSUG!

Please click here for general group information.  Also follow us on twitter at @ChiSQL or our hashtag #ChiSQL.  We look forward to seeing you at our next meeting!

Topic:

 

Performance Tuning When You Can't Fix the Queries

Date:

 

Thursday, September 10th, 2015 @ 5:30 PM
(You must RSVP by 9:00 AM, the Wednesday prior to the meeting to attend)

Location:

 

Microsoft Technology Center, 200 East Randolph Drive, Suite 200 Chicago, IL 60601

Speaker:

 

Brent Ozar

Abstract:

 

Your users are frustrated because the app is too slow, but you can’t change the queries. Maybe it’s a third party app, or maybe you’re using generated code, or maybe you’re just not allowed to change it. Take heart – there’s still hope.

Brent Ozar does this every week, and he’ll share a one-hour cheat sheet to his proven methodologies to performance tune with indexes, SQL Server configuration switches, and hardware. You’ll learn how to capture your server’s bottlenecks with wait stats, and learn which wait stats can be fixed with indexing, hardware, and Enterprise Edition. 

 

Bio:

 

I love pushing SQL Server past the speed limit and showing other people how to drive it faster. I enjoy translating between programmers, sysadmins, SAN admins, and project managers. We find the root of the problem quickly, together, and get everyone working towards the same solutions.

For the best conversation in your life, ask me about:

  • Microsoft SQL Server performance tuning
  • Making kCura Relativity faster
  • VMware ESX/vSphere virtualization
  • Storage and SANs
  • Server hardware
  • How Tim Gunn can make it work

Sponsor:

 

 



Availability Groups versus Clustered Instances of SQL Server

Availability Groups versus Clustered Instances of SQL Server


Performance Tuning When You Can't Fix the Queries