Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
 Posted - 2012-07-10 : 14:34:36
|
| We are testing a new database with a few tables, stored procedures, indexes. This database is going to be accessed by 10000 users/day. The goal is to show performance stats. What are the steps or What is the best way to do an unit test for a new database on the performance level? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-10 : 14:50:22
|
| start with capturing various performance counters by running profiler trace------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-07-10 : 15:05:28
|
| Testing is a profession in and of itself. However, there are several things you can do and several ways to go about it. There are various programs that you can use to generate load. Some will capture a trace and play it back (http://sqlloadtest.codeplex.com/) others will generate random loads. If you are using VS 2010, you might have access to Test projects that you can use to unit test SQL (http://www.codeguru.com/csharp/article.php/c18555/Unit-and-Load-Testing-With-Team-Foundation-Server-2010.htm). Some people are not as comfortable with .NET as they are with SQL so you could just to Unit tests in SQL. But, I think you'll find Test project(s) much more powerful and you can use them to stress test your DB too.I don't agree with all of it, but here is a 3-part series on different aspects of testing a DB:http://www.sql-server-performance.com/2005/10-baselining-tips/http://www.sql-server-performance.com/2005/monitoring-8-steps/http://www.sql-server-performance.com/2005/stress-test-part3/EDIT: Found the other article (series) on using VS 2010 for testing that I was looking for:http://blogs.msdn.com/b/atverma/archive/2010/07/28/how-to-unit-test-sql-server-2008-database-using-visual-studio-2010.aspx |
|
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2012-07-11 : 14:08:41
|
| Thanks for the links. I actually need a tool to grab the stored procedures and test them one by one (regression test). Then on top of that I need to find out if DB is able to handle all the data. |
|
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2012-07-12 : 12:50:08
|
| I have vs2010 professional and this version doesnt have create unit TEST. Any other options? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-07-12 : 13:38:36
|
| I'm not sure of the differences as I have not used NUnit in a long time and I've never used DBUnit, but DBUnit is (as is my understanding) more specific to DB Testing.http://sourceforge.net/projects/dbunit/http://www.dbunit.org/ |
|
|
|
|
|
|
Testing