Home Forums SQL Server 2008 SQL Server 2008 Administration SQL Plan Cache RE: SQL Plan Cache

  • August 15, 2012 at 11:54 pm

    #1526338

    Grant Fritchey (8/15/2012)

    That number does seem high, but only because I've primarily worked on systems with stored procedures. If you're working with lots of dynamic or ad hoc SQL, then that number can be "normal." The only way to know for sure is to observe the system over time, recording the values, and compare one state to another in order to determine what's "normal" for the situation.

    Thanks

    To make sure I have this right, if a Query is submitted to SQL Server and it's not part of a Stored Procedure, SQL Server has to generate a plan for it everytime?

    Thanks