SQL Server Performance

performance compare for index rebuild

Discussion in 'ALL SQL SERVER QUESTIONS' started by tcronines, Jun 27, 2014.

  1. tcronines New Member

    Trying to migrated to new server with client. Seeing peformance issues from the applicaiton end, going from sql 2005 12 core to new 2008 r2 64 core, 64 gig of memory and new san. Cleared proc cache (after hours) and ran selects, 2005 server twice as fast with 100 users, 2008r2 new server no users. Tried to take it to simple approach rebuilt all indexes on new super server (standard edition) took about 3.3 hours. There are no users on system, tempdb multiple devices on own disk as are all the data files and index files on own disks. Ran same index rebuild against same database on test server with 2008r2 standard 12 core, 16 gig of ram, tempdb and data files all on same disk. Took same amount of time. Might be a simpleton, but there is no way the times for the test server and this new high velocity server should be the same, no users, rebuild was all that was running. We dont have sysadmin on this new high priced box at client so limited in what we can look at. Am I missing something I see no way the same index rebuild on the different of boxes should be the same.
  2. Gopi Krishnan New Member

    Can you please check the memory / CPU utilization on the server . Also need to check with your DBA's on SQL Server instance configuration - Max memory , affinity mask, parallelism options or any resource governor is configured. these options will control the resource utilization for the maintenance jobs.
  3. melvinlusk Member

    Is the recovery model the same on both servers?

Share This Page