Updating Statistics - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Updating Statistics

Author

Topic

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2007-01-17 : 07:56:15

Hi All,

I have few quries

1) Do we need downtime or to make database offline while updating statistics for table? Or this can be done online?

2) If this can be done online, will it consume CPU or memory?

3) Will the log file will grow during statistics updation?

Thanks in Advance

Regards
SS

Don't sit back because of failure. It will come back to check if you still available. -- Binu

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-01-17 : 10:43:34

1. can be done online.
2. yes.
3. haven't seen a dramatic increase yet...

Go with the flow & have fun! Else fight the flow