Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Autostats diabled in SQL server 2008

Dear Gurus,

Our SAP version is ECC 6.0 EHP5, DB is SQL server 2008 and OS Windows 2008 R2

We have EWA generated for PRD system and it says -

Set the AUTOMATIC UPDATE STATISTICS option to "OFF"  for tables VBHDR, VBMOD, and VBDATA

Execute below commands in QUERY ANALYZER

EXEC sp_autostats VBHDR  

EXEC sp_autostats VBDATA  

EXEC sp_autostats VBMOD

I have few questions regarding this :

1. I opened Query analyser but have no idea where to paste this command and how to execute it ?

2. Can this be done while DB is UP ?

Please help as I havent worked much in SQL before and this is regarding PRD system.

Thanks,

Shobhit

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question