BT

Your opinion matters! Please fill in the InfoQ Survey!

Accelerate SQL Server Performance With SafePeak’s Dynamic Database Caching

| by Roopesh Shenoy Follow 0 Followers on Nov 07, 2011. Estimated reading time: 1 minute |

SafePeak is a plug-and-play Dynamic Database Caching Solution, designed to improve data access performance for Applications built on SQL Server. It offloads the read queries and stored procedures which perform “Select” by dynamically caching in-memory result sets, thereby reducing read response time and overall database load.

SafePeak sits between the application and the database, servers, so that all the database calls go through it. It stores the result sets returned by the database in RAM, as is. When a recurring query or SP execution with the same parameters is passed through SafePeak, it will reply from RAM in a fraction of a millisecond instead of sending the query to the database. SafePeak employs traffic analysis to identify queries that are repeatable and will benefit from caching.

 

The cache is also updated whenever the data becomes invalid – all database queries, not just the read queries, are routed through SafePeak to SQL Server and SafePeak analyzes T-SQL queries for data-modification events and then refreshes the relevant cache items. Since data modifications not seen by SafePeak can effectively corrupt the cache, the new version of SafePeak also contains a feature called logon trigger, which intimates SafePeak about a direct connection to SQL Server and if needed, refresh the entire cache.

This is what Pinal Dave, earlier SQL Server MVP and now Technology Evangelist at Microsoft, had to say -

While there are specific environments that will clearly benefit from SafePeak, such as SQL Servers with high SELECTivity and read-intensive databases, it is designed for OLTP applications. Such environments that seem to get the most out of SafePeak’s acceleration are E-commerce, Cloud and Hosted apps, large SharePoint and CRM Dynamics implementations, ERP & CRM applications.

Pinal has written several blog posts about the various features in SafePeak. You can also read more about SafePeak Architecture on the vendor website.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Thanks by Rohit Deshmukh

Thanks Pinal and InfoQ for bringing this nice post together. SafePeek indeed looks very promising. Java67

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

1 Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT