Reply
Fry
tkirk82
Posts: 2
Registered: 08-22-2007
0

SQL 2005 DB Mirroring

Hi Blanco,

Sounds like you could be on the money there! Appreciate your assistance.

Cheers,

Tim
Moderator
blancolam
Posts: 236
Registered: 03-28-2007
0

SQL 2005 DB Mirroring

Tim,

Based on your description of the problem, it seems like the data is either already compressed or encrypted.

I did a Google search and found the following article:

http://searchsqlserver.techtarget.com/tip/...1199004,00.html

During the setup of the mirroring process, there is this "Configuring Database Mirroring Security Wizard" and it also has the "Encrypt Data sent through this endpoint" checkbox. Based on the screenshots from the article, it seems the checkbox is checked by default meaning encryption is enabled. For the Steelhead to perform at its best, you'll need to ensure the data is neither compressed or encrypted. Try disabling that checkbox and see what happens.

Regards,

Blanco


Fry
tkirk82
Posts: 2
Registered: 08-22-2007
0

SQL 2005 DB Mirroring

Hi,

We're currently testing SQL 2005 DB Mirroring between our DC and a DR site. The destination TCP port used for DB Mirroring is 5022.

At present we seem to be getting little to no data reduction on this traffic (LAN - 21871318 KB/WAN - 22411832 KB) but the connections are showing as optimized. Does anyone know if we should be able to get data reduction on the DB mirroring traffic? Has anyone tested a simliar scenerio and had similiar results?

Appreciate any advice.

Cheers,

Tim
‬‪‬‪‬‪