Tag Archives: Performance

What is CPU Usage?

I had a request from a customer recently who asked if we could give them a report of their database server instances and include CPU usage. This request was filtered through an account executive, so something was lost in translation, … Continue reading

Posted in Editorial | Tagged , | Leave a comment

T-SQL Tuesday #200: When I Look at a Query …

This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound big, but this is a monthly party (started by Adam Machanic). We have 12 blog party events a year. 200 means this has been running for … Continue reading

Posted in Blog | Tagged , , , | 3 Comments

When Do We Worry About Scalability?

“We need to get the code written for feature X. Can you finish this query today?” We’ve all heard some variation of that request. We have a request or demand, and we need to get it done. We need to … Continue reading

Posted in Editorial | Tagged , | 1 Comment

Invisible Downtime

This article has a concept I’ve never heard about: invisible downtime. This is the idea that there are problems in your application that the customer sees. Your servers are running, but the application doesn’t work correctly or is pausing with … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Invisible Downtime