I monitor only a few MS SQL instances but one of them contains about a dozen databases including the Solarwinds db. Unfortunately it is the Solarwinds database that sports the #1 query in terms of total time execution. I take it that it is the polling query? Is there a way to turn the frequency of that execution down.? Should I exclude the Solarwinds db from the monitoring activity? Should I move it to another instance on its own (and how difficult would that be)? It would make the monitoring of the remaining databases more meaningful if Solarwinds weren't spiking all the value up.
I'm a newbie at DPA and Solarwinds so some of the documentation is painful to read considering the myriad of elements that can be monitored. Any help appreciated. I've included the SQL below should anyone recognize it.
Thanks,
/* (inserted by DPA)
Procedure: SolarWinds12.dbo.sw_GetSettingsCurrentValue
Character Range: 137 to 224
Waiting on statement:
SELECT @Result = CurrentValue FROM dbo.[Settings] WHERE RTRIM(SettingID) = @SettingID
*/
CREATE
FUNCTION [dbo].[sw_GetSettingsCurrentValue]
(
@SettingID varchar(250)
)
RETURNS real
AS
BEGIN
DECLARE
@Result real
/* BEGIN ACTIVE SECTION (inserted by DPA) */
SELECT @Result = CurrentValue FROM dbo.[Settings] WHERE RTRIM(SettingID) = @SettingID
/* END ACTIVE SECTION (inserted by DPA) */
RETURN @Result
END