Post reply

how many execution plans can be cached by SQL Server 2005

  • May 22, 2008 at 11:47 am

    #191368

    Hi, I'm working on a SQL Server 2005 DB with 250 Stored Procedures, more or less.

    I would like to know two things:

    1) are execution plans of queries realized in Stored Procedures cached inside DB or not?

    2) if so, how many (more or less) execution plans can be cached in the database?

    thank u

    CRI

  • May 22, 2008 at 1:16 pm

    #819334

    Execution plans are stored in cache and if your sql server is running low on memory then they are flushed out at regular intervals. Each database maintains its own cache in the buffer pool.

    It depends on the memory available for sql server(ur second question) and also on execution plans size as that adds to memory consumption in cache.

    Experts please comment.

    Manu

  • May 22, 2008 at 1:51 pm

    #819360

    i dont know the exact number of execution plane its all about memory, but i have a database server with over 50,000 procedure and 300 user, and never had problems this knid.

    ..>>..

    MobashA

  • May 23, 2008 at 12:34 am

    #819496

    thank u, so I will not face these problems, yet... :-))

    bye CRI

Viewing 4 posts - 1 through 3 (of 3 total)

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