dcsimg

Riverbed accelerating SQL at SQL Saturday

Sqlsat

I had the privilege of attending SQL Saturday this past weekend at the Microsoft Technology Center in Mountain View, CA.  There were over 400 people in attendance

There we talked about how the Riverbed Steelhead improves the performance of SQL applications.  The below picture illustrates a typical SQL operation.

 

The client sends the SQL Query Select A from B where C=D to the SQL Server.  The SQL Server replies with a list of rows that matched the query and the client requests these rows one by one.  The passiveness of this protocol can lead to excessive latency as each row incurs the penalty of a full WAN round trip, as the client has to ask for each row.  All these round trips add up and can cause SQL applications to slow to a crawl.

 

Here is the same sequence, now optimized by the Riverbed Steelhead. The server side Steelhead intercepts the replies from the SQL Server and begins proactively retrieving the matched rows.  The rows are then immediately pushed to the client side Steelhead, eliminating WAN round trip penalties and greatly improving the performance of SQL applications.

Here is a video of my presentation

 

 

1 Responses

  1. Bhuvanesh Rajput

    Dec 27, 2013

    very well explained!!

Leave a Reply


$mainImageBigHTML ×

Riverbed. WAN optimization for your network: Application acceleration, WAN bandwidth optimization, and IT consolidation. Riverbed is the IT performance company. WAN optimization solutions from Riverbed liberate businesses from common IT constraints by increasing application performance, enabling consolidation, and providing enterprise-wide network and application visibility – all while eliminating the need to increase bandwidth, storage or servers. Thousands of companies trust Riverbed to deliver greater productivity and cost savings by making their IT infrastructure faster, less expensive and more responsive. Riverbed solutions are also available as managed services through select providers.

We need your email to add to briefcase!

×

Update your Profile!

×
×
×