I have been working recently in making sure that max memory is configured for the hundred plus database servers I support. In reading numerous books, blog post and attending various talks on memory management people reference the OS memory counter “Available Mbytes” a lot. Various references state that this value should be between 150 and […]
Category: PowerShell
Cannot create Cluster – the computer X is joined to a cluster
Recently attempting to install a new three node cluster I ran into a new issue. Once I was able to run a successful “Cluster Validation Check” and chose the option to install a new cluster I received a message “The computer xxx is joined to a cluster”. My first thought then was to […]
Collect Database File Size with Powershell
I decided to start monitoring the amount of free space in my database files so that I can make sure all my databases are set to auto grow by the right amount and to monitor the amount of free space so I can schedule the expansion of the files rather than let them auto grow. […]
Get count of folders using Power Shell
More on my recent PowerShell project. I recon I have taken on the challenge to handle this entire request using Posh. It started out just moving folders based on the folder name that included the date in format MMDDYY. Next was having to stop services before moving the folders. After that came a request to […]
Starting and Stopping a Remote Service with PowerShell
A recent project I was working on required me to move folders from a staging location to a processing location. I found that PowerShell was the easiest way to accomplish that. After getting that part of the project working a new requirement came up. In order to move the folders I needed to stop an […]
My first PowerShell Script to Move Folders
I just had my first encounter with having to write a PowerShell script. The request seemed pretty harmless when I originally got it. The request was much like others I had gotten in the past where I needed to check to make sure that data had been loaded and kick off another process. In the […]