Large SQL query performance check.
sakshi goyal
SQL Profiler Or SQL Execution Plan that show you the query performance.