Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Resources taxed on main poller

I am running a config of 1 main poller, 2 addtional polles and a seperate SQL DB. All 4 servers are running onVM's Has anyone run into this. My web seems to be running very slow lately after initially running fine for several weeks after migration to VM's.

Find more posts tagged with

Accepted answers

All comments

rcahill

My Orion environment is not on vm; however after upgrading from version 8.5.0 to 8.5.1 SP3, "everything" seems to be taxed. Did you upgrade with the P2V?

Mike_C

We were running on SP3 before we migrated to VM's, and we have been running fine even after adding APM and NPM on it. Just recently seems to have degraded in performance.

Network_Guru

This may be due to a website issue. I just happened to check my OrionNPMWeb.trace file located here - C:\Program Files\SolarWinds\Orion
It is fraught with these errors (open this with wordpad):

2332   Jun-02 15:35:00 :    Error = Incorrect syntax near the keyword 'WHERE'.
2332   Jun-02 15:35:04 :    SQL = SELECT TOP 1 Percentile FROM (SELECT TOP 5 PERCENT AVG(RawStatus) AS Percentile From WHERE (DateTime >= 39592 AND DateTime <= 39599.6666666667) GROUP BY FLOOR(CAST(DateTime AS float) * 288) ORDER BY AVG(RawStatus) DESC) DERIVEDTBL ORDER BY Percentile
2332   Jun-02 15:35:04 :    Error #= -2147217900
2332   Jun-02 15:35:04 :    Error = Incorrect syntax near the keyword 'WHERE'.
2332   Jun-02 15:36:57 :    SQL = SELECT TOP 1 Percentile FROM (SELECT TOP 5 PERCENT AVG(RawStatus) AS Percentile From WHERE (DateTime >= 39599 AND DateTime <= 39599.6666666667) GROUP BY FLOOR(CAST(DateTime AS float) * 288) ORDER BY AVG(RawStatus) DESC) DERIVEDTBL ORDER BY Percentile
2332   Jun-02 15:36:57 :    Error #= -2147217900
2332   Jun-02 15:36:57 :    Error = Incorrect syntax near the keyword 'WHERE'.
2332   Jun-02 15:43:05 :    SQL = SELECT TOP 1 Percentile FROM (SELECT TOP 5 PERCENT AVG(RawStatus) AS Percentile From WHERE (DateTime >= 39599 AND DateTime <= 39599.6666666667) GROUP BY FLOOR(CAST(DateTime AS float) * 288) ORDER BY AVG(RawStatus) DESC) DERIVEDTBL ORDER BY Percentile
2332   Jun-02 15:43:05 :    Error #= -2147217900
2332   Jun-02 15:43:05 :    Error = Incorrect syntax near the keyword 'WHERE'.

I have no idea which web page or report is causing this, but I'm sure this must be slowing down the website.
This started on April 14th and seems to occur each time the page refreshes.

rcahill

Same type of information is being collected in my trace file.

SQL = SELECT TOP 1 Percentile
FROM (SELECT TOP 5 PERCENT AVG(RawStatus) AS Percentile
From WHERE (DateTime >= 39564 AND DateTime <= 39595)
GROUP BY FLOOR(CAST(DateTime AS float) * 288)
ORDER BY AVG(RawStatus) DESC) DERIVEDTBL ORDER BY Percentile

Error #= -2147217900
Error = Incorrect syntax near the keyword 'WHERE'.

Could this be part of a "Top 10" Web listing?

This is not occuring frequently enough to impact the entire website.

Mike_C

I have the same errors in my file:

932 May-27 16:01:27 :    Error = Invalid column name 'OutPercentUtil'.
5932 May-27 16:01:28 :    SQL = SELECT TOP 1 Percentile FROM (SELECT TOP 1 PERCENT AVG(InPercentUtil) AS Percentile From InterfaceTraffic WHERE (DateTime >= 39593 AND DateTime <= 39593.7083333333) GROUP BY FLOOR(CAST(DateTime AS float) * 288) ORDER BY AVG(InPercentUtil) DESC) DERIVEDTBL ORDER BY Percentile
5932 May-27 16:01:28 :    Error #= -2147217900
5932 May-27 16:01:28 :    Error = Invalid column name 'InPercentUtil'.
5932 May-27 16:01:29 :    SQL = SELECT TOP 1 Percentile FROM (SELECT TOP 1 PERCENT AVG(OutPercentUtil) AS Percentile From InterfaceTraffic WHERE (DateTime >= 39593 AND DateTime <= 39593.7083333333) GROUP BY FLOOR(CAST(DateTime AS float) * 288) ORDER BY AVG(OutPercentUtil) DESC) DERIVEDTBL ORDER BY Percentile
5932 May-27 16:01:29 :    Error #= -2147217900
5932 May-27 16:01:29 :    Error = Invalid column name 'OutPercentUtil'.

Can anyone from SW tell us what is causing this?