April 23, 2014 at 10:18 am
Hi all,
If any one worked before, please give me pros & cons of App fabric cache and proc cache.
What are the advantages of Proc cache over the App fabric cache.
Thanks
April 23, 2014 at 12:29 pm
You're comparing apples to hammers.
The procedure cache within SQL Server is for caching query execution plans for the queries running within SQL Server. It does this to avoid recompiling queries since that can be resource intensive. AppFabricCache is a programming mechanism for caching data, either user state data or non-volatile lookup data or just data that doesn't need to be persisted (stored permanently) in general, but out at the application layer. While it does relate to data, it has no relation or correlation with the procedure cache. They are absolutely completely different things.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 23, 2014 at 12:43 pm
Rightly put Grant.
Now the only question is are you talking about Proc cache or are you talking about tables residing in memory on SQL Server 2014. memory optimized tables?
-Roy
April 24, 2014 at 11:04 am
Thanks for the replies.
Our environment is something product selling. We do have App Fabric cache thing. Whenever customer come and try to buy the products we will some id for that customer and he can keep that products in shopping basket. Later he can come edit or finish purchase by using that reference id. For the session cache they are using App fabric. Now they are planning to go for proc cache. So I am confusing how the proc cache works here.
Thanks
April 24, 2014 at 11:33 am
They are using some wrong term when they say Proc cache.
-Roy
April 24, 2014 at 1:51 pm
They are saying in proc
April 24, 2014 at 2:16 pm
They may be saying that, but you can't store data in the proc cache. You can't. It's an internal system memory space completely managed by SQL Server. It's not something you can control or make use of for other purposes than the ones that SQL Server puts on it. They must mean something else.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 24, 2014 at 2:30 pm
Ok. Thanks
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply