Tag Archives: Performance

SQL Server Tuning Skills

Performance tuning a SQL Server instance, database, or even query is a skill that most of us could improve. In fact, I see that the query performance presentations are often the most popular learning items at any event. I’ve seen … Continue reading

Posted in Editorial | Tagged | 2 Comments

We Need DevOps for Performance

I read this nice piece on CosmosDB and setting performance levels. It covers how you set some level of performance for Request Units (RU) and CosmosDB handles the rest. Great, right? Set the level of performance you need and that gets handled. The … Continue reading

Posted in Editorial | Tagged , | Comments Off on We Need DevOps for Performance

Graphing Performance

We have a lot of different database platforms to choose from when building software. Most of us reading this are SQL Server users, and likely relationally biased. However, key-value stores, document databases, graph databases, and more are out there. If … Continue reading

Posted in Editorial | Tagged , | Comments Off on Graphing Performance

The One Metric to Rule Them All

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 , | Comments Off on The One Metric to Rule Them All