SQL Server Performance Forum – Threads Archive

Architecture

Hi guys, We currently have 9 different servers running SQL Server 6.5, 7.0, and 2000. When I upgrade the older versions, I would like to consolidate as many as possible onto as few servers as possible. How would you guys recommend this approach? For example: Do you recommend buying 1 LARGE Dual Processor Server to serve as the DB Server? Maybe 2 servers, one to carry the load and the other to store the data files? Any thoughts or ideas are greatly appreciated. ———-
T Kelley
MS, MCDBA, OCA, CIW

---

Would you give some information about: 1) Users by SQL.
2) DataBase Sizes.
3) HW of each server.
4) Disks Architecture (RAID?) Thanks, Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

---

Also check CPU utilisation, pages/sec, network IO of each box and try to extrapolate the total required grunt <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /><br /><br />Cheers<br />Twan

---

I agree, it totally depends on the user base and the database size you’re trying to manage all at one place. May consider keeping less performance affected databases on one server and troubled ones on seperate servers. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

]]>