SQL Server Performance

how much time required to execute sp_updatestats

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by bond_isamashi, May 26, 2009.

  1. bond_isamashi New Member

    hi every one,
    we have a production database having 50 tables, each conating 200000 records.
    how much time is needed for the exec "sp_updatestats" operation to complete.
    u r help is appreciated
    with regards
    bond_isamashi
  2. moh_hassan20 New Member

    it depends on number of indexes per table, CPU performance.
    i expect in average 25 minute
  3. satya Moderator

    I would say very hard to say what kind of processes/scheduled jobs are running at the time and also depends upon the memory & CPU of the server.

Share This Page