performance

SQL Server Troubleshooting Useful Links

SQL Server Troubleshooting Useful Links

When it comes to troubleshooting performance issues with SQL Server queries, you don’t need an advanced degree in rocket surgery. You just need an idea of what the possible bottlenecks are and then apply some common sense. I “bucketize” performance issues by following a process of asking some simple questions. It goes something like this: Are all queries(…)

Did You Really Just Spend Thousands on New Hardware?

Did You Really Just Spend Thousands on New Hardware?

Seriously? You did what now? OK, I’m sure it’s all shiny and new and takes up less space in your data center. That sounds wonderful, truly. But did you try anything else before agreeing to spend money like a sailor on shore leave? I’m here today to help you understand your performance tuning options before(…)

Top 3 Performance Killers For Linked Server Queries

Top 3 Performance Killers For Linked Server Queries

One thing I have noticed in all my years as a data professional: few users understand (or care) how far away they are from their data. Quite often they expect instant results from their queries despite there currently being an upper bound due to things like network bandwidth, the speed of light, and the data(…)

Something Smells: Parameter Sniffing

Something Smells: Parameter Sniffing

Parameter sniffing is an aspect of SQL Server that is typically viewed as a bad thing. The simple fact is that SQL Server uses parameter sniffing all the time, that’s how SQL Server works. It is only those times when parameter sniffing results in performance issues that people (naturally) complain. It’s a lot like lawyers. It only(…)

Load More