Benchmark/simulate parallell execution of a sql query

• Helmut Nielsen

  SSC Eights!

  Points: 816

  More actions

  August 27, 2008 at 1:55 pm

  #211668

  Hi

  I have a web site running a database query against a sql 2005 DB. The query is fast when executing in query analyzer, but for some reason it doesnt scal when multiple users are running the same query from the external web. I strongly suspect that the SQL server is in some way a bottleneck...but I need to find a way to "stress test" my query in some way. I want to find a way to, internally inside SQL Server, simulate this one sql query running in several parallell instances...

  From this test, I would like to see/verify IF this parallell execution makes each individual query to go slower...

  Please advice how to proceed to find the bottleneck. Joins and indexes etc..have been analyzed and verified by a lot of "sql people"...

  Help mostly appreciated

  br

  Helmut

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  August 27, 2008 at 1:56 pm

  #863961

  Please do not cross-post.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]