Saturday, February 25, 2012

Deciding which Database Server to install a new database

We have 3 Microsoft SQL 2000 servers. All of them have smiliar hardware configuration. I need to identify a database server to install a new database instance. I believe my decision should be based on available memory and processor workload at any given time. I need your help to identify the right server. Thank you.

Well, use perfmon to get a baseline from your servers and see how they are utilized. Make sure that you monitor a timespan which represents a common usage scenario. in addition make sure which licencse type your are using on the servers.

Jens K. Suessmeyer

http://www.sqlserver2005.de

No comments:

Post a Comment