Post reply

Stored procedure performance

  • August 25, 2005 at 8:13 pm

    #152524

    I have a .Net application that defines a job into SQL Server and this Job execute a SP that makes a lot of querys, and this SP execute anothers SP, the problem is that this SP once is executed it takes one times 5 mins, another times 10 mins, and the process is the same.

    Is there an option or a way to see if the job is created correctly and the SP is invoqued correctly?

    or

    Is it something about the SQl Server Agent?

    Greetings

    Excuse my english.

     

  • August 25, 2005 at 9:02 pm

    #585264

    How about logging some status messages from within your stored procedures? Can be something as simple as logging the current datetime and a message to a table.

    EG:

    26/08/2005 12:00 PM job started

    26/08/2005 12:01 PM sp1 started

    26/08/2005 12:02 PM sp2 started

    26/08/2005 12:05 PM sp2 finished

    26/08/2005 12:06 PM sp3 started

    26/08/2005 12:08 PM sp3 finished

    26/08/2005 12:09 PM sp1 finished

    26/08/2005 12:10 PM job finished

     

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply