When we deploy a SQL Server Always-On, we MUST create the user logins manually to the secondary replica. This happens because SQL server keeps logins in the Master database which is not syncing. To overcome this problem we need to run some SQL scripts in a certain...
SQL Server: Failover Clustering and Always On Availability Groups Before we start to configure SQL Server always On, you need to make sure that you have: One Domain Controller Two Database Servers A Storage that will play the File Share Witness (Witness Quorum) All...
By following the next steps you are able to create storage pools for a SQL Server installation. Storage Pool Best Practices Column Size = Number Of Disks In The Storage Pool, example 2 Disks = Column Size 2 Interleave = For OLTP Best is 256KB , For TSQL Best is 64K...