Getting the following error from the CPUUsagePercent2008DataSource.ps1 script.
Forced to terminate the following PowerShell script because it ran past the configured timeout 200 seconds.
Script Name: CPUUsagePercent2008DataSource.ps1
One or more workflows were affected by this.
Workflow name: Microsoft.SQLServer.2008.DBEngine.ThreadCountMonitor
Instance name: SQL04
Instance ID: {2D0CD689-A50C-D19D-91E9-B53AE93545CA}
Management group: SCOM_AGPWS
Managed to locate the script inside the Microsoft.SQLServer.2008.Monitoring management pack. Unfortunately I found out that the script requires the following input paramaters.
param($computerName, $SQL_WMI_NAMESPACE, $serviceName, $sqlInstanceName, $connectionString, $tcpPort, $instanceId)
I have managed to deduce some of the parameters such as $computerName, $sqlInstanceName and $instanceId by looking through the logs on the machine. At this stage I haven't figured out $SQL_WMI_NAMESPACE, $tcpPort, $connectionString and $serviceName I was
hoping to run the script stand alone to figure out why it was timing out. Is there anyway that you can deduce what these input parameters my be? Have don a through seach of all the windows logs.
