Database Response Time

[oracleguy]

Is there some way with MsSQL 2000 and ASP to find the response time of the database? Like how long, probably in miliseconds, it took for the query to execute?

I can't seem to think of anything that will tell me the time in anything less than a second.

[raf]

Timer will

like

dim starttimer, endtimer

sql="blablable"
starttimer=Timer
rsRecordset.Open sql, conn
endtimer=Timer
response.write("Execution took " & endtimer-starttimer & " seconds")

[oracleguy]

Works great. Thanks raf.

[raf]

You're welcome :thumbsup: