http://richmondsql.org/cs2007/search/SearchResults.aspx?o=DateDescending&tag=mirror,cluster&orTags=0Search results matching tags 'mirror' and 'cluster'en-USCommunityServer 2007.1 (Build: 20917.1142)http://richmondsql.org/cs2007/forums/p/18/20.aspx#20Fri, 21 Mar 2008 14:52:06 GMT2e8a3759-4cfd-4c9f-8103-2483fc393c1e:20fibrock<span style="FONT-SIZE:10pt;COLOR:black;FONT-FAMILY:&#39;Arial&#39;,&#39;sans-serif&#39;;">I like the idea of a round table on this topic, because not many of us have a lot of experience with clustering and or mirroring.&nbsp; Currently we use both Clustering and Mirroring for our production environments.&nbsp; Clustering has given us more of a headache than Mirroring due to some SAN management issues with presentation of disk to the cluster and the ID&#39;s that the OS is assigning these disks.&nbsp; We have worked these issues out with our SAN team and they are no longer an issue but we switched to Mirroring for a few of applications because of this.&nbsp; We have not had any significant issues with mirroring, which is running on an OLTP database that controls a pricing system.&nbsp; While this is an OLTP system it does have a low level of transactions.&nbsp; We run without a witness and therefore without automatic fail over, in the high performance asynchronous mode.&nbsp; The reason for this is so we do not get any false system failovers, and our applications cannot take advantage of the newer SQL Server OLEDB drivers to allow for automatic failover.</span><span style="FONT-SIZE:10pt;COLOR:black;FONT-FAMILY:&#39;Arial&#39;,&#39;sans-serif&#39;;">I like the idea of a few round table meetings a year in general.</span> <p>&nbsp;</p>http://richmondsql.org/cs2007/forums/p/18/19.aspx#19Fri, 21 Mar 2008 13:33:51 GMT2e8a3759-4cfd-4c9f-8103-2483fc393c1e:19wkhazzard<p><font face="courier new,courier">I&#39;d like to hear the thoughts of other DBAs and Architects who&#39;ve used both SQL Mirroring and SQL Clustering. My company, SnagAJob.com, is currently using SQL Mirroring for our production OLTP databases. We have issues almost every day: mysterious failovers, ADO.NET clients that repeatedly attempt to connect to the mirrored server instead of the primary (because they believe it&#39;s failed over). We&#39;re fairly certain that it&#39;s not networking issues because we see these same issues in our lab environment when everything is connected on a single gigabit switch. This would be a great topic for a future meeting, in my opinion, especially as more of a round-table type of discussion.</font></p>