Learn to diagnose & cure
your slow SQL Server
You know what’s worse than a slow SQL Server? Being covered in honey near a honey badger, that’s what. After that, you won’t care about queries that don’t finish, getting 15-second error warnings from your storage, or wondering where the bottleneck is.
If a little perspective didn’t help, Brent Ozar Unlimited has several straightforward solutions for slow SQL Servers:
Free downloads to make SQL Server faster
sp_Blitz® – get a SQL Server health check in under 60 seconds. This free stored procedure (also available as a Windows app) examines your server for the most common configuration, health, and performance problems, then gives you a prioritized list of things to fix.
sp_BlitzIndex® – not sure about whether your database has the right indexes? Pretty sure you’ve got the wrong ones? This free stored procedure gives you the answers in a fun, friendly mental health style. (You look like an Index Hoarder to me.)
SQL Server First Aid – e-books, videos, and collections of blog posts to help you learn more about SQL Server performance tuning.
Online performance tuning classes
How to Think Like the SQL Server Engine – 90 minutes, free – You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. Let’s fix that.
Virtualization, SANs, and Hardware for SQL Server – 5 hours – You’re the one who has to plan, buy, set up, and troubleshoot production SQL Servers. Microsoft Certified Master Brent Ozar will save you thousands of dollars on bad hardware decisions and wasted troubleshooting time.
How to Tune Indexes and Speed Up SQL Server – 6.5 hours, $299 – You want to become an expert at index tuning, but you can’t find a good start-to-finish training course. This is it – a six hour course packed with demos and quizzes from Microsoft Certified Master Kendra Little.
4-day Performance Tuning class
You need to make your SQL Server-driven app run faster. You’re a developer or DBA, and you’re facing performance issues that you can’t quite figure out. That’s about to change as you join Brent Ozar for a week of learning and fun. Read more.
Consulting: our SQL Critical Care®
In just 1-3 days, we’ll work with you to identify the root causes of your database pain points. Whether it’s slow storage, inefficient indexes, or queries that need a good spanking, we’ll show you exactly what’s causing the problem – and train you how to fix it. Learn more about our SQL Critical Care®.