Category: SQL Server 2012

SQL 2012 Failover Cluster Pt. 10: Email & RAM

In this installment of the SQL 2012 failover cluster guide we are configuring two very important parameters: SQL server max memory and email alert notifications. Both settings are often overlooked, yet are critical to a properly performing and healthy SQL server cluster. Blog Series SQL 2012 Failover Cluster Pt. 1:...

SQL 2012 Failover Cluster Pt. 9: TempDB

One of the most important aspects of SQL performance is TempDB. Applications can use TempDB as a scratch space, and in most cases you should not rely on just a single TempDB file. Current best practices is to create 1/4-1/2 the number of TempDB files that you have processor cores....

SQL 2012 Failover Cluster Pt. 8: Firewall

I'm a big proponent of using the Windows firewall on all computers, be they clients or servers. It may not be perfect, but it's better than nothing. Layered defenses are key in the enterprise, so protecting each host may save your bacon some day. Many programs automatically add Windows firewall...

Page 1 of 2 1 2
Scroll to Top