What do you do to keep your Manage/Automate servers healthy?

Hey y'all,

Does anyone have any tips, tricks, scripts, etc that they use to keep their databases healthy? My company kind of set and forgot about our servers and as we grow, we feel the pains more and more. We're probably going to just throw more hardware at it, but I'm wondering what we can do aside from that? CW support always has us truncate some tables, which helps for a little, but we don't regularly truncate them, or know which ones we should, or know if there's better things to do.

Thanks!

Posted Apr 19, 2019, 8:05 PM UTC

Sort by:

Jimjawn•7 yr. ago

Tune in your SQL DMV’s. https://docs.microsoft.com/en-us/sql/relational-databases/performance/use-dmvs-determine-usage-performance-views?view=sql-server-2017

You can turn on performance tuning and see which queries run the longest / slowest. Once you have that data you can hire a SQL person to tune your DB. In my experience, the indexes are your Achilles heel.

NeonBlueConsul•7 yr. ago

If you need help maintaining the servers, we can definitely help with that.

There are a few items that can probably be tweaked to help out with that. Assuming you are leveraging the integration, there may be ways to quite down a lot of unnecessary noise as well

Feel free to reach out if you'd like some assistance, we can take a look at your system at a high level and probably provide some quick fixes