BASIS QUESTION

cryptosid
cryptosid used Ask the Experts™
on
hello experts...
I have a 4.0B PRD system running on a SQL SERVER 7.0 running on Windows NT 4.0

i want to run a UPDATE STATISTICS on the database on a daily basis with FULL SCAN and not 13% that SAP has is there any configuration parameter or some setting that i can change to cause the effect..i am aware of DB13 options they don't provide me to set the SCAN %age

pls help
cryptosid
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Check Note : 0141118 Page3: Update Statistics:
The job 'Update Statistics' is removed from the DB13 job's list. The regular scheduling of this job is not necessary in  sql server 7.0 and higher releases as this is done automatically since sql server 7.0. The recommeded strategy is to set the database options 'auto update statistics' and 'auto create statistics'.

Author

Commented:
i have already checked that but for some reasons the update stats doesn't run automatically on sql server 7.0 and also the parameters u specified 'auto update statistics' and 'auto create statistics' is set to ON.

suggest me something else pls
cryptosid

Author

Commented:
I know my previous comment  sounded little wierd but that's the truth inspite of the above things set correctly the auto update statistics doesn't give me full hundered percent updation and in fact it doesn't allow me to set it to 100%...

So currently i do things at db level...i run a daily job on the Database to update statistics on the Database level...

Author

Commented:
Thanks Again

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial