Skip to Content
0
Former Member
Aug 25, 2012 at 08:49 PM

Autostats diabled in SQL server 2008

65 Views

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