Diamond Notes

Haven’t posted since late last month. Been busy. We have decided to expand the project around the query sniffer tool to make something a little more all-inclusive. One of my major goals is to have a toolset that I can use to grab queries on the fly from a production server (as querysniffer will) and then feed that it another tool that uses that data to fire them off at a test server to see how the server handles a production load. Kind of like Jeremy Zawodny’s Mybench program on steroids.

Another part to this toolkit is a query analyzer. The idea is this. Grab data with querysniffer and use this tool to analyze the data and report statistics for your production query data. The obvious stat is as follows:

• ranking the queries by number of times in data (showing that query XY executed 1,000 times in 100 MB of captured data, query XZ executed 900 times and query AA execute 765 times and so forth.)

That one is being implemented. I am curious as to what others think would be good stats to gather with the stats part of the package. For now at least, stay away from stats requiring the tracking of time. We are working on how to implement time stamping, but it may not even be possible. Feel free to comment on the posting with statistics features. If you want, you can email me at “kmurphy” at “icontact.com” with these request.
We are making significant progress on the tool bundle. I hope to release some type of beta next week. I actually tested the querybench program yesterday with data from a production server but it didn’t work. Releasing a beta next week isn’t a promise but we are working hard on it and I think there is a reasonable chance it will happen. I will post as soon as there is something for everyone to work with.