Diamond Notes

We made a minor update to the QPP toolkit today (”ver. 1.01″). I uploaded the new files to the website. They can be found at http://www.paragon-cs.com/queryprogs. In addition, I have beginnings of a tutorial located at http://www.paragon-cs.com/queryprogs/tutorial.html. It will make this a bit easier to understand.

A couple of people have asked how the QPP toolkit is different than other programs. Please give me a minute to try and explain. QPP can be used to capture queries being executed on a production server at any time. In addition, it will take the captured queries and insert the text of those queries plus timing and host information into a database which you can then use to determine where your servers are spending time executing queries. Finally, you can take that same data that you gathered from a production server and use to generate benchmarking and load tests against a test server. If set up properly these tests can be repeated as many times as needed.

Hope that helps!!