VMware just released a killer whitepaper on how to optmize SQL 2008 performance for vCenter 4.0. It has quite a few details that I was not aware of and will result in changes to my production environment. Tips that were new to me included:- Optimizing the clustered index fill factor-...
Ok so I'm a bit tardy in this notification, but VMware released a new version of the Ethernet driver for the 10Gbps NIC that's in the HP BL490c G6 servers, and other brands as well. Technically the update is for Broadcom NetExtreme II BCM57710/BCM57711/BCM57711E NICs. In HP terms this is...
A co-worker of mine, Mark, turned me on to this company called QNAP. They make a really dizzying array of SOHO and small/medium business "NetApp" like NAS devices. These little babies support a wide range of protocols including iSCSI, NFS, CIFS, ftp, etc. It's really amazing what these critters can...
Last week I was listening to a HP video where the HP CTO said that Fibre Channel drives will cease to exist in the coming years. Instead, enterprise storage disk arrays will be configured with two tiers of storage: SSD and SATA. I thought for a minute, and this made...
Hot off the press! Last night VMware posted critical updates to vSphere 4.0. You can find the patches here. If you want to read the release notes, they are available here. Patches apply to both ESX and ESXi hosts.This does not appear to be Update 2, which was rumored to...
Back in January I wrote a blog about emerging Ethernet standards that are converging Ethernet, Fibre Channel and virtualization. During one of HP's recent tech days they had a session on all of these new standards, their ratification status, and how they will apply to HP products. Even if you...
This past weekend I worked on automating our SQL installs and scripting security lockdowns. During that effort I found the new policy evaluation tool in SQL 2008. This built-in tool allows you to run specific checks against your SQL 2008 installation to report on best practices. During my evaluation everything...
On servers that are running Windows server 2008 or later, you can take advantage of the built-in two-way firewall. SQL server firewall rules can be pretty easily created through the GUI, but it can be a bit tedious. So I wrote a little batch file that asks you for an IP...
I stumbled upon this technical note from VMware on how to install vCenter and the vSphere client silently via the command line. Unfortunately the syntax is pretty convoluted, unlike the SQL 2008 unattended method. The vCenter command line install document can be found here.Just to give you a flavor of...
After installing and re-installing VMware vCenter and VUM many times (mostly for testing) all of the manual database creation steps got old pretty fast. So I put some effort into creating a T-SQL script for SQL 2008 that automates most of the tasks.The T-SQL script below does the following:1. Adds...
This Powershell script creates a 32-bit system DSN on a 64-bit server. I got tired of manually creating DSNs for my VMware vCenter installations, so I automated the process. The only argument you need to pass to the script is the FQDN or IP address of your SQL server. If...
There is a feature/bug in the Windows Server 2008 R2 managed service account PowerShell command that limits the account name to 15 characters or less. First, let's create a managed service account called SVC_SQL01_LongName using PowerShell. The service account is 18 characters long. You can run the following command on...