We recently installed the SQL MP. One thing I am struggling with is this "Power Shell Script failed to run" that occasionally comes up, but, not always on the same server, and not always at the same time.
It says it ran past the configured timeout of 300 seconds.
The post that seemed to have me on the right track was
https://social.technet.microsoft.com/Forums/en-US/c539a55d-dd48-438f-b7d5-06ed2cecf6e9/powershell-script-failed-to-run-alerts-from-sql-management-pack-6410?forum=operationsmanagergeneral
However, even after getting one of the several scripts that have been generating the error, out of the extract management pack, it has parameters that need to be fed to it that I have no idea what they are....
Example. ActiveRequestsDataSource.ps1 requires $computername, $connectionstring, $tcpport, $sql_wmi_namespace, and $servicename.
The computername is easy enough... so is tcpport. but, the others... not so much.
I am fairly certain I will be able to run these manually, if I just knew the parameters... I am also fairly certain we are getting these because at the time of the check, resources on that server are tied up for one reason or another.
Can someone please help? This is killing me.