Ron Anderson wrote: > In the SQL 2K resource Kit, there's a "data hammer" component that can be > used for load testing SQL. It's in VB, simply compile and run.
Much easier: join all your tables together in carthesian joins, put the query in a cfm and hit refresh 5 times after eachother. On a medium sized database each query will return a few million rows, which is easily enough to really test your server. If that doesn't throw the server to the roof throw in some unions until it does. And if you want to play rough throw in some updates/inserts/deletes at the same time, but if you do that I would seriously recommend backing up the server first. I know databases that can handle that, but I am not familiar enough with MS SQL server concurrency control to say that about MS SQL server. Jochem ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
