SQLDataSource and Query Speed

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I have a .net 3.5 page with 10 SQLDataSources.

Does anyone know of an easy way to see how long it takes for each of the
queries to run?
 
Query alone?
Try Profiler if using SQL Server, as it will give the metric.

Complete time for each data source?
You will have to use code behind instead of declarative wiring (the drag and
drop/wizard approach) and wrap the actual data retrieval with a start and
stop time.

Hope this helps!

--
Gregory A. Beamer
MVP; MCP: +I, Se, SD, DBA

Blog:
http://feeds.feedburner.com/GregoryBeamer

*************************************************
| Think outside the box! |
*************************************************
 
Back
Top