SQL Server Performance

database mirroring 2 servers

Discussion in 'SQL Server 2005 Database Mirroring' started by alexboy456, Mar 30, 2007.

  1. alexboy456 New Member

    Sorry about this question but I am new to SQL. I am looking at getting a SQL server to run sage 200. it will be serving 20 – 25 users. the server will be a DL385 g2 with duel Opteron 2.8ghz 8gb ram 6*72gb 15k SAS drives(2 drives raid 1+0 and the rest raid 5). The database I am guessing will be no more than 8gb. Software windows server 2003 enterprise and SQl 2005 standard (both 32bit unfortunately as sage don#%92t support 64bit). We will hopefully at some point be putting in a second small sql server for some access control software as well. We are putting in a second small server so that the sage has full reign of the server. Would I be able to setup database mirroring on the second server for the sage server in case of failure?

    I apologise in advanced if this is a stupid question
  2. MohammedU New Member

  3. alexboy456 New Member

    is there a performance hit on the mail server when the mirroring is setup. i would likt to set this up for redundency and online backup
  4. satya Moderator

    Nothing official I know about the performance loss, but you have to ensure that the databases queris that are involved are optimized fora better performance.
    For the sake of disaster recovery ensure that the principal and mirror have similar configuration, do not use high performance mode and only take over with a manual failover, in my experience.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page