-
Time to execute a query?
Is there a way in sql server to find out how much time a sql server took to execute a query.
Thanx in advance.
Regards,
Samir
-
If you are using SQL 2K then run the query in query analyzer, it displays the total execution time at the bottom status bar.
You can run profiler to get the same information (and more)
Or you can select getdate() function before and after the query and calculate the difference.
-
Thank u
Hi Skhanal,
Thank u very much for ur reply.
Regards,
Samir.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|