June 14, 2010 at 12:09 pm
Brandie Tarvin (6/14/2010)
Are your servers within the same domain and both inside the firewall?If not, is your firewall open to the ports being used in the mirroring?
Both servers are in same domain.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 15, 2010 at 2:42 am
This is all very interesting to me. We have two seperate a/p clusters and then two seperate dr servers for the clusters. The clusters (noth nodes) are on site and the dr's are off site at a scf but on the same domain.
We use sql 2005 ent 64-bit and mirror the critical databases to the scf. We dont use a witness due to the relative unreliability of the wan link. So i dont really have experience of this but its good to know.
Robert, are there any big changes in mirroring from 2k5 to 2k8? We are planning on moving within the next year and currently rely quite heavily on mirroring for a few servers.
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 15, 2010 at 8:16 am
Yes, there were improvements in mirroring from 2k5 to 2k8.
Mirroring takes advantage of compression and the transactions are compressed before sending across the network improving throughput.
The way mirroring uses the log buffers are improved resulting in better throughput.
10 new performance counters were added for improved monitoring of mirroring.
Mirrored databases that experience a torn page can recover from the incident automatically by pulling the complete page from the other partner.
June 15, 2010 at 8:24 am
And is this all handled behind the scenes with no additional setup and maintenance overhead?
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 15, 2010 at 9:42 am
Yes, as far as setup goes, nothing has changed.
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply