EBDN - Community - Question & Answers

  Thursday, 19 October 2023
  0 Replies
  478 Visits
0
Votes
Undo
Hello,

It may not be the right forum, but maybe someone can still give me an answer.
Which maintenance plan do you use for your EB database? How does it affect performance?
I ask because I have different performances on different databases. What can cause this? Is it simply the size of the database? All databases are currently working on the same server with this maintenance plan (every night) which I received from Aucotec support:
use [EB_PRD1]
go
--************************************************ ***
-- Optimize Index & Update Statistics
--************************************************ ***
exec spMT_Optimize

--************************************************ ***
-- Delete obsolete masks and consolidate
--************************************************ ***


--************************************************ ***
-- Delete Recycle Bin older than 14 Days
--************************************************ ***

exec spDeleteRecBinEntriesSelective @fReportOnly = 0, @olderThanXDays = 30


--************************************************ ***
-- Delete MSG Entries older than 90 Days
--************************************************ ***

--exec spDeleteMsgEntriesSelective @fReportOnly = 1, @olderThanXDays = 90


exec spMT_Optimize @ConfigureAutoStats='SPECIFIC_TABLE_OFF'

exec spMT_Optimize

Best regards