Reindex

The dbcc dbreindex job that takes about 40 minutes on a 32 bit SQL Server
takes about 1hr and 20 minutes in a 64 bit server. The same set of databases
exist on both servers and the file structure also is the same with the drives
for the database files for both being SAN LUNs. The activity on SQL Server is
also the same for both servers when the reindex job is run , there is no one
else on the system. The 32 bit server has only 2G available to SQL whereas
the 64 bit has 8G available to SQL.
How many processors on the 32 bit and the 64bit? What is your MAXDOP set
to? Just because the 64bit is connected to a SAN does not mean you will get
the same performance as another LUN.
Andrew J. Kelly SQL MVP
"MANCHO" <MANCHO@.discussions.microsoft.com> wrote in message
news:3EC0BE26-484E-4714-A25D-35A038E2D7A7@.microsoft.com...
> The dbcc dbreindex job that takes about 40 minutes on a 32 bit SQL Server
> takes about 1hr and 20 minutes in a 64 bit server. The same set of
> databases
> exist on both servers and the file structure also is the same with the
> drives
> for the database files for both being SAN LUNs. The activity on SQL Server
> is
> also the same for both servers when the reindex job is run , there is no
> one
> else on the system. The 32 bit server has only 2G available to SQL whereas
> the 64 bit has 8G available to SQL.