What tools are people using to measure SQL Server database performance?

Asked 20/5, 2010 at 2:29 Answered 3/6, 2010 at 0:22

Solved sql-server-2008 sqlperformance

I've experimented with a number of techniques for monitoring the health of our SQL Servers, ranging from using the Management Data Warehouse functionality built into SQL Server 2008, through other commercial products such as Confio Ignite 8 and also of course rolling my own solution using perfmon, performance counters and collecting of various information from the dynamic management views and functions.

What I am finding is that whilst each of these approaches has its own associated strengths, they all have associated weaknesses too. I feel that to actually get people within the organisation to take the monitoring of SQL Server performance seriously whatever solution we roll out has to be very simple and quick to use, must provide some form of a dashboard, and the act of monitoring must have minimal impact on the production databases (and perhaps even more importantly, it must be possible to prove that this is the case).

So I'm interested to hear what others are using for this task? Any recommendations?

Extraversion answered 20/5, 2010 at 2:29 Comment(2)

I use the frequency of 2:00 AM phone calls to measure SQL Server performance. – Towardly 20/5, 2010 at 2:31

I really wish I'd had an answer like 'Use Foobar, it does all that and is reliable, catches 90% of the problems and has low impact'. Unfortunally I'm still searching for 'Foobar'. – Klecka 20/5, 2010 at 5:48

RedGate's SQL Response is definitely a great tool for the job.

EDIT #1

There is also SQL IO, which tests the I/O of SQL Server. You will have some further information following the link provided.

There are other performance testing tools such as DBMonster which are open source (you need to scroll down).

I can't remember the name of the absolute testing tool I already referenced here on SO. I shall write it here when I found out.

Recommended topics

Hot tags