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
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
No comments:
Post a Comment
Your views:-