question

rsherron avatar image
rsherron asked

Does witness server sizing for SQL 2014 need to be the same size as the mirrored servers

I am getting an environment setup to host a mirrored database using a with a witness server. I am running the mirrored servers in the cloud with multiple drives for the database files with quad processors and 16 GB RAM. Does my witness server need to match this, or can I just spin up a smaller server with 2 drives? In reading the MSFT recommendations they indicate we should use the same hardware, but my witness server is only being setup to serve as the witness for one database on the pair of SQL Servers. If it does need to match the hardware of the 2 mirrored servers, can someone explain why so I can talk to my infrastructure team? Thanks for the help
sql2014witness
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
The witness server only really supports a process called automatic failover - it does this by adding a 'vote' to a quorum - having a witness between 2 mirrored servers allows for a majority vote to happen. It only needs to be the minimum requirement spec for the standard version (Express will work but MS recommend Standard ( http://msdn.microsoft.com/en-gb/library/ms175191.aspx) ) of SQL Server you are running, which for SQL2014 is : - 1GB RAM - 1 1GHZ processor - 6GB HDD (Although admittedly this would be a very slow SQL Server :) ) Full details : http://msdn.microsoft.com/en-gb/library/ms143506.aspx
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

rsherron avatar image rsherron commented ·
Thanks for confirming my thoughts on the witness server.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.