Autostats diabled in SQL server 2008
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.