Post reply

SQL Load testing

  • October 3, 2003 at 5:08 am

    #106520

    Hi

    I am a bit of a newbie with SQL and I am currently looking at what my database server can handle before it falls over. Does anyone know of any load testing software or a script that can perform the operation? I want to see how many thousands of users can access the database simultaneously, before it affects the performance.

    Any advice or tips would be much appreciated.

    Cheers

  • October 3, 2003 at 10:54 am

    #477020

    Try looking at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part11/c3961.asp

    it is the SQL resource Kit which has a "Database Hammer". This may do what you are looking for.

    quote:

    Hi

    I am a bit of a newbie with SQL and I am currently looking at what my database server can handle before it falls over. Does anyone know of any load testing software or a script that can perform the operation? I want to see how many thousands of users can access the database simultaneously, before it affects the performance.

    Any advice or tips would be much appreciated.

    Cheers

  • October 3, 2003 at 11:06 am

    #477024

    I suppose you are prepared to handle the licencing issue. i.e. you have a processor licence instead of server/CAL based licence otherwise you wont be able (or allowed to access your database more then allowed).

    Having said that I think the fastest way would be to develope a client side miniapp which tries to make as much connection as possible. You can do this in virtually any dev tool VB, C, Delph, ...

    Here is an example in Delphi:

    procedure TForm1.Button6Click(Sender: TObject);

    var

    DB: array of TADOConnection ;

    i, j: Integer ;

    begin

    j := StrToInt(Edit1.Text) ;

    SetLength(DB, j) ;

    try

    for i:=0 to j-1 do

    begin

    DB := TADOConnection.Create(Self);

    DB.ConnectionString := 'Provider=SQLOLEDB.1;Password=MyPwd;Persist Security Info=True;User ID=MyUser;Initial Catalog=MyDB;Data Source=MyServer' ;

    DB.Open ;

    Edit4.Text := IntToStr(i) ;

    end ;

    for i:=0 to j-1 do

    begin

    DB.Close ;

    DB.Destroy ;

    end ;

    except

    on E: Exception do ShowMessage(E.Message) ;

    end ;

    end;

    Of cours once you have established the connection you can do what you want as DB actions.

    To make it more paralell you can use multithreading or initiate several apps paralelly.

    Bye

    Gabor



    Bye
    Gabor

  • October 7, 2003 at 4:34 am

    #477331

    Cheers

    Your advice has been very helpful

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply