Hi
My solarwinds Database manager is showing Response Time_Detail cosuming 1.3 GB. I want to truncate this table and shrink Database.
Any cons of doing this?
Thanks.
Hi Trimax,
You would not be able to truncate this table as other tables depend on it.
The reason that this table is growing could be due to two things or a combination
1. You are polling over the default. If you are polling over the default this puts more data into the table - you can check this on the admin page - polling settings
2. If you are storing more than the default recommended 7 days worth of detailed data this can cause these tables to grow. In this case I would recommend that you set the detailed data retention back to 7 days and then run the database maintenance tool (which you can find in Solarwinds Orion - Advanced Features) which will summarize any data older than 7 days into the responsetime_hourly tables.
Thanks Melanie.
