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 delivers the most complete platform for Location-Independent Computing, turning location and distance into a competitive advantage. The Riverbed Application Performance Platform™ allows IT to have the flexibility to host applications and data in the most optimal locations while ensuring applications perform as expected, data is always available when needed, and performance issues are detected and fixed before end users notice. At more than $1 billion in annual revenue, Riverbed has 25,000+ customers, including 97% of both the Fortune 100 and the Forbes Global 100.

We need your email to add to briefcase!

×

Update your Profile!

×
×
×