Tag Archives: Performance

Checking Baselines with SQL Monitor

Posted on April 20, 2015 by way0utwest

We’ve got a demo of SQL Monitor available that takes data from the actual SQLServerCentral systems and presents it publicly. The data is slightly delayed, but it’s the real data and it shows the performance of our system. I actually … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Checking Baselines with SQL Monitor

Normalizing Performance

Posted on November 2, 2014 by way0utwest

This week I ran across a post from Glenn Berry on hardware performance that I thought framed the concept of performance value well. In the post, Glenn talks about the latest TPC-E benchmark and the SQL Server performance values that … Continue reading →

Posted in Uncategorized | Tagged , , | Comments Off on Normalizing Performance

The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward

Posted on April 30, 2014 by way0utwest

I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found it very interesting. To be fair, some of the "how it works" isn’t something I care about much, but … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward

Performance Tuning Through Panic

Posted on February 10, 2014 by way0utwest

We’ve all been there at one time or another: panicked by a performance issue. I once upgraded a FoxPro for DOS application to a VFP front end with a SQL Server back end. We had a much more powerful server, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Performance Tuning Through Panic