Tuesday, 10 December 2013

Bit of PowerShell

PowerShell is becoming more and more useful in our world.

In later weeks, I will go into how I have used powershell to enhance my SQL performance knowledge.

For now a quick script to that will give you information on the processors in your SQL server.  Always handy to know the server guys have given you the box you where promised.

$property = "systemname","maxclockspeed","addressWidth",

            "numberOfCores", "NumberOfLogicalProcessors"

Get-WmiObject -class win32_processor -Property  $property |

Select-Object -Property $property