Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Decision tree Expand / Collapse
Author
Message
Posted Wednesday, August 04, 2010 10:41 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:49 PM
Points: 382, Visits: 241
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
Post #963619
Posted Wednesday, August 04, 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.

Dan
Post #963717
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse