Close

Powershell

Diskspd – SQLIO Replacement

Diskspd Utility application. This is a new robust storage Testing Tool (superseding SQLIO). “”A feature-rich and versatile storage testing tool, Diskspd  combines robust and granular IO workload definition with flexible runtime and output options, creating an ideal tool for synthetic storage subsystem testing and validation.”” Click here for the download link. Sample output from a […]

Read More

Powershell – Stopping a Microsoft Windows Service

In this example, l will attempt to get and stop a windows service for say, SQLdefragmanagementservice. First open a windows powershell console, using the run as administrator below. Use the get-process to get the process id. Use the stop-process to kill the windows process/service. Then run the code shown in the screenshot below, modify as […]

Read More

Powershell: Export Windows Server event logs to CSV

This powershell cmdlet  enables you to manage your windows server event logs, and it also enables you to get at the events found within those event logs. Simple basic code example to do this. Windows Server hostname is: SERVER1 Modify the logname as needed:  system, security, application etc. get-eventlog -logname system -computername SERVER1 -after ‘1/1/2014’ | […]

Read More