August 4, 2010 at 10:41 am
How do I Design a Decision Tree for Consolidation of various servers on SQL 2005 to SQL 2008 on a new hardware and different data center.
What are the things I need to consider when I make the Decision Tree, I mean the bullet points.
Thanks,
Murtuza
August 4, 2010 at 12:07 pm
Capacity Planning - Measure and compare peak and business hours requirements for Memory, CPU, Disk IO and Network Bandwidth. Peak for some systems may be during off hours while backups and ETL processes are running. Connections and batch requests per second may also reveal potential issues.
Security - Security concerns may dictate what can be consolidated.
Is that reporting instance really required? Applying and maintaining proper indexes may eliminate the need for ad hoc databases. Performance tuning can have a significant impact on costs.
I believe SQLCAT produced a white paper on consolidation.
Dan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply