Help me thrash the CPU

• Mick Opalak

  SSCommitted

  Points: 1631

  More actions

  July 7, 2016 at 12:54 pm

  #327732

  To test out a bug fix, I need to thrash the CPU on the my testing SQL Server. I mean I need a query (or queries) that would get the CPU to 90% - 100% for several minutes at a time. The problem is my testing server has 48 cores. I've tried setting the Cost Threshold for Parrallelism to 2 and the MAXDOP to 40, but I can only manage to peg the CPU to about 20%.

  Does anyone have a query I can use that just crushes the CPU? Maybe some crazy complex scientific calculation that chews up the CPU?

• Isabelle2378

  SSCertifiable

  Points: 6174

  More actions

  July 7, 2016 at 5:56 pm

  #1889085

  Hi,

  We used HammerDB to test our new SAN...it will simulate a load on the system and it consistently brought our CPU up above 90%. 😀

  Thanks!
  Bea Isabelle

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  July 7, 2016 at 7:41 pm

  #1889091

  I don't think you need to do big calculations. You just need to do repeated stuff with no delay.

  http://blog.sqlauthority.com/2013/02/22/sql-server-t-sql-script-to-keep-cpu-busy/

  http://stackoverflow.com/questions/24810905/trying-to-create-an-sql-query-that-will-max-all-cpus-to-100

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service