Browse by Tags

• cache
• indexes
• management
• package
• performance
• sql server
• ssms

Cached query plans and top stored procedures that are recompiled
11 May 07 04:02 AM | SQL Master | 4 Comments   

We all know that the cached query plans are good to go to attain the performance and no doubt that inefficient query plan will cause more distress to performance with an increased spike in CPU consumption. At the same occurrence of recompilation of a Read More...

Filed under: sql server, query, plan, package, cache, indexes, perfmance

Execution plans caching and how SQL optimizer reuses for better performance
25 April 07 01:16 PM | SQL Master | 1 Comments   

Memory plays important role in Performance on a windows based platform, SQL Server 2005 features has a pool of memory that is used to store both execution plans and data buffers, only the part of memory is used to store execution plans that we call as Read More...

Filed under: ssms, performance, sql server, management, query, plan