Setting Up Database Mirroring on Sql Server 2008

Posted by Sqltimes
On October 7, 2011
0 Comments

Following are the steps that I follow to set up DB Mirroring between Sql Server 2008 databases on separate servers. Overview: Create Sample Database for Mirroring on Principal Server Create some database objects in the database to test i.e. tables, stored procedures, etc Create Database Mirroring EndPoints on Principal, Mirror and Witness CREATE necessary accounts […]

Posted by Sqltimes
On October 1, 2011
0 Comments

When designing VLDBs for large transactional volume, I keep these design techniques for better scalability and performance. Details on each of these points will come in future. Processor related: MAX DEGREE OF PARALLELISM and MAXDOP COST THRESHOLD FOR PARALLELISM Soft-NUMA Memory /PAE, /AWE, /3GB (not needed for 32 bit machines) Lock Pages in Memory MAX/MIN […]

Setting Up Database Mirroring on Sql Server 2008

Scalability and Performance design techniques for high transactional volume, VLDBs