SQL Server Performance

SQL Server Functionality

Discussion in 'EditorsBlog' started by shanetasker, Sep 4, 2008.

  1. shanetasker New Member

    A common complaint with SQL Server is that there are many features that perform very similar functionality but do not address the particular need 100%. For example, database mirroring provides a great solution for database availability; however, it does not provide instance level recovery and it does not allow data to be read from the mirror instance. One of the most frequently requested features for high availability (HA) solutions is the ability to use a fail-over instance for reporting or other read-only operations. Although there are ways to achieve this, there is no seamless process. Database mirroring is the perfect candidate to provide this functionality; however, the current release does not support it. What SQL Server technologies are you using to achieve HA while providing a read-only node?
    - Peter Ward
  2. zzzbla New Member

    Hi Peter,Mirroring is only good for HA + read-only node if the customer is willing to buy 2 enterprise edition licenses - which leaves you with either log shipping or replication. Log shipping allows reading data any time you don't restore logs. With SQL Server 2005 replication you can have many read-only subscribers and if you do it right, you can use it for high availability/disaster recovery as well (make sure to mark all constraints, triggers and identity columns as NOT FOR REPLICATION).Since mirroring with database snapshots is the most expensive solution, I've implemented more of the latter two and these solutions work great.

Share This Page