SQL Server Performance

Update Statistics

Discussion in 'SQL Server 2008 General DBA Questions' started by vna_mhars, Feb 16, 2011.

  1. vna_mhars New Member

    Hi,
    Can I use the database while full scan in update statistics is running?
    Thanks
  2. Luis Martin Moderator

    Welcome to the forums!.
    I don't recommend to do that. Schedule a job in a windows time.
    About your question: yes.
  3. satya Moderator

    Welcome to the forums.
    It depends on how frequently and how many tables & their rowcount are involved in this update statistics task.
    By default there will be shared locks applied which update statistics is running.

Share This Page