Your data is a critical part of your business. As your business continues to succeed, the demands on your database will continue to increase. The increasing demands of a growing database environment can lead to unexpected performance changes like poor performance or outages. Without a clear performance baseline and plan to deal with the complexities of your SQL Server infrastructure, your team risks being left in the dark when issues arise. You may even miss opportunities to cut costs and increase performance.
Brent Ozar PLF specializes in database check-ups and performance tuning. We work directly with your team to assess the overall performance of your environment. We’ll dig in to any issues that we uncover, provide explanations, and offer strategies to mitigate or remove the issue.
During the check up, we’ll establish a performance baseline and set up a regular maintenance schedule. Regular maintenance will keep your database in great shape and will make it even easier to implement performance improvements. With a reliable baseline in place, you can track your performance improvements over time. As part of the check up, we also identify opportunities for database and server consolidation to cut costs.
Once the check up is complete, you will have a performance baseline, an action plan, and a set techniques to help you measure and maintain database performance.
Our Articles on SQL Server 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.
- Tuning Tip: Identify Index Overlaps – how to detect and resolve a silent performance killer.
- Adding Reliability to Your Infrastructure – why adding more servers and more moving parts doesn’t necessarily increase uptime.
- 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.
- More Articles on Scaling SQL Server
Our SQL Server Health Check Videos
At the Quest Virtual Conference, Brent Ozar demonstrated how to quickly assess basic server health with his free Blitz check-up script:
Here’s more examples:
- T-SQL Performance Tuning for Race Car Drivers – at the SQLBits conference in the UK, Brent Ozar explained how DBAs can learn from Formula 1 legends like Colin Chapman.
- Index Tuning with the DMVs – how many indexes should a table have? How do you know when indexes are slowing you down? Brent Ozar explains at the Quest Virtual Conference.
- How to Find Slow SQL Server Queries – video tutorial of Adam Machanic’s excellent (and free!) sp_WhoIsActive tool.
