Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Decision tree Expand / Collapse
Posted Wednesday, August 4, 2010 10:41 AM


Group: General Forum Members
Last Login: Wednesday, June 1, 2016 12:24 PM
Points: 441, Visits: 365
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.

Post #963619
Posted Wednesday, August 4, 2010 12:07 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, January 24, 2014 11:30 AM
Points: 44, Visits: 387
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.

Post #963717
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse