5 Replies Latest reply on Jun 3, 2008 8:54 AM by Mike C

    Resources taxed on main poller

    Mike C

      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.

        • Re: Resources taxed on main poller
          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?


            • Re: Resources taxed on main poller
              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.

                • Re: Resources taxed on main poller
                  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.

                    • Re: Resources taxed on main poller
                      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.

                      • Re: Resources taxed on main poller
                        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?