We run a fairly complex website using classic ASP. We are going to be moving our SQL Queries over to Stored procedures from the traditional code inline method.

What we need is a way of measuring the speed of both methods to see the level of query time saved (if any) when using Stored Procedures.

Any ideas would be appreciated.