It would seem strange to have an 8-core server running on a 32bit OS, as you'll be limited to 4GB RAM unless using PAE. Even when using PAE there are some caveats and a true 64bit OS & SQL Server will yield better performance.
The number of cores supported by SQL depends on your version, I believe you need the Enterprise version to support 8 cores. The quickest way to check; 1) Open SQL management studio 2) Right click on the server and choose properties 3) View the Processors tab (you can also view the memory tab from here). Indexing is a good way to start (in fact, well thought and planned indexes are a fundamental of good database design). You should also look at any particularly long running queries (or commonly used short queries) and view the estimated / actual execution plans. You can find a lot of information about google on this, so I won't repeat how to do it. On Thu, Feb 4, 2010 at 6:03 AM, Kiran Raj <[email protected]> wrote: > 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 >
