The most recent content from our members.
How can we create an alert for this database maintenance check SELECT TOLOCAL(EventTime) AS LocalEventTime, Message, EventType FROM Orion.Events Where Message LIKE '%Starting Nightly Maintenance%' OR Message LIKE '%Nightly maintenance failed%' OR Message LIKE '%Nightly Maintenance Completed%' Order by EventTime DESC
We recently updated to 2022.4.1, and have started to get Database Maintenance errors. - 2023-02-20 03:15:02 : Retention interval settings not specified... - 2023-02-20 03:15:04 : Retention interval settings not specified... - 2023-02-20 03:15:07 : Retention interval settings not specified... - 2023-02-20 03:15:08 :…
Hi, I am seeing error under db maintenance log file as below. Can anyone please assist here? ERROR SolarWinds.Data.DatabaseMaintenance.StandardTableHandlerDAL - Failed to execute procedure: dbm_VolumeUsage_DetailToStatistics System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error for type smallint, value…
Hello, I have recently started using SAM (and especially AppInsight) to complement the monitoring of SQL instances that we do with Database Performance Analyser. One resource that I would like to add to a view is a list of failed SQL agent job for all SQL instances that have the AppInsight template applied to. I know I can…
Think you’re too busy to regularly maintain your database? You might want to think about that again. As different users access the database, files can become fragmented, misplaced, and degraded. Security may become an issue. As a result, the database can become painfully slow or even corrupted. Running maintenance on your…
Good afternoon, I'm trying to set up a scheduled task to run database-maint.exe. What parameters do I need to get it to start from the command line? I verified the archive time in Polling Settings doesn't conflict with scheduled tasks, and even switched the time to test it. I checked…
Im wondering if the follow message have any kind of solution. 2014-02-06 02:15:45,236 [1] INFO SolarWinds.Data.DatabaseMaintenance.StandardTableHandlerDAL - SQL script message:Warning: Null value is eliminated by an aggregate or other SET operation. Colud be an error on SQL, just Warning Message or what mean? 2014-02-06…
Hi, We are having an excessive growth of the database. Particularly the table "APM_PortEvidence_Daily" with 44 million records and APM_PortEvidence_Hourly 28 million records are the main ones. It also calls the attention of these tables is the "Daily" and not "Hourly" which has more records. Is there some configuration or…
Hi, We recently upgraded Solarwinds NPM 9.1 to 10.1.2 successfully 2 days back. I also took full DB Backup after upgradation. Today I again took full backup after doing some changes and it was showing me backup size from 10 GB (Last Backup) to 4 GB (Current). I start checking all and found that now the new defaul polling…
I was wondering if anyone has had any experience with performing a partial database restore from a backup. When upgrading from 9.5 to 10.1.2 the retention settings were reverted to the Orion default of 7/30/60 and we lost our years worth of data. I'm embarrased to say how long it took to notice the data was missing, but we…
It looks like you're new here. Sign in or register to get started.