Endpoint Protection

 View Only
  • 1.  Best practice for SEPM DB maintenance tasks - SEP v14.2 RU1 MP1

    Posted Apr 03, 2020 04:31 PM
    Hi All,

    Is there a guide that can assist with determining the scheduled times for the truncation and index build settings for the SEPM DB maintenance tasks.
    Customer running 60000+ clients , 4 SEPM's and 1 SQL server.
    Currently set to once a week for truncation and index build.

    Please advise on what settings would be optimal in this environment as the DB is quite slow and growing.

    Thanks in Advance
    T


  • 2.  RE: Best practice for SEPM DB maintenance tasks - SEP v14.2 RU1 MP1

    Broadcom Employee
    Posted Apr 07, 2020 02:35 PM
    Generally out defaults are fine. If you are seeing db fragmentation you could increase the amount of times it is run.  MS should have suggestions as well.

    ------------------------------
    John Owens
    Principal Product Support
    Symantec
    United States
    ------------------------------



  • 3.  RE: Best practice for SEPM DB maintenance tasks - SEP v14.2 RU1 MP1

    Posted Apr 08, 2020 02:13 AM
    We currenty dont have an SQL admin and its left to the SEP admins to determine. Is there MS suggestions for SEPM database maintenance tasks?


  • 4.  RE: Best practice for SEPM DB maintenance tasks - SEP v14.2 RU1 MP1
    Best Answer

    Broadcom Employee
    Posted Apr 08, 2020 10:56 AM
    Our defaults are our suggested settings.  If you are seeing issues you will want to either increase how often we truncate and rebuild indexes.



    ------------------------------
    John Owens
    Principal Product Support
    Symantec
    United States
    ------------------------------