So here we are, at the end of a somewhat long journey. Yes, this is the last installment in the SQL 2012 Failover cluster series. However, two very important settings are configured. The first is Kerberos, which is the preferred authentication protocol (vice NTLM). In fact, some software will break...
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....
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...
Yes, we are finally at Part 7 of the SQL 2012 failover cluster install. Now that your first node is healthy, we can join the second node to the cluster. The installer process is fairly different, since it will detect your existing cluster and ask you far fewer questions. It...
This is Part 6 of the SQL failover cluster installation, where we finally get to install the SQL Server database engine and related tools. It's been a tedious road, and you likely ran into some cluster creation issues. This is not for the faint of heart, and should not be...
This is Part 5 of the SQL 2012 failover clustering series where we setup two service accounts. One is for the database engine and the other is for the SQL agent. In order for Kerberos to work properly, and for the cluster to work at all, they must be Active Directory...
This is part four of the SQL 2012 failover cluster installation series. In this installment we will create the Microsoft cluster and add the storage resources. If you are using two VM NICs then we will also tweak their configuration. While this process is fairly straight forward, it can be...
This is Part 3 of the SQL 2012 failover clustering series we will configure the required LUNs and iSCSI components, so that Windows Server 2012 can mount the shared LUNs. As I mentioned before, I'm choosing to do in-guest iSCSI for the shared LUNs vice RDMs. RDMs are acceptable as well, and...
This series of posts will show you how to configure SQL 2012 on VMware using a Microsoft failover cluster. Now that VMware vSphere 5.5 is out, I'm excited that VMware finally got on board with officially supporting clustering the vCenter database. However, their only official clustering option they support is what...
Twitter #VAPP5932; Presenter:Â Scott Salyer (VMware) This session was focused on the various Microsoft SQL server high availability options and how they mesh with vSphere and its HA options. Unlike Exchange 2013, SQL 2012 has several HA architectures to choose from. Some applications may only support one or two SQL HA...
In Part 1 of this short series of configuring Windows Server 2012 SMB transparent failover we configured two VMs using the vSphere 5.1 web client to access shared RDMs. Then mounted and formatted on one node with a 16KB allocation size, to better optimize shadow copies for share folder performance. Now that...
Windows Server 2012 is Microsoft's biggest server OS release since Windows 2000. The number of features, enhancements, and optimizations is mind boggling. One major area of focus was SMB, which is Server Message Block. SMB is the protocol used to access file shares across the network. SMB 3.0 was introduced with...