Tag: SQL

vSphere 6.0 Install Pt. 7: Config SQL DBs

Now that we have the Windows PSC installed, it is time to prepare for installing vCenter. vCenter can support three database types: embedded vPostGres (supports up to 20 hosts and 2000 VMs), Microsoft SQL, and Oracle. SQL seems to be the most popular choice, so that's what I'll help you...

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 2 of 3 1 2 3
Scroll to Top