KB3000850–November Rollup 2014

3000850 is a recommended rollup for failover clusters. beside few others a lot of fixes around Hyper-V and Clustering are included. A cumulative update that includes the security updates and nonsecurity updates including Failover Clustering updates that were released between April 2014 and November 2014. Available from Windows Update and for individual download from Download…


Powershell-Generate Automated CSVFreespace and Memory Report

This script relies the Hyper-V clusters are been managed by VMM but if you do not use VMM you can also modify based on your environment. It should just give you an idea how to collect data and use sentmail function to get a daily report of your resource status. Note: script version 1.3 is…


best practices for running AV on SQL servers

Running Antivirus software is critical part of server security but it is also important to understand the impact and effect it has on SQL Server. here is some really good guidance on how to configure AV and exclusions. 1. SQL Server Data Files (files with extensions like .MDF, .NDF) 2. SQL Server Log Files (files…


Powershell–How to monitor HP Smartarray disk status?

really a quick one and straight forward but sometimes very useful. here is a quick example how you can monitor your smartarray controller disk status and in case of “Failed” drive detected sent a mail out to you with the summary. Of course, SCOM has also automated capabilities to monitor HP hardware components in a…

2

Powershell-How to easily verify patch level between computers

Compare patches between computers? Here is a quick and easy way how you can verify this with Powershell $node1 = Get-HotFix -ComputerName SERVER1 $node2 = Get-HotFix -ComputerName SERVER2 Compare-Object -ReferenceObject $node1 -DifferenceObject $node2 -Property HotFixID Example Output: HotFixID                                                    SideIndicator ——–                                                    ————- KB2862152                                                   => KB2876331                                                   => KB2884846                                                   <= KB2892074                                                   <= KB2894029                                                   => The Compare-Object cmdlet compares…


Powershell – How to get total VM memory overview (dynamic, static and startup memory) per node in a cluster?

Host Memory Pressure – I think this is one of the keys (in addition to storage, network, CPU) in performance when running virtualization with dynamic memory and should be monitored. An balance between high density of running VMs on a host and memory calculation/demand is something to consider when managing self service clouds and/or running…


Failover Cluster – Recommended hotfixes and updates for Windows Server 2012 RTM and R2 based clusters

Checkout KB2920151 for getting a comprehensive list of the recommended hotfixes and updates for clusters based on Windows Server 2012 R2 http://support.microsoft.com/kb/2920151/en-us + Checkout Rollup Update June which includes several Hyper-V and Cluster relevant patches too. http://support.microsoft.com/kb/2962409/en-us Same exists for Windows 2012 RTM based clusters too http://support.microsoft.com/kb/2784261/en-us Also take a look at the Cluster-Aware Updating…


How to configure Preferred Owners and AutoFailback with Powershell in Failover Cluster?

Consider scenario, you “balanced” your VMs across your nodes and you come back in the morning and they are migrated “for whatever reason” to different nodes. But as a typical administrator 😉 you know your workload best and you want to keep them preferred on a targeted node. In case of an unexpected reboot the…