Installing instance of 2008 on server

ac_davis2002
ac_davis2002 used Ask the Experts™
on
Hi

I have a server that has sql 2005 installed. I am going to install an instance of 2008 on it how can i tell if the server has enough capacity (memory, cpu, io) to do this?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi,
This link
SQL 2008 tells you what is the requirement of sql 2008. Now depending that whether you want to use both (SQL 2K5 & SQL 2K8) sql simultaneously, you need to check the usage of current sql and then can identify, if sql 2k8 can also be run or not.
Commented:
You can check the minimum Hardware requirements for installing and running SQL Server 2008 from the following link:
http://technet.microsoft.com/en-us/library/ms143506(v=sql.100).aspx

Accordingly, if you know how much RAM(memory) and CPU you have in the machine and subtract the Memory allocation you have done in the SQL Server properties of the SQL Server 2005, you will get the available memory. Then you can compare with the recommendation and know if you are okay with respects to the hardware requirements for the SQL Server 2008 installation.

If you can give the following values here, I can calculate it for you.

Total Memory in machine:
Total CPU in the machine:

From SQL Server 2005 Properties, Max SQL Server Memory:......
Commented:
Performance monitor can give you and idea of Average usage of cpu, memory , io.
also the sql performance counters
http://www.sql-server-performance.com/2005/sql-server-performance-monitor-coutners/
http://www.mssqltips.com/sqlservertip/1265/sql-server-database-specific-performance-counters/
http://www.mssqltips.com/sqlservertip/2188/collect-and-store-historical-sql-server-performance-counter-data-with-dmvs/

How much memory is on server in use for that 2005 instance, so see how much you need for that 2008. Decreasing memory for 2005 instance will decrease performance (less cache). Note that sql does not release memory.

And it's good to know the value's now and on regular basis so you can see where your system is going to.... or is impacted by a changes (new database, growth of data, index maintenance) or new software as here a new sql instance.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial