performance

The 3 DBA Mistakes You Don’t Know You Are Making

The 3 DBA Mistakes You Don’t Know You Are Making

You have no idea that what you are not doing is causing you pain.
Then again, how could you know this? I mean, if you are not doing it, why would you ever think that your inaction could be the very thing that is causing you heartache every time your phone rings in the middle of [...]

Are You Using the Right SQL Server Performance Metrics?

Are You Using the Right SQL Server Performance Metrics?

No matter what our profession, we all have our favorite set of tools to help us get the job done.
Database Administrators will have a set of scripts that we use in order to gain insight into the server instances under our care. I often see beginner DBAs look to the counters provided by Perfmon (AKA, the Resource and Performance [...]

6 Little Known Things That Can Cause Big Performance Issues

6 Little Known Things That Can Cause Big Performance Issues

As a system admin, DBA, or a developer it is our job to root out performance problems quickly. The trouble is that there are so many things that can cause performance issues it can be difficult to know every possible root cause. This is especially true when the root cause lies somewhere outside your area [...]

Expert Query Performance Troubleshooting

This video is an hour-long but well worth sharing with you today. One of the main takeaways from this video I want you to have is the fact that troubleshooting performance is not always rocket surgery. When you watch this video and listen to Conor Cunningham talk about some of the real world examples he [...]