How to do the load testing sqlserver 2008R2

Question

How to do the load testing sqlserver 2008R2

kommagoni

SSCommitted

Points: 1898
More actions
September 15, 2010 at 5:36 am

#238235

Hi All, how to perform the load testing in sql server 2008R2, when 2 r 3 users connecting to server its performing good but cpu utilization is high after executing its coming to 0% but my question is when 300 users connect to the system then system going hang slow performance.
So anyone please suggest me how to do the load test before going to live is there any other process to test my server.

Viewing 7 posts - 1 through 6 (of 6 total)

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

steveb. SSC-Forever Points: 46733 More actions · Answer 1

I usually write a webservice to call the stored procedures, then use a tool such as SOAPUI to load up hundreds of instances of the webservice at the same time and call the procedures.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 2

kommagoni (9/15/2010)
Hi All, how to perform the load testing in sql server 2008R2, when 2 r 3 users connecting to server its performing good but cpu utilization is high after executing its coming to 0% but my question is when 300 users connect to the system then system going hang slow performance.
So anyone please suggest me how to do the load test before going to live is there any other process to test my server.

Ummmm... are you saying that CPU the CPU utilization was high just for 2 or 3 users? If you are, you don't need a load test... you need some repairs to code. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

kommagoni SSCommitted Points: 1898 More actions · Answer 3

How can I repair the code, and how to know which code is consuming the high CPU utilization Can you please give me solution.

Thankiing you in advance

grahamc SSCertifiable Points: 6762 More actions · Answer 4

grahamc

SSCertifiable

Points: 6762

September 28, 2010 at 12:37 am

#1228163

Are you upgrading to 2008R2? If so, from what?

kommagoni SSCommitted Points: 1898 More actions · Answer 5

Actually I am migrating the system from Sql server 2000 to Sql server 2008, I am restore the database from Sql server 2000, on that testing server when 2 to 10 users connect that testing server the cpu utilization going up to 100% and after execution its coming back, but my view why cpu utilization going to 100%, which way I need to resolve this issue, because of this users getting slow performance,and hanging the system. This server going to connect around 300 users.

jasonlorraine1999 Old Hand Points: 316 More actions · Answer 6

The Activity Monitor In SQL 2008 will show you the most expensive queries.

Cheers