.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Imran Ghani
Post New Web Links

plan caching

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server
 

what is the basis of a plan being included in a plan cache.?

suppose i want to know the number of times a query was executed, so i will get the entry in the plan cache for that query.

But i have read that many queries can use a single plan. So how will i know the number of times the query is executed using the plan because the same plan might have been used by some other query, so the plan will give the combined execution count of both the queries.

And, i have read that the query plans are based on the cost. So what is the basis for the cost of the plan. I mean, when does two different queries use the same plan?. can two queries fired on two different tables use the same plan?


i am using this dynamic view

sys.dm_exec_query_stats

please suggest me if there are any better views available.




View Complete Post


More Related Resource Links

sql server (plan caching)

  

what is the basis of a plan being included in a plan cache.?

suppose i want to know the number of times a query was executed, so i will get the entry in the plan cache for that query.

But i have read that many queries can use a single plan. So how will i know the number of times the query is executed using the plan because the same plan might have been used by some other query, so the plan will give the combined execution count of both the queries.

And, i have read that the query plans are based on the cost. So what is the basis for the cost of the plan. I mean, when does two different queries use the same plan?. can two queries fired on two different tables use the same plan?


sql server (plan caching)

  

what is the basis of a plan being included in a plan cache.?

suppose i want to know the number of times a query was executed, so i will get the entry in the plan cache for that query.

But i have read that many queries can use a single plan. So how will i know the number of times the query is executed using the plan because the same plan might have been used by some other query, so the plan will give the combined execution count of both the queries.

And, i have read that the query plans are based on the cost. So what is the basis for the cost of the plan. I mean, when does two different queries use the same plan?. can two queries fired on two different tables use the same plan?


Creating your SharePoint Governance Plan

  
One of the most common questions that I get from prospects as I'm talking to them about the creation of a governance plan and process is what does it look like. In other words, there are materials available which describe what should be in a governance plan but there isn't a ton of guidance on what the process of creating a governance plan and process are.

ASP.Net Caching problem ??

  

I'm having a problem with an asp.net 3.0 application using a gridview to display data.  The problem seems to be that despite a brand new .selectCommand being sent to the sqlDataSource, the gridview starts displaying data from *someone else's* query.  For example, user A is logged in and will be working fine until a few page submissions later when the gridview data starts suddenly showing information that belongs to another user. 

This is my first asp.net application, though I've been working with classic asp and ADO for years so I'm used to sending a SQL string and getting back the results from that string.  Apparently there is a complex caching system which is interferring which I do not at all understand so at this point I just want to stop the server from caching any data whatsoever.  Is this possible?

Any and all help will be much appreciated!!


is the page caching?

  

I am just trying to understand the basics flow to the MVC framework by putting in some breakpoints in the beginning of the actions of a couple of controllers.

One break point is at the HomeController/Index action where it just returns View() of the "Welcome to MVC".  The Second break point is at a SecondController/Index action where it uses the Entity Framework and returns a View() of a list from the db.

When I run this in debug, it breaks at the points I expected when I go from Home page to the Second page controller and back to Home.  However, when I go to the Second page again, it doesn't break at all?  Is the results of the Second page being cached and how and where?  How do you trigger for it to get check if data is old?

I check to see if the persistence is done on the db, by changing the value of a field on the db side and it still did not cause it to break on that action and displays old information in the view.  I am concerned because it is displaying incorrect values on the UI.  I do not have the OutputCache attribute above this action or specified any cache on my web.config.

Thanks in advance for your time :)


Data caching c#.net

  

Hi Friends,

 

I have a large SQL Database in the server from which I can create a dataset of about 10000 rows. My question is about caching this data. Which type of data caching should I choose (Server side or Client side)? Which one will provide better performance?

 

Thanks in advance


SOA Tips: Address Scalability Bottlenecks with Distributed Caching

  

SOA makes application scalability easier, but getting the best performance out of your SOA means paying close attention to the details. We'll give you some tips for coding your app more effectively and using distributed caching to remove data access bottlenecks.

Iqbal Khan

MSDN Magazine June 2010


Toolbox: Distributed Caching, Object-Object Mapping, Blogs and More

  

This column covers Web application performance with distributed caching, a utility for object-object mapping, and a look at interesting blogs.

Scott Mitchell

MSDN Magazine September 2009


Scale Out: Distributed Caching On The Path To Scalability

  

Developers frequently face issues related to scalability bottlenecks when they have applications that need to handle a lot of load. This article describes the role of a distributed cache in building scalable applications.

Iqbal Khan

MSDN Magazine July 2009


Velocity: Build Better Data-Driven Apps With Distributed Caching

  

Microsoft Velocity exposes a unified, distributed memory cache for client application consumption. We show you how to add Velocity to your data-driven apps.

Aaron Dunnington

MSDN Magazine June 2009


Toolbox: Manage databases, easier FTP, and clustered caching

  

This month's products include DatabaseSpy, FileZilla, NCache, and more.

Scott Mitchell

MSDN Magazine October 2007


Controls: Plan Your Migration to the Visual Studio 2005 Navigation Controls

  

Navigation is central to a well functioning Web application and it can be implemented numerous ways using today's technologies. This article highlights some of the key details of the new navigation controls that are part of the upcoming ASP.NET 2.0, and talks about how to design and implement one of these navigation controls today. This article contains a simple Web site that demonstrates the use of these navigation controls, pointing out some of the key items such as a breadcrumb control and things to watch for along the way. The article then describes how to implement a breadcrumb control today.

Dave Donaldson and Steven DeWalt

MSDN Magazine June 2004


Web Farms: Use Data Caching Techniques to Boost Performance and Ensure Synchronization

  

Performance is an important concern for any application, but becomes critical when the app is a Web Service accessed by thousands of clients simultaneously. One hardware approach to distributing Web Services requests evenly is a Web farm consisting of multiple servers. Once on a Web farm, Web Service performance can be improved by using ADO.NET DataSet objects to cache frequently accessed data, reducing round-trips to the database. Here the author describes data caching in a Web farm environment and discusses how to avoid the cross-server synchronization problems inherent in this approach.

David Burgett

MSDN Magazine December 2002


pre caching

  

hi,
i have a website named 'bizlis.com'which  i have built a website  in asp.net 2.0 with sql 2005 database.it is a database search engine which searches buyers and sellers all around the world....
when user enters url 'bizlis.com'.my home page opens .loading time of home page is fast.homepage has ..
 user has to  select country from dropdown box,he selects category from dropdown(buyer/seller)he then selects a criteria from dropdown(exact phase search,anyword search or all word search) after that he enter product name in the textbox which he wants to search ...after that searching is done ..the problem is that my searching for the first page takes very long time it takes 8-10 seconds (try searching for steel sellers from india as it has maximu records)..after first page is loaded in 9-10 sec ..then 50 records are shown .it has navigation button on click of next navigation button data comes faster as compared to loading(starting first page-which brings data for the first time ) page.this is because cahing is applied...

hence now my biggest problem is that how to make my first datapage fast(starting first page-which brings data for the first time)


some of my friends told me to apply pre caching

i can do it in 2 ways

1.either by load

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend