Skip to Content
0
May 01, 2018 at 02:46 PM

Running manually index rebuild and update statistics for MS SQL server 2014 running SAP systems

983 Views

Hi All,

We have SAP Net-weaver products ECC, BI and EP running on SQL server 2014 with huge DB size 4 TB, 3 TB and 5 TB respectively.

As we have no archiving solutions implemented hence the large DB size.

Auto update state and update stats job is present. But we are facing performance issue now and then.

Our SQL DBA is recommending to run full update stats monthly and yearly once index rebuild to overcome performance issues.

We have seen in SAP notes not to run manually any update stats and index rebuild .

Could you please advise under exception cases we can run the update stats and index rebuild ?

Moreover previously we have received specific tables in ECC system to run the update stats weekly basis to overcome performance issues.