Waht is the Best way to crash server?

  • 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

  • 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)

  • 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

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • Database Hammer in resource kit.

  • Database Hammer???

    Would U be a litle bit specific?

    Jay

  • 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