Here is some more information

Query:

select * from calls where calldate between '20050504' and getdate() and username='.isdfh'

Execution time: 1st time 5 mins approx, 2nd time mins 48 secs

DDL file: http://202.3.130.27/test/calls.sql

Sample data...

thanks, but isn't there any way in mssqlsrv to do this without any overhead?

Sql profiler is a temporary solution. I want a permenant solution like anybody who is reading/ writing to database through isqlw at anytime, their queries should be logged.

Any suggestions?