Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > Cache


Search:
What's New - What's Hot
SqlDependency based caching of LINQ Queries  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: rusanu      Rating:  
Read Reviews | Write Review |  Your Rating: 

Query Notifications is the SQL Server feature that allows a client to subscribe to notifications that are sent when data in the database changes irrelevant of how that change occurs. I have talked before about how Query Notifications works in the article The Mysterious Notification. This feature was designed specifically for client side cache invalidation: the applications runs a query, gets back the result and stores it in the cache. Whenever the result is changed because data was updated, the ...

SqlDependency – Proof of Concept (Part II)     
Total Hits: 140  |  Today: 0Author: Donny Mack      Rating:  
Read Reviews | Write Review |  Your Rating: 

The ASP.NET Cache supports invalidation based on key, timestamp, or file dependencies, e.g. file changes and the cache item is invalidated. A frequent question is how to support this from a database, e.g. we're caching a DataSet, or some other reperesentation of data, in the ASP.NET Cache and the table(s) representing that data changes; thus the data in the Cache is no longer valid. This sample shows using some simple code that will automatically wire up a trigger on a table and call an extended...

Invalidating an ASP.NET Web Application Cache Item from SQL Server (Part 1 – A simple example)     
Total Hits: 173  |  Today: 0Author: Donny Mack      Rating:  
Read Reviews | Write Review |  Your Rating: 

We have seen over and over again the question, "How can I invalidate a cache item in my ASP.NET Web application when a change is made in my database?" Well, this article will demonstrate one way to accomplish this using triggers, a console application, and dependency files. As the title implies this is a two part article, the second part (or example) will be much more complicated and will span many different types of technologies including HttpHandlers, SQL Server, and enabling SQL Server itself...

Utility Belt: Caching Demo SQLserver     
Total Hits: 184  |  Today: 0Author: Charles Carroll      Rating:  
Read Reviews | Write Review |  Your Rating: 

To make applications faster and provide an added benefit to using UtilityBelt all functions internally use DataTables to fetch data from the database support caching in an easy transparent fashion by setting properties instead of changing the actual library calls....

Use .NET's BackgroundWorker to Keep ASP.NET Cache in Sync with a SQL Server Database  Version: 0.00     Price: $0.00  
Total Hits: 13  |  Today: 0Author: Rusty Speidel      Rating:  
Read Reviews | Write Review |  Your Rating: 

Storing frequently accessed database data, like lookup lists, in ASP.NET’s cache is a great way to optimize a web application’s performance. But anytime you store database data in ASP.NET’s cache, you have to provide a way to update that cache. This ensures changes made in the database make it into the web application’s cache. This is handled using either notifications or polling....

SQL Server Caching  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: Harshit Vyas      Rating:  
Read Reviews | Write Review |  Your Rating: 

Among all of .NET's good features caching is one of my favorites. Caching is really very easy to understand. It's concept is that if we need to fetch the data multiple times from SQL Server or from any file then it will cause a reduction of performance as we are retrieving the same data multiple times from the database or a file so why retrieve the same data again and again we can just store that data in our cache object....

How To Implement Proactive Caching in SQL Server Analysis Services (SSAS) 2005     
Total Hits: 409  |  Today: 0Author: Ray Barley      Rating:  
Read Reviews | Write Review |  Your Rating: 

We have chosen MOLAP storage in order to maximize the query performance of our cubes. Since we have a number of cubes we are now focused on coming up with a strategy for keeping the cubes up to date as the data in our warehouse changes frequently. Can you give us the details on how we go about implementing the Proactive Caching feature in SQL Server Analysis Services 2005?...

Keeping data available in the SQL Server data cache with PINTABLE     
Total Hits: 200  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Have you ever wondered why even after optimizing a database that it still takes considerable time to fetch the results? The problem is whenever a query is fired SQL Server fetches the data from the database by means of bringing the data pages into memory. Depending on the database activity the data you may be using quite frequently may be getting paged in and out of memory which may account for why sometimes it takes longer then other times to fetch the data. This paging is done automatically...

Build Your Own Analysis Services Cache-Warmer in Integration Services     
Total Hits: 183  |  Today: 0Author: cwebbbi.spaces.live      Rating:  
Read Reviews | Write Review |  Your Rating: 

Cache-warming is one of the most neglected performance-tuning techniques for Analysis Services: perhaps it seems too much like cheating? Yet almost everyone knows how much difference there can be executing a query on a cold cache and a warm cache so there should be no excuse not to be doing it, especially if you know what queries your users are likely to be running in advance. AS2005's caching mechanism is more complex than I can describe here (or than I can describe full stop - although I hear ...

Report Execution Caching II: Report Manager Perspective     
Total Hits: 199  |  Today: 0Author: William Pearson      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article is a member of the series MSSQL Server Reporting Services. The series is designed to introduce MSSQL Server Reporting Services (“Reporting Services”), presenting an overview of its features, with tips and techniques for real-world use. For more information on the series in general, please see my initial Database Journal article, A New Paradigm for Enterprise Reporting. For the software components, samples and tools needed to complete the hands-on portion of this article, see BlackBe...

Invalidating an ASP.NET Web Application Cache Item from SQL Server (Part 1 – A simple example)     
Total Hits: 130  |  Today: 0Author: Donny Mack      Rating:  
Read Reviews | Write Review |  Your Rating: 

We have seen over and over again the question, "How can I invalidate a cache item in my ASP.NET Web application when a change is made in my database?" Well, this article will demonstrate one way to accomplish this using triggers, a console application, and dependency files. As the title implies this is a two part article, the second part (or example) will be much more complicated and will span many different types of technologies including HttpHandlers, SQL Server, and enabling SQL Server itself...

Caching Data for Better Performance     
Total Hits: 257  |  Today: 0Author: Marco Bellinaso      Rating:  
Read Reviews | Write Review |  Your Rating: 

In every site or web-based application there is some data that doesn’t change very often, which is requested very frequently by a lot of end users. Examples are the list of article categories, or the e-store’s product categories and product items, the list of countries and states, and so on. The most common solution to increase the performance of your site is to implement a caching system for that type of data, so that once the data is retrieved from the data store once, it will be kept in memor...

SQL Express Dependency Caching     
Total Hits: 276  |  Today: 0Author: asp.net      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Express dependency caching is easier to set up because SQL Express natively supports change notifications. You do not need to run special command line utilities to prepare the database because notifications are automatically generated by SQL Express. Moreover, the SqlCommand class inherently supports dependency caching. Simply instantiate the SqlCacheDependency class with a SqlCommand object and then use the Response object's AddCacheDependency method to add the SqlCacheDependency object to ...

Analyzing SQL Server 2000 Data Caching     
Total Hits: 349  |  Today: 0Author: Tom Pullen      Rating:  
Read Reviews | Write Review |  Your Rating: 

One of SQL Server 2000’s main selling points is its ease-of-use and simplicity. You can install it out of the box and use it pretty much without making many configuration changes. In terms of the product’s use of memory, there are some settings you can change, for example, how much memory to use, whether to dynamically allocate it, and so on. Otherwise, there isn’t a lot you can do in terms of memory tuning. But you may well find yourself in a situation where you want to know what tables and ind...

Using SQL Cache Dependency     
Total Hits: 354  |  Today: 0Author: Wei-Meng Lee      Rating:  
Read Reviews | Write Review |  Your Rating: 

Caching has long been recognized as one of the more effective ways to improve your ASP.NET web applications. However, one particular caching feature that was dearly missing in ASP.NET 1.x was SQL cache dependency. SQL cache dependency is the ability to invalidate a database cache if data in a table is changed. In ASP.NET 2.0, Microsoft has, much to the joy of developers, added the new SQL cache dependency feature. In this article, I will discuss SQL cache dependency in ASP.NET 2.0, as well as di...

Analyzing the SQL Server Plan Cache     
Total Hits: 148  |  Today: 0Author: Atif Shehzad      Rating:  
Read Reviews | Write Review |  Your Rating: 

The cache management mechanism plays an important role in performance of any system. Like any reliable DBMS, SQL Server enjoys a sophisticated cache management system for optimized performance without the need for any user intervention. There are ways to add a plan or data to the SQL Server cache or to remove a plan or data from SQL Server cache, but these techniques are only recommended for testing or troubleshooting purposes. Keeping in mind the importance of the cache mechanism, how could one...

Manage databases, easier FTP, and clustered caching     
Total Hits: 94  |  Today: 0Author: Scott Mitchell      Rating:  
Read Reviews | Write Review |  Your Rating: 

There are many tools available for managing databases, exploring and modifying schemas, and writing and executing queries. One such off-the-shelf tool worth investigating is DatabaseSpy 2007 by Altova. DatabaseSpy can connect to a wide variety of different data stores—Microsoft® Access®, Microsoft SQL Server™, Oracle, MySQL, Sybase, and so on—and provides a uniform user experience regardless of the database.

When first connecting to a database through DatabaseSpy, a new project is automat...

The SqlCacheDependency Class     
Total Hits: 158  |  Today: 0Author: Luke Stratman      Rating:  
Read Reviews | Write Review |  Your Rating: 

Luke Stratman shows how and why to use the SqlCacheDependency class.

It's hard for me to pin down a favorite feature in the 2.0 version of the .NET framework. Is it generics? Or maybe built-in configuration file encryption? How about the updated configuration classes? It's a tough choice. But there's no doubt about my favorite example of what makes .NET 2.0 such a compelling development platform: the SqlCacheDependency class. It does a brilliant job of illustrating just how well the vario...

Using SQL Cache Dependencies     
Total Hits: 180  |  Today: 0Author: Scott Mitchell      Rating:  
Read Reviews | Write Review |  Your Rating: 

The simplest caching strategy is to allow cached data to expire after a specified period of time. But this simple approach means that the cached data maintains no association with its underlying data source, resulting in stale data that is held too long or current data that is expired too soon. A better approach is to use the SqlCacheDependency class so that data remains cached until its underlying data has been modified in the SQL database. This tutorial shows you how....

Article-Synchronize Distributed Object Cache with SQL Server 2005     
Total Hits: 171  |  Today: 0Author: Iqbal M Khan.      Rating:  
Read Reviews | Write Review |  Your Rating: 

NCache lets you cache data closer to your application in the middle-tier so you can reduce expensive trips to the database. This in turns significantly speeds up your application. It also makes it more scalable because the load on your database is reduced allowing it to handle a larger number of clients without any hardware upgrades.

However, when you cache data, you're actually creating a copy of it outside of your database. This introduces the risk that data in your database would be mo...


1  2  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net