Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Why does the SQL server agent use XPCommandShell for monitoring the server?
Description
Why would Foglight be using XPCommandShell for monitoring the server?
Cause
The SQL Server agent uses xp_cmdshell for two collections:
DBSS_Cluster_Summary
DBSS_Config_Suggestions
For the cluster summary, the rule seems to check the status of the cluster For the Config Suggestions, it seems to use the command to look for services that aren't essential for SQL Server, like Clip Book, Computer Browser, Messenger, Network DDE, Task Scheduler, and Schedule Service.
Cluster data can be collected only if the xp_cmdshell parameter is configured.
To configure this parameter, run the following commands:
EXEC sp_configure ‘show advanced options’,1
GO
--To update the currently configured value for advanced options.
RECONFIGURE
GO
—- To enable the feature.
EXEC sp_configure ‘xp_cmdshell’, 1
GO
—- To update the currently configured value for this feature.
RECONFIGURE
GO
Resolution
Users can disable the DBSS_Cluster_Summary collection to prevent xp_cmdshell from being used. Details on disabling a collection can be found in KB 120521 located here.
The DBSS_Config_Suggestions sql that is the other source of the xp_cmdshell is of an RMI type, meaning that it runs only by demand – when the user enters the Configuration screen explicitly. RMI type collections is not controllable by the user.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.