As a small nugget of what I have covered so far have this little section of Powershell code:
Get-Process *sql* Select-Object name, CPU, virtualmemorysize
This will bring a list of processes on the local machine that have "sql" in their name, their CPU usage and the virtualmemory they are using.
Which for me tells me this:
Name | CPU | VirtualMemorySize |
---- | --- | ----------------- |
RedGate.SQLBackup.UI | 184.125 | 272957440 |
RedGate.SQLPrompt.TrayApp | 3.6875 | 187170816 |
SQL Response Client | 413.03125 | 223125504 |
SQLAGENT | 48.1875 | 138895360 |
sqlbrowser | 0.046875 | 14163968 |
sqlservr | 2198.96875 | 1570562048 |
neat huh?
No comments:
Post a Comment