I am planning to build new MS SQL environment and I need help suggestions what the specs of the physicals servers should be as well as storage.
I am planning to use MS SQL 2012 with two node failover cluster and external storage (SAN, NAS, etc.)
I am looking for High availability and Performance .
In current MS SQL 2008 r2 environment we have huge Data Bases that are heavily use everyday 24/7. Over 2000 internal users are accessing data bases. Over 200 developers constantly are working and running queries.
I am looking for Windows Server 2012: Building a Two-Node Failover Cluster with High availability and Performance
Can anyone help to create MS SQL system specs that are reliable with great performance and with reliable storage that would work well with clustering.
Since every environment is different, I recommend that you first take a look at the following Microsoft documentation specific to SQL Server 2012. It should provide you with a good general
Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
This is an issue that we can get adding / removing permissions in the vCSA 6.0. We can also have issues searching for users / groups in the AD (using your identify sources). This is how one of the ways to handle this issues and fix it.