October 26, 2009 at 1:05 am
Hi,
I am new to Performance testing. Rite now we are doing performance testing for our .net application using JMeter tool. Since we are getting high response time in our tool, we are trying to find the performance of our DB also.The biggest problem is we are having multiple DB. The application uses multiple DB to retreive data such as account DB, License DB , etc and then login into the application. Kindly help me out in this regard.
October 26, 2009 at 5:04 am
please help me to do performance test for DB.Kindly help me in this regard
October 26, 2009 at 7:10 am
There are a lot of ways you can do it and a lot of different types of performance tests. Are you trying to do a performance test based on the amount of data in your databases? Then you need to generate a load process that will bloat the data. I generally go with a one, three and five year data load. Are you trying to test performance based on the number of transactions. Then you need a mechanism for generating lots of calls to the database. You can build your own, but picking up a third party tool such as offerings from Idera or Quest would be the better way. Do you want to simply test your system? Then you can use I/O test tools available from Microsoft.
One mechanism that you'll probably want to do, regardless of the tests you're running and way you run them, is to use a server side trace process to capture all the procedure and query calls against the database. You can then use Profiler to play this information back on a different server. You'll just need to ensure you restore to an explicit point in time on the test server so that the data is exactly the same as when the trace information started.
It's a very large topic, but some of that could get you started. I outlined how we do performance tests in this article on Simple-Talk[/url]. It might help. We did a combination of load and data testing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2009 at 1:00 am
Thanks for the response. We are using JMeter to find the response of the site.
But the client requirement is to find the percentage of time taken for DB to respond to site .Can we find the response time of DB when the JMeter script is running in parallel. Can we use SQL profiler in this regard
October 27, 2009 at 5:24 am
vaidehi.rajamani19 (10/27/2009)
Thanks for the response. We are using JMeter to find the response of the site.But the client requirement is to find the percentage of time taken for DB to respond to site .Can we find the response time of DB when the JMeter script is running in parallel. Can we use SQL profiler in this regard
You could do measurements with Performance Monitor and collect query metrics with a server side trace, yes. Don't use the Profiler gui to collect performance metrics. The gui can add overhead that will invalidate the results.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 1, 2009 at 9:51 pm
Hi All, my team is ussing @analytics performance tool to monitoring, it is a excellent tool, integrate SQL and Windows Monitoring, you can request it as trial version for 15 days, you should try it,
go to
http://www.analyticsperformance.com/
Regards
November 2, 2009 at 1:16 am
Thanks for the reply.. I ll try that too
November 2, 2009 at 3:33 am
We checked using perfmon that the CPU utilisation is 80 % . Is this the correct level or is it higher. Please clarify further
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply