You don't need Powershell for this. Google for Brent Ozar's "sp_Blitz" and Adam Machanic's "sp_WhoIsActive".
Just remember... if you can't write it, you might not be able to maintain it.
--Jeff Moden
Change is inevitable... Change for the better is not.