View SQL Queries/times for page request

Question

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)?

Russell · Accepted Answer · 2012-02-20 12:27:37Z

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.

answered Feb 20 '12 at 12:27

Russell
1,993415

stopthatastronaut · Answer 2 · 2012-01-31 01:42:38Z

up vote -1 down vote

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

answered Jan 31 '12 at 1:42

stopthatastronaut
20911

2 Answers