Results 1 to 3 of 3

Thread: Time to execute a query?

  1. 08-01-2003, 08:29 AM #1
    samkud
    samkud is offline Registered User
    Join Date
    Aug 2003
    Posts
    8

    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
    Reply With Quote Reply With Quote
  2. 08-01-2003, 09:06 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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.
    Reply With Quote Reply With Quote
  3. 08-01-2003, 11:15 PM #3
    samkud
    samkud is offline Registered User
    Join Date
    Aug 2003
    Posts
    8

    Thank u

    Hi Skhanal,

    Thank u very much for ur reply.

    Regards,

    Samir.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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