on 02-12-2013 9:28 AM
Dear DB exeprts,
We are planing to schedule Database update statistics through a script or a sql job for a SQL server 2000 Database.
sap:4.7Enterpris edition
DB:SQL 2000
Requirements: Need to update statistics for all table
Time: Monthly once.
1. please advise how to schedule the Database update statistics job in SQL agent.
Thanks
Thiru.
Hello
Please check these links as to how to schedule a job in SQL Server Agent.
http://www.quackit.com/sql_server/tutorial/sql_server_agent_jobs.cfm
http://msdn.microsoft.com/en-us/library/aa216438(v=sql.80).aspx
http://www.sqlusa.com/bestpractices2005/administration/updatestatistics/
Cheers
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can turn on automatic statistics update by running this SQL statement:
ALTER DATABASE YourDBName
SET AUTO_UPDATE_STATISTICS ON
Follow this link -
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Selven
Please follow this document http://msdn.microsoft.com/en-us/library/aa902688%28v=sql.80%29.aspx
and read this topic - "Maintaining statistics in SQL server 2000"
WR
Swati
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please refer the below note.
Note 1558087 - SQL Server Statistics Maintenance
Make sure Note 327494 - Configuration Parameters for SQL Server 2000
Please check and provide your feedback.
Thanks and Regards,
Vimal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please open the below link and page 150 , last line ...
http://www.sap-press.de/download/dateien/261/sap_press_database_005.pdf
This will give you a idea about your query.
http://scn.sap.com/thread/346640 will give you more info.
Please check and provide your feedback.
Thanks and Regards,
Vimal
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.