Wednesday, March 28, 2012

Help for sp_updatestats

Hi,
WEhen can I use this procedure? When its recommended and if its safe to use
it while online users are using the database.
Regards,
aoxpsql,
This can consume large amounts of server resources, mainly disk IO. I
would prefer to run this at a time when the number of users is at a
minimum, say 3am? Try and run it when no other maintenance or overnight
batch jobs are running.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
aoxpsql wrote:
> Hi,
>
> WEhen can I use this procedure? When its recommended and if its safe to use
> it while online users are using the database.
> Regards,
>
sql

No comments:

Post a Comment