SQL Server Critical Care™:
Currently Accepting New Patients*
Our SQL Server Critical Care™ is the first step of resolution for any of the problems we solve. After three days with the Brent Ozar Unlimited team, you will have:
- a full analysis of your system
- performance baselines
- an action plan
- a set of techniques to measure and improve database performance
- a renewed fascination with dinosaurs
We’ve worked on hundreds of servers and our goal is to pass along our expertise and experience. We’ll show you how to cut costs by database and server consolidation, and we’ll identify new opportunities for improvement.
SQL Server Critical Care™: emergency treatment and preventative care combined. No shots. Possible dinosaur references. Contact us to sign up.
Related articles on SQL performance checks:
- Using Perfmon with SQL Server – Brent explains how to use this free tool to analyze hardware and database bottlenecks.
- SQL Server Problems with Power-Saving CPUs – right now, some of the servers in your datacenter are probably running at half speed – or less.
- Critical Care from a Consultant’s Perspective – Jes Schultz Borland talks about how she sees it now that she’s an employee.
- Upgrade Challenges at StackOverflow – when we upgraded to SQL Server 2008, we had a surprising performance problem with seemingly harmless queries.
- Why You Shouldn’t Always Virtualize SQL Server – in general, Brent is a raving fan of virtualization, but not every server makes sense in virtual environments.
For more articles, visit the SQL performance topic page of our blog.
- There’s Something About NOLOCK - Kendra Little shows you some surprising performance implications of the NOLOCK hint.
- How to Tell When TempDB is a Problem – Jeremiah Peschka helps you figure out if tempdb is dragging down your SQL Server performance.
- How to Design Smarter Indexes – Kendra Little gives you a method and scripts to performance tune your indexes.
- Developers, Performance, and the SQL Server Transaction Log – Kendra Little talks about how application patterns impact performance of the transaction log
- How to Find Slow SQL Server Queries – video tutorial of Adam Machanic’s excellent (and free!) sp_WhoIsActive tool.
For more videos, visit our video archive.
* No one at Brent Ozar Unlimited holds a medical degree. If you have joint pain, breathing problems, or other symptoms, please call your doctor. If you have SQL performance issues, contact us.