Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

WAAS SQL Prepositioning

Our organization uses a fat-client that access a MS SQL database in the datacenter. We are looking to improve performance to a branch office with the existing WAE-612 installed.

Is there a way to preposition the SQL databases to increase performance?

Or what would be the optimal solution for SQL queries?

Thank you,

1 REPLY
Cisco Employee

Re: WAAS SQL Prepositioning

By default, WAAS applies full optimization (TFO+DRE+LZ) to MS SQL traffic.  There is currently no SQL-specific application acceleration.  The performance benefit you can expect depends on the nature of the transactions (i.e. the volume of data) and the WAN characteristics (bandwidth and RTT latency).

Practiacally speaking, it's likely that you will see a decent reduction in bandwidth consumption, but less improvement in overall user response time.

Regards,

Zach

425
Views
0
Helpful
1
Replies