SQL Server Performance

Witness Server Requirements

Discussion in 'SQL Server 2005 Database Mirroring' started by ssteckley, Jun 21, 2006.

  1. ssteckley New Member

    I already read that the witness server only needs to have SQL Express installed and should be the same OS as the other servers. However, what are the requirements on the server itself: memory, hard drive space, etc.? Is anything really stored on the witness server or can it be a pretty basic server (or even pc)?

    Thanks in advance.
    ss
  2. ssteckley New Member

  3. satya Moderator

    I have install Witness box with SQLExpress with a 1gb memory and 64 gb machine which is running without any problems. I would suggest to use server and not a desktop PC as it may lead to other problems in the future if 3 are not on same subnet.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  4. ssteckley New Member

    quote:Originally posted by satya

    I have install Witness box with SQLExpress with a 1gb memory and 64 gb machine which is running without any problems. I would suggest to use server and not a desktop PC as it may lead to other problems in the future if 3 are not on same subnet.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

    In regard to you last comment, must all 3 servers be on the same subnet?

Share This Page