load testing

Question

Post reply

load testing

HBK_4700

SSCrazy Eights

Points: 8932
More actions
October 7, 2009 at 1:37 pm

#211985

Hello All,
Can anyone guide me on how we do load testing in sql server 2005, is there any 3rd party tools available for free/purchase?
Thanks you,
Kumar.

Viewing 10 posts - 1 through 9 (of 9 total)

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

HBK_4700 SSCrazy Eights Points: 8932 More actions · Answer 1

HBK_4700

SSCrazy Eights

Points: 8932

October 7, 2009 at 3:39 pm

#1063122

Please advice, if anybody came accross any tool

Marcin Gol Hall of Fame Points: 3314 More actions · Answer 2

i was using Quest Benchmark Factory (http://www.quest.com/benchmark-factory/). I performed some TPC tests - all i can say: i highly recommend this one !

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 3

Read about ostress at http://support.microsoft.com/kb/887057.

MJ

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 4

From an application perspective take a look at Mercury LoadRunner.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

garytoh4 Newbie Points: 5 More actions · Answer 5

chk2009 (10/7/2009)
Hello All,
Can anyone guide me on how we do load testing in sql server 2005, is there any 3rd party tools available for free/purchase?
Thanks you,
Kumar.

Hi chk2009,

please check this link: http://www.codeplex.com/SQLLoadTest .

Also you will find here all the details about this tool and option to download.

Gary Toh

--------

ProSolution pills review, side effects

free_mascot One Orange Chip Points: 27169 More actions · Answer 6

You can use profiler if you do not have any third-party tool.

Capture the live data with the help of profiler during peak hrs and re-run the same into test environment to do the testing.

Refer the following link:

http://technet.microsoft.com/en-us/library/ms190995.aspx

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

HBK_4700 SSCrazy Eights Points: 8932 More actions · Answer 7

@free_mascot

Thank you for your reply.

Can we capture user connection load with SQL Profiler, if so please let me know the how to capture.

----

And I came accross a solution, trying below link

http://blogs.microsoft.co.il/blogs/shair/archive/2008/07/24/sql-load-testing.aspx

Commandline utility is not working for me..I appriciate if you can guide me

C:\SQLLoad>DbLoadTestGen.exe SQLTEST SQLLoadtest.trc SampleConfig.xml

'DbLoadTestGen.exe' is not recognized as an internal or external command,

operable program or batch file.

HBK_4700 SSCrazy Eights Points: 8932 More actions · Answer 8

@Marcin Gol

Thank you for reply.

If you can provide the steps/process using Benchmark Factoy tool, I appriciate it. Thanks once again

I need to test SQL Database performance and user connections load.

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 9

SQLIOSIM if you're going to test the disk subsystem and IO patterns, as well.

http://support.microsoft.com/kb/231619