• KumarVelayutham (12/17/2013)


    Based on my understanding,Microsoft assessment and planning tool will help to get the load and all details for each and every server.Is it right?

    Not at all.

    As Richard says, you'll need to establish a baseline. I'd suggest picking up a copy of the book Troubleshooting SQL Server[/url]. You can purchase a paper copy or download an e-book for free. It will give you a lot of information on how to gather metrics on the servers. From there you can start figuring out what kind of consolidations you might be able to do.

    I'd strongly suggest that you tell your boss that you're WAY over your head on this one. Get a consultant in to help out. We're talking about a pretty major undertaking to gather all the metrics, evaluate them, make informed decisions based on the business needs and the technology needs and abilities, and then implement all of the above successfully. No offense intended, but you're not even maintaining patches on your servers, so I really don't think you're ready for this.

    As a DBA, your primary job is to ensure the protection of the business's data. And sometimes, that means protecting it from yourself.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning