Results 1 to 2 of 2

Thread: procedure compile lock help

  1. 03-26-2001, 04:11 PM #1
    Saul Guest

    procedure compile lock help


    I have one procedure that gets executed many times per day(thousands at least). I consistently get blocking in my database, as users compile this stored procedure. How can I keep this from recompiling all the time, and bogging down my database? I tried the keep plan option in the portion of the code that uses tembdb, and that doesn't work. thanks.
    Reply With Quote Reply With Quote
  2. 03-26-2001, 04:34 PM #2
    mjt Guest

    procedure compile lock help (reply)

    Is it compiled with WITH RECOMPILE option? Try taking that off.

    mjt


    ------------
    Saul at 3/26/01 4:11:03 PM


    I have one procedure that gets executed many times per day(thousands at least). I consistently get blocking in my database, as users compile this stored procedure. How can I keep this from recompiling all the time, and bogging down my database? I tried the keep plan option in the portion of the code that uses tembdb, and that doesn't work. thanks.
    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