SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

SharePoint 2010 has the fancy new developer dashboard where you can view the SQL queries made and how long they took to determine bottlenecks etc.

I am not a SQL Sysadmin so I cannot use SQL profiler (plus there is so much load it would be difficult to filter).

Is there a way of viewing this information using SharePoint 2007 (e.g. an API method, class, web part)?

share|improve this question
up vote 1 down vote accepted

Ended up using SQL Profiler, and using very specifically crafted filters - we actually created them by testing on a dev box.

share|improve this answer

I believe this is a 2010 enhancement and no equivalent exists in 2007

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.