Need powershell script to monitor sql server cpu hike and capture the top 10 cpu consuming queries.
I have 100+ servers, from the central server, if i could configure the powershell that runs on all 100 servers remotely every 10 minutes and capture the details in HTML format and send to my email id .Could any one help me to get the logic or script which
will help me lot.
This forum does not create PowerShell scripts for you, we help with specific issues with scripts. Please check the scripting request forum or the gallery. Or maybe even a Google?
What have you tried so far and what errors are you getting?
Edited byI.T DelinquentWednesday, January 31, 2018 12:21 PM