SQL 2005 Performance Testing

• Christopher Peer

  Newbie

  Points: 1

  More actions

  January 18, 2007 at 10:14 am

  #171917

  I am building a test environment with three database servers to simulate a future production environment using SQL 2005 and mirroring. I am looking for a tool that would simulate transactions/activity on the principal server and then allow me to test the performance degration and Disaster Recovery procedures.  Any suggestions?

  Thank you,

  Chris

   

   

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 18, 2007 at 5:27 pm

  #684167

  http://www.sql-server-performance.com/gv_stress_test_lessons_3.asp

  http://www.microsoft.com/downloads/details.aspx?FamilyId=5691AB53-893A-4AAF-B4A6-9A8BB9669A8B&displaylang=en

  There are some third party tools if you want to spend money...

  http://www.keynote.com/

   

  MohammedU
  Microsoft SQL Server MVP