Category: Performance

SQL Profiler for Developers and Testers

Introduction You developed a new TSQL code and want to check is there a slow SQL statement inside and which is it? Or you debug the code and want to know which statement throws error, maybe inside of a trigger

Collect Performance Data

Introduction Server is sometimes slow and you want to know why? Here is a lightweight diagnostic SQL kit which will give you the answer. You need to put it on your server to start logging of performance info. This solution

Tagged with:

How to save 250 000 EUR to your customer?

Recently, for the first time in my life I had a customer from India. A far away, beautiful country I had never opportunity to visit, with 1.3 billion of people. I thought it would be interesting experience, and it was indeed.

Page Life Expectancy and 300 sec limit

People blogged about it, including excellent Jonathan’s post here (highly recommended to read), but I will give a little more insight here. Basically, Microsoft says if PLE is below 300 seconds, we should worry about memory pressure (an old recommendation

Do you measure query IO with SET STATISTICS IO ON ?

Introduction In our tuning work and often in presentations we see people use SET STATISTICS IO ON as a handy way to measure IO, especially logical reads. But, not many people know that it skips measuring IO from certain types

Top
Visit Us On TwitterVisit Us On FacebookVisit Us On LinkedinVisit Us On YoutubeVisit Us On Google PlusCheck Our Feed