Server usage info needed for server consolidation

• Vivien Xing

  SSChampion

  Points: 12297

  More actions

  February 28, 2008 at 10:49 am

  #120554

  Need to collect server usage information for server consolidation. What data should be taken into consideration? I am thinking to set up performance monitor to collect the data. Wondering what the must have objects/counters are.

  Any suggestions?

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  February 28, 2008 at 11:16 am

  #783375

  You can get the counters to look for from the link given below

  http://www.sql-server-performance.com/tips/sql_server_performance_monitor_coutners_p1.aspx

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  February 28, 2008 at 11:51 am

  #783392

  additionally, you can check out the following article. I think it may have just what you are looking for...

  http://www.sqlservercentral.com/articles/Monitoring/61373/

  To help us help you read this[/url]For better help with performance problems please read this[/url]

• Vivien Xing

  SSChampion

  Points: 12297

  More actions

  February 28, 2008 at 8:07 pm

  #783566

  Thank you for the links. It is interesting to know how the others handle the same topic in different ways.

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  February 29, 2008 at 6:43 am

  #783717

  Yup, there's usually more than one way to to accomplish a given goal. It all depends on what works best in your environment.

  -Luke.

  To help us help you read this[/url]For better help with performance problems please read this[/url]