19/10/2013
» » » SQL Server Tool: SQLQueryStress

SQL Server Tool: SQLQueryStress

21:23
This is a free tool, we use it for creating pressures to SQL Server, and testing Performance.

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
at 21:23
Share:

0 comments:

Post a Comment

:) :)) ;(( :-) =)) ;( ;-( :d :-d @-) :p :o :>) (o) [-( :-? (p) :-s (m) 8-) :-t :-b b-( :-# =p~ $-) (b) (f) x-) (k) (h) (c) cheer
Click to see the code!
To insert emoticon you must added at least one space before the code.

Subscribe to: Post Comments (Atom)
 
Toggle Footer