You might want to compare the time difference while doing dome operation on your webpage and running the underlying query on sql server to check if there is some issue on SQL side or some other stuff. If you don't know what is underlying query to the page (which is very rare case), you can track the same by performing some operation while running profiler to track down what is happening.