update statisticsin sql

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » update statisticsin sql

update statisticsin sql

Rate Topic

Display Mode

Topic Options

Author

Message

shreekanth.kavali

Posted Friday, February 01, 2013 5:17 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, February 16, 2013 10:52 AM
Points: 12, Visits: 19

how long the update statistics job used to run on the largest database(of size 1300GB)

Post #1414590

GilaMonster

Posted Friday, February 01, 2013 5:24 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 37,687, Visits: 29,946

Depends on the IO subsystem, memory, CPU, concurrent connections, etc.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1414591

Sean Pearce

Posted Tuesday, February 05, 2013 7:21 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 4:17 PM
Points: 345, Visits: 1,323

shreekanth.kavali (2/1/2013)

how long the update statistics job used to run on the largest database(of size 1300GB)

Just a bit longer than on the 2nd largest database.

http://thesqlguy.blogspot.com/

Post #1415830

« Prev Topic | Next Topic »

Permissions