RE: [sap-basis] Turning off automatic updates statistics for table VBMOD
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by D. Caddick (SAP NetWeaver/BASIS Consultant) on May 11 at 5:45 PM |  Mark as helpful |
Hi,
Then I recommend that you open a message with SAP the Notes are regarding the DB settings not SAP versions.
Regards
From: larg3n via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 11 May 2010 14:41
To: D. Caddick
Subject: RE:[sap-basis] Turning off automatic updates statistics for table VBMOD
Posted by larg3n (Basis Administrator)
on May 11 at 9:55 AM Mark as helpful
Thanks David for your reply.
...But I have viewed that note many of times. And you are correct, you shouldn't disable ALL auto-stats but disable only for a few tables per SAP's recommendations. I am having a hard time keeping this one table off (VBMOD). see below.
My EWA report stats this:
Recommendation: Set the AUTOMATIC UPDATE STATISTICS option to "OFF" for tables VBHDR, VBMOD, and VBDATA as described in SAP Note
To do so, use SQL command:
EXEC SP_AUTOSTATS <tablename>, OFF
Background: SAP requires the automatic update mechanism to be deactivated for these tables. Otherwise, system performance can be negatively impacted. These tables are often modified, which means that the statistics are updated frequently. Since this table is accessed only by fully qualified indexes, the optimizer does not require detailed statistics to select the correct access path.
oh, and we are running SQL2005 with R/3 not netweaver.
---------------Original Message---------------
From: larg3n
Sent: Monday, May 10, 2010 2:47 PM
Subject: Turning off automatic updates statistics for table VBMOD
> Hello,
>
> I turned off automatic updates statistics for table VBMOD per SAP's note 771352 with my EWA report. But every time we reboot it turns back on automatically. I use EXEC sp_autostats VBMOD, 'OFF' within SQL 2005 to turn it off.
>
> Is there a ways to make this setting permanent?
>
> Thanks,
> Donald Largen
__.____._ Then I recommend that you open a message with SAP the Notes are regarding the DB settings not SAP versions.
Regards
From: larg3n via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 11 May 2010 14:41
To: D. Caddick
Subject: RE:[sap-basis] Turning off automatic updates statistics for table VBMOD
Posted by larg3n (Basis Administrator)
on May 11 at 9:55 AM Mark as helpful
Thanks David for your reply.
...But I have viewed that note many of times. And you are correct, you shouldn't disable ALL auto-stats but disable only for a few tables per SAP's recommendations. I am having a hard time keeping this one table off (VBMOD). see below.
My EWA report stats this:
Recommendation: Set the AUTOMATIC UPDATE STATISTICS option to "OFF" for tables VBHDR, VBMOD, and VBDATA as described in SAP Note
To do so, use SQL command:
EXEC SP_AUTOSTATS <tablename>, OFF
Background: SAP requires the automatic update mechanism to be deactivated for these tables. Otherwise, system performance can be negatively impacted. These tables are often modified, which means that the statistics are updated frequently. Since this table is accessed only by fully qualified indexes, the optimizer does not require detailed statistics to select the correct access path.
oh, and we are running SQL2005 with R/3 not netweaver.
---------------Original Message---------------
From: larg3n
Sent: Monday, May 10, 2010 2:47 PM
Subject: Turning off automatic updates statistics for table VBMOD
> Hello,
>
> I turned off automatic updates statistics for table VBMOD per SAP's note 771352 with my EWA report. But every time we reboot it turns back on automatically. I use EXEC sp_autostats VBMOD, 'OFF' within SQL 2005 to turn it off.
>
> Is there a ways to make this setting permanent?
>
> Thanks,
> Donald Largen
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
D. CaddickSAP Basis Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement
In the Spotlight
Your SAP Security is at Risk...Learn How to Stay Protected. Read the free white paper from SenSage
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
