February 22, 2002 at 10:46 am
Hi, All
What is the best way to crash server?
I mean stress test:-)))
I have a new server but when I did some test, server crashed on me twice..
Right now it is fine after did some modification..
However I dont have confidence in this server so I want some more testing..
What I am doing is to run reports that are required hitting lots of tbs..
Is there any T-SQL query that I can run do some testing?(Crash server not purposly but for testing)
Thx in advance..
Jay
February 22, 2002 at 11:19 am
Use a cursor to do a join type loop into a temp table for your output, these is one of the most intesive things you can do. But other than that just do a trace on the database of the types when utilization is highest and then play it back as 5 times the number of users. I am not at my desk so I don't have details, but that is how I generally baseline my servers.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
February 22, 2002 at 12:18 pm
There is a basic tool I believe in the SQL 2K Resource Kit for general stress testing, and I know there is one in the BackOffice 4.5 Resource Kit. However, to piggy back on what Antares is saying, figure out what smokes your server the most and run that hard against it.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
February 25, 2002 at 2:50 pm
Database Hammer in resource kit.
February 25, 2002 at 2:59 pm
Database Hammer???
Would U be a litle bit specific?
Jay
February 25, 2002 at 3:39 pm
as an add-on to bkelleys's comments,
"There is a basic tool I believe in the SQL 2K Resource Kit for general stress testing"
This "tool" is called Database Hammer.
A customizable tool for testing your database server with various loads.
cheers
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply