Troubleshooting high memory utilization on servers involves finding out processes which are consuming RAM. But default methods like Task Manager, or Get-Process cmdlet of PowerShell are difficult to read and filter due to lot of information at thread level.
So, I have created cmdlet
Get-ProcessForDBA in my
SQLDBATools PowerShell module. This cmdlet displays ComputerName, ProcessId, ProcessName, Description, StartTime, Threads, Memory(MB), Path, Company, Product for all processes of Server name(s) passed as parameter. One can find latest code for SQLDBATools module on below url:-
I am Microsoft Certified Professional having 10+ years of experience in SQL Server Querying, Database Design, and Administration. I am fond of Query Tuning and like to automate things using TSQL & PowerShell. I also have experience of implementing end-to-end Data Warehouse solution, and Data Migration using ETL tools SQL Server Integration Services (SSIS), Pentaho Business Analytics, and have designed Database Inventory through PowerShell, Python, and Django etc.