January 7, 2010 at 2:22 am
Hello friends,
My self Kaushik Mistry.
I want to perform certain job in sql server 2000 to enhance performance.
DBCC UPDATEUSAGE for all tables of a database
DBCC DBREINDEX for all tables of a database
UPDATE STATISTICS for all tables of a database (With full scan)
EXEC SP_RECOMPILE for all tables of a database
EXEC SP_REFRESHVIEW for all tables of a database
How do i perform above all activities, please suggest and guide how to do and when to do above all activities.
Regards,
Kaushik Mistry
January 7, 2010 at 2:29 am
May I suggest that you start by looking in Books Online for info on the various commands that you want to run.
There's no need to do SP_RECOMPILE and SP_REFRESHVIEW on a regular basis.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply