Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
675
Views
0
Helpful
1
Replies

WAAS SQL Prepositioning

plawrence
Level 1
Level 1

‎07-16-2010 07:54 AM

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,

0 Helpful
1 Reply 1

Zach Seils
Level 7
Level 7

‎07-16-2010 08:37 AM

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

0 Helpful
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Customers Also Viewed These Support Documents