BT

Accelerate SQL Server Performance With SafePeak’s Dynamic Database Caching

by Roopesh Shenoy on Nov 07, 2011 |

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.

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

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT