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 |
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
 Posted - 2004-09-23 : 18:59:13
|
Are their scripts to help me develop a load test...What are the critical items to test for other than index utilization from sp's and views...Lets assume for the moment that I have already eliminated cursors, DTS packages and that tables are in third normal form.Curious cause I just heard from a friend that a consultant reviewed the db and was only able to site "Load Testing" should be done!!!Lets ignor the fact that I had been asking for the time to do this prior to the production push, and my contract was considered completed once the db went to production. Maybe their are some of you that could give me some tips on an efficient approach to doing this under a time crunch.I have been searching for some tools to assist with this any recommendations?Surf On Dude! |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-24 : 04:10:07
|
| Microsoft have a stress test tool (or is that for Web apps, I forget ...)We have an option in our client application to "log" all SQL sent to the database. (This is logged to the database, so stored in chronological order regardless of the number of connected users)We then restore from backup, replay the SQL [sequentially, but on a single PC] using a variation of the client application - i.e. it "pulls" all the recordsets to simulate the actual time for that part of the client's process [client is just a rendering tool, so no huge processing effort required]), and see how long it takes.We can then adjust indexes or SProcs and try again.For our load testing we are basically trying to establish "how many visitors and orders" we can process on a web site.I reckon that all the load testing tools I've used over the years have taken as long to build testing scenarios as the application took to build! so we decided that using our application to double as the load testing tool was less effort, but YMMVKristen |
 |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-09-24 : 13:35:48
|
| Excellent thank you for your feedback!How was the "log" set up from the client side?Surf On Dude! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-25 : 05:48:31
|
| We have a single VBS function that does the "execute" of SQL to the server (actually, we have a small colleciton - straight SQL, call an SProc with parameters using an execute-string-command and execute an SProc using Append.Parameter). The function records the SProc name and parmeters, or SQL execute string, and then just calls a database Sproc to store that "stuff" into the call log (based on a "load test" switch).If you don't have a central function that executes your SQL you are a bit snookered!(We get some other soin-offs fromt eh central function. It checks for ADO errors on return, optionally lists the SQL call syntax at the bottom of the HTML page [for debugging] and so on)Kristen |
|
|
|
|
|
|
|
|
Load Testing