plan-cache Image

plan-cache

question
rknight avatar image
rknight commented Default

SQL Server plan cache has only Proc (stored procedure) objects, but not Prepared nor Ad-hoc ones

plan-cache

0 Likes

2Answers

0 Comments

question
tomfp avatar image
tomfp asked Default

Temporary Caching expensive table

temporary-tables plan-cache

0 Likes

0Answers

0 Comments

question
Kev Riley avatar image
Kev Riley commented Default

Plan Cache - 100% plans created in last 4 hours

plan-cache sql-server-2008-r2-sp1

1 Like

1Answer

5 Comments

question
Kev Riley avatar image
Kev Riley answered Default

Plan cache reuse

execution-plan plan-cache

2 Likes

1Answer

0 Comments

question
KenJ avatar image
KenJ edited Default

When the old execution plans changed in plan cache

sqlserver2012 execution-plan plan-cache update-stats

1 Like

1Answer

2 Comments

question
Bartoloz avatar image
Bartoloz commented Default

The same query has different plan for different logins

statistics 2014 plan-cache

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
David Wimbush avatar image
David Wimbush answered Default

load test: the vendor wants to disable the cache

testing plan-cache test cache disabled

0 Likes

1Answer

0 Comments

question
Mart avatar image
Mart commented Default

What causes: System.Data.SqlClient.SqlException: The definition of object 'my_stored_procedure' has changed since it was compiled

stored-procedures plan-cache

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Is this a parameter sniffing issue?

performance plan-cache parameter-sniffing

2 Likes

3Answers

1 Comment

question
sp_lock avatar image
sp_lock commented Default

inefficient plan use when not using RECOMPILE

sql2012 query-optimisation plan-cache

This question has an accepted answer. Accepted

5 Likes

2Answers

0 Comments

question
Blackhawk-17 avatar image
Blackhawk-17 answered Default

Where is Plan Cache stored?

tempdb plan-cache

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Fatherjack avatar image
Fatherjack commented Default

Query Plan Cache size

dynamic-management-view plan-cache

This question has an accepted answer. Accepted

5 Likes

2Answers

0 Comments

12 Posts
12 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.