on 10-27-2006 6:53 AM
Hi
We run the SQL Statistics job on a monthly basis. Our database is small. about 133GB.
Please can you recommend how often in a month I should run this statistics job, or is once a month suitable?
Thanks and regards
Avishkar
Hi Avishkar,
as mentioned in the previous reply, you do not need to explicitly update statistics with SQL Server. You even shouldn't.
SAP recommendation is to:
Depending on your SQL Server Release please look into the SAP Note which applies to you in order to correctly set auto update statistics:
327494 - Configuration Parameters for SQL Server 2000
879941 - Configuration Parameters for SQL Server 2005
1237682 - Configuration Parameters for SQL Server 2008
1702408 - Configuration Parameters for SQL Server 2012
Regards,
Beate
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Avishkar,
There is no need to run update statistics manually with SQL Server 7.0, 2000 or 2005. The SAP database should be set to "auto update statistics"
Please review:
Note 327494 - Configuration Parameters for SQL Server 2000
Note 879941 - Configuration Parameters for SQL Server 2005
There are several tables that must be excluded from the automatic calculation of statistics, these are documented in the above notes.
I also recommend that you download the Word document attached to this note and review it:
555223 FAQ: Microsoft SQL Server
Thanks
N.P.C
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.