http://richmondsql.org/cs2007/search/SearchResults.aspx?o=DateDescending&tag=mirror,comparative+analysis,round+table&orTags=0Search results matching tags 'mirror', 'comparative analysis', and 'round table'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>