-
Re: Intermittent Slowdowns in Web Console
jamesatloop1 Sep 13, 2016 8:01 AM (in response to bharris)Did you do a migration? Did you upgrade the netflow storage before upgrading the application?
-
Re: Intermittent Slowdowns in Web Console
bharris Sep 13, 2016 9:05 AM (in response to jamesatloop1)No, we performed the migration from SQL to the Flow Storage DB last August. Yes, I ran the upgrade on the Flow Database first and then updated the Primary Poller and the APEs.
-
-
Re: Intermittent Slowdowns in Web Console
jamesatloop1 Sep 13, 2016 9:27 AM (in response to bharris)Ok, when was the last time maintenance on the nta storage was completed?
-
Re: Intermittent Slowdowns in Web Console
bharris Sep 13, 2016 11:24 AM (in response to jamesatloop1)It runs daily and has run every day since the upgrade.
-
Re: Intermittent Slowdowns in Web Console
jkrenzien Sep 13, 2016 2:31 PM (in response to bharris)I have had a similar issue recently. For me it turned out that the daily maintenance wasn't enough and I had to have our DBA rebuild the index (based on support's recommendation). It has been performing better since then and the indexes aren't out of control yet. I currently planning on doing that 1-2 times a year.
-
Re: Intermittent Slowdowns in Web Console
bharris Sep 13, 2016 2:57 PM (in response to jkrenzien)Is this on the Orion DB or the Flow Database?
-
Re: Intermittent Slowdowns in Web Console
jkrenzien Sep 16, 2016 12:27 PM (in response to bharris)This was on the Orion DB
-
-
-
-
-
Re: Intermittent Slowdowns in Web Console
jamesatloop1 Sep 14, 2016 4:16 AM (in response to bharris)The flow database. I would also check the orion database as the website files are located there.
-
Re: Intermittent Slowdowns in Web Console
bharris Sep 16, 2016 9:43 AM (in response to bharris)I was working to add a new alert rule this morning and I randomly am getting "Cannot Load Trigger Condition". I refresh a few times and then it works. Any ideas?
-
Re: Intermittent Slowdowns in Web Console
jamesatloop1 Sep 22, 2016 2:01 AM (in response to bharris)-
Re: Intermittent Slowdowns in Web Console
jkrenzien Sep 22, 2016 10:12 AM (in response to jamesatloop1)jamesatloop1 - after i rebuilt my indexes with sql scripts I found here on thwack, SolarWind's YouTube and some research trying to verify that I wouldn't kill my database with those scripts my performance increase and has become much more stable.
-
Re: Intermittent Slowdowns in Web Console
bharris Sep 22, 2016 10:27 AM (in response to jamesatloop1)2 of 2 people found this helpfuljamesatloop1 - We had maintenance on our SQL Servers last night and after they came back up the slowdowns and error messages in resources are gone. I wonder if there was something hosed up on the SQL server and a restart of the services fixed it.
-
-
Re: Intermittent Slowdowns in Web Console
jamesatloop1 Sep 23, 2016 6:40 AM (in response to bharris)1 of 1 people found this helpfulYour database was probably heavily fragmented id say. Having resource errors on the website is usually database or under resourcing.
-
Re: Intermittent Slowdowns in Web Console
jxchappell Sep 23, 2016 10:03 AM (in response to bharris)So we have been truncating tables to fix the issue...watching the swmaintenance log on the main poller and seeing which table it gets stuck on during maintenance is the only way to do this...after we truncate it has made it through, however the same issue occurred 7 days later
This maintenance is a good indicator as to the health of the system, also I would recommend turning on the automatic defragmentation of the database during maintenance...its a 0/1 bit in the Settings table...
DB Maintenance should only take an hour at most...if its longer there is an issue with a particular table...the InterfaceAvailability_Details table is most liely the culprit but you'll have to verify on your own DB
We are doing another Truncate tonight and seeing how it goes, I have been wondering if there is a relationship between the DB Maintenance and the Interface Baseline job, but I won't find out until 7 days of data is collected again