Tag Archives: Performance

The One Metric to Rule Them All

Posted on December 9, 2016 by

When we want to know if our databases are running well, most of us look at metrics for our servers. Usually some combination of CPU, RAM, Disk IO are chosen, though network, user connections, batches and transactions can be a … Continue reading →

Posted in Editorial | Tagged ,

Why Use R Services?

Posted on June 23, 2016 by

I ran across a blog post from the very talented Joe Sack recenty, who I hope makes a few more minutes for me the next time we’re in the same town together ;). The post is a look at some … Continue reading →

Posted in Editorial | Tagged , ,

Finding Problem Code

Posted on May 1, 2015 by

Performance of a SQL Server seems to be one of the main concerns for most developers and DBAs. We are under pressure to constantly squeeze more performance out of our applications and reduce the time it takes for users to … Continue reading →

Posted in Editorial | Tagged , ,

Searching for Plans

Posted on April 23, 2015 by

Today’s editorial was originally published on Sept 13, 2010. It is being re-run as Steve is away at training. I was re-reading Conor Cunningham’s “Does Join Order Matter?” recently and found this quote in the post that stood out. As … Continue reading →

Posted in Editorial | Tagged ,

Checking Baselines with SQL Monitor

Posted on April 20, 2015 by

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 , ,

Normalizing Performance

Posted on November 2, 2014 by

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 , ,

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

Posted on April 30, 2014 by

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 , , ,

Performance Tuning Through Panic

Posted on February 10, 2014 by

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 ,

Database Queries and Scalability

Posted on October 21, 2013 by

I ran across this post with a very provocative title:  (thanks Brent Ozar Unlimited). It’s an interesting read from a developer, talking about how so many website designs aren’t built for scalable because they rely too heavily on a set of database … Continue reading →

Posted in Editorial | Tagged , ,

Achieve Better Performance

Posted on July 1, 2013 by

One of the hottest topics at most every SQL Server event I attend is performance. The sessions that talk about improving performance through various means are well attended, and that tells me a few things. One is this is an … Continue reading →

Posted in Editorial | Tagged , ,