As the screenshot below, I opened 200 sessions, each call 1 query to fill up Tempdb to create Tempdb bottleneck, and loop this 100. I have successfully created Tempdb bottleneck, and with another tool WhoIsActive I can catch the query which is causing bottleneck.
Select top (10000) a.* into #x from master..spt_values a, master..spt_values b
Link download tool: http://www.datamanipulation.net/sqlquerystress/sqlquerystressdownload.asp
0 comments:
Post a Comment