Testing New Servers

• arrjay

  Hall of Fame

  Points: 3455

  More actions

  June 3, 2014 at 1:53 pm

  #289506

  Hi there - We are in the process of migrating to a new data centre and need to test the servers to ensure we will get an improvement in performance before we go live.

  I was wondering if anyone knows of any good blogs or some good scripts to test the performance of the new servers.

  Thanks all!

  --------------------------------------------

  Laughing in the face of contention...

• SpeedySQL

  Ten Centuries

  Points: 1019

  More actions

  June 4, 2014 at 2:31 am

  #1718754

  Here are a few to get you started:

  http://blogs.msdn.com/b/sqlmeditation/archive/2013/04/04/choosing-what-sqlio-tests-to-run-and-automating-sqlio-testing-somewhat.aspx

  http://sqlblog.com/blogs/linchi_shea/archive/tags/Testing/Benchmark/default.aspx

  http://www.brentozar.com/archive/2012/06/load-test-sqlserver/

  SpeedySQL

• arrjay

  Hall of Fame

  Points: 3455

  More actions

  June 4, 2014 at 2:46 pm

  #1719018

  Thanks for that! I'll check them out.

  --------------------------------------------

  Laughing in the face of contention...