> > Hi all,
We have a migration issue. Our database was deployed in server having 64bit OS(windows 2003) and a 64-bit sql server 2005 .Due to performance issue, 2 weeks back we migrated from this system to a server having 8 cores CPU. It was not known to us that it was running on 32 bit windows 2003 R2 and 32 bit sql server 2005. So we started thinking its a database issue and started optimizing the indexes of all the tables( most tables have millions of records) but with no luck. What i want to know is will there be a performance issue based on the difference in OS and SQL server versions? Would other areas should i look into to increase the performance? How do i check if the sql server is using all the 8 cores? please help as we have no clue in which direction to move forward. One thing is, the hardware of the new server is many times better than the old one. Thanks Kiran
