We all crave routine in our life, from the time we are babies through adulthood. Routine and familiarity. This extends to how we do performance monitoring and troubleshooting. Everyone has their favorite set of tools to help get the job done, tools that have a familiar routine involved to make them work best for us. Over the … Read more
You sit down at your desk. It’s 9:10AM and your coffee is still warm. There is a smell of bacon in the air. Suddenly your phone rings. The trading system is down. The time for quick thinking is now. Where would you begin to troubleshoot this scenario? A lot of people will reach for the biggest … Read more
When it comes to troubleshooting performance issues with SQL Server queries, you don’t need an advanced degree in rocket surgery.
Today I had another article go live over at SQL Server Pro. Here is a quick excerpt: I have been involved in virtualization projects for about ten years now. In that time I have had the opportunity to track my own list of best practice items. It’s a list I share freely with customers that … Read more
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 … Read more
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. They don’t understand the upper bounds of resources like network bandwidth, the speed of light, and that the data is … Read more
