Update Optimizer Statistics is not active in DB13

[Former Member]

Hi,

I would like to execute the statistics in the system but when I go to the transaction DB13 I don't see it.

Do I have to do something else? Or is not there because is running on the SQL side?

Thanks,

Carlos

[former_member182657 · Accepted solution]

Hi,

Could you check with SAP KBA  1660220 - Microsoft SQL Server: Common misconceptions

& notes   1558087 - SQL Server Statistics Maintenance

1027512 - MSSQL: DBA cockpit for basis release 7.00 and later

Hope this will help you.

Thanks,

[Brindavan_M]

Hi,

Kindly cross check once again your BG job which are related to update statics. Check the CCMS and gateway process which is running or not.

The following link might be helpful : Scheduling Updates of SQL Optimizer Statistics (SAP DB) - Computing Center Management System (BC-CCM...

Thanks,

BR

[Former Member]

Hi Carlos,

I would suggest you to go through this blog.

regards,

pavan