Tag Archives: Performance

Extreme SQL

Posted on November 12, 2020 by way0utwest

I have made a career of working with SQL and databases. Usually I’ve looked for interesting companies and people, but I’ve avoided extreme situations. For me, that often is very large, or very real time environments. I once declined a … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Extreme SQL

Waits and Queues

Posted on August 23, 2019 by way0utwest

How many of you have read this article: SQL Server Performance Tuning Using Waits and Queues? (PDF) If you haven’t, you might look at a review of the paper from Jeremiah Peschka. There is good advice about which parts to … Continue reading →

Posted in Editorial | Tagged | 1 Comment

Simulating Load

Posted on June 12, 2019 by way0utwest

I needed to generate some load for a demo and wasn’t looking forward to doing it. I was in a hurry, and didn’t want to deal with a lot of setup. Fortunately, I’d seen a technique for doing this in … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Simulating Load

Lack of Memory

Posted on January 3, 2019 by way0utwest

I was reading Brent’s look at “normal memory” for his SQL ConstantCare® clients. It’s a look at some stats from quite a few servers that customers have set up and he is monitoring. Since most of us only have a limited set … Continue reading →

Posted in Editorial | Tagged | Comments Off on Lack of Memory