Post reply

SP First time run takes longer!

  • July 28, 2009 at 9:23 am

    #1031108

    Increased the temp DB size to 70M and tried; the sp ran 3 sec less than before in the first run.

  • July 28, 2009 at 9:52 am

    #1031139

    How can you mark a stored proc as a startup procedure and have it run automatically in your DB. not the master DB?

  • July 28, 2009 at 10:03 am

    #1031145

    Startup procs have to be in the master database. They cannot be in any other DB. Bear in mind that, at the point that the startup procs run, the other databases may not have finished recovery and may not be online and available.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 16 through 18 (of 18 total)

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