Hi all,

Is there a formula into which values such as server specs, table and
row sizes, and index type can be plugged to compute the time for a SQL
Server 2005 index to be built?

Thanks,
Sean

None that I know of and it depends so much on the hardware and configuration
as well. It usually comes down to testing and going from there.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Sean Clayton" <seancly10 (AT) gmail (DOT) com> wrote

On Nov 25, 2:14*am, Sean Clayton <seancl... (AT) gmail (DOT) com> wrote:
in my experience it's mostly your I/O that will determine this. one
time on our old SAN we bought some storage that was configured all by
itself. the production storage on that SAN was all screwed up where
different servers would hit the same disks. it's a long story why.

we hooked up a QA SQL Server to this new storage and ran alter index
on a few tables. it would run in 10 minutes when on production it
would run for 30-40 minutes on the same table. Same SAN just different
drives. and the QA server was an older model than the production server