Delete hidden vNIC, the Eric Siebert wayPosted: July 25, 2012 Filed under: VMware, Windows | Tags: delete hidden device, ghost e1000, hidden, hidden device, hidden e1000, hidden NIC, hidden vNIC, uninstall ghost NIC, uninstall hidden, uninstall hidden device, vNIC Leave a comment
A funny thing happened this afternoon. Usually, when you know there’s a hidden NIC in a VM, you simply run the command, set devmgr_show_nonpresent_devices=1. Then you’ll see the hidden device in Device Manager. Well that didn’t happen to me.
The virtual hardware showed an e1000 vNIC installed in this VM, but no icon showed up in Network Connections.
Performance Analysis for a SQL ClusterPosted: July 23, 2012 Filed under: SQL Server, Windows | Tags: analysis, cluster metrics, cluster performance, metrics, performance, performance analysis, sql, sql cluster, sql cluster metrics, sql cluster performance, sql metrics, sql performance 5 Comments
I was recently asked to pull the performance metrics for a new SQL cluster at work. In an effort to finally get back to blogging, I thought I’d share my results and how someone else may be able to look at their clusters for ways to improve. I should start by saying that although this analysis was performed on a two-node Windows Server Failover Cluster using Windows Server 2008 R2 x64 (WSFC, formerly MSCS) and SQL Server 2008, SQL-specific metrics are not pulled. Rather, I looked at the Big Four: CPU, Memory, Disk, and Network. The second node in the cluster, Node B, was analyzed because the application using the first node was not in production yet, so we knew that node would barely be utilized.
Using Microsoft System Center Operations Manager (a behemoth in its own right!), I was able to pull the previous six days’ worth of performance data. What I included in my analysis were graphs of performance for seven days, an explanation of what the data was measuring, and somewhat of an average baseline against which to measure.
The original work was presented in PowerPoint. I’ve taken screenshots of the presentation and included them here.