tag:blogger.com,1999:blog-10846234.post114516912489267039..comments2023-06-22T09:51:55.639+01:00Comments on BOBABLOG: Agile software development and Salesforce: Measuring PerformanceRob Bailliehttp://www.blogger.com/profile/06513796097645814224noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-10846234.post-1145281766453986472006-04-17T14:49:00.000+01:002006-04-17T14:49:00.000+01:00I'd second the interest... plus, I'm curious how y...I'd second the interest... plus, I'm curious how you tell then which areas of memory to increase? I've looked using Oracle's Enterprise Manager application at the memory settings of one of our instances, and don't see much. For example, increasing the memory on the shared pool or buffer cache doesn't show much room for improvement, if any. Cache hit percentage is 94.55% right now...<BR/><BR/>And, with that said, I'm assuming your test is essentially dumping the SQL queries from the database using a tk_prof or similar method, storing those queries and re-executing them on your test environment? Or, are you doing something else like creating an app which connects to the DB, runs the queries at set times (probably threaded, so other threads can connect separately and do separate queries, although at that point, I'd think network bandwidth would be a limiting factor).<BR/><BR/>Anyways, from both a "new" DBA standpoint, and an application developer standpoint, I'm curious and would love more details!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-10846234.post-1145204931763382202006-04-16T17:28:00.000+01:002006-04-16T17:28:00.000+01:00Glad the post's of interest. The plan is to put s...Glad the post's of interest. The plan is to put some details up. But as always, I think the solution is a lot simpler than people would think. It's really just about recording what people do on the live server and then having a method of playing it back into a different database.<BR/><BR/>When I get a chance I'll write some notes up...Rob Bailliehttps://www.blogger.com/profile/06513796097645814224noreply@blogger.comtag:blogger.com,1999:blog-10846234.post-1145177134161665112006-04-16T09:45:00.000+01:002006-04-16T09:45:00.000+01:00Well... in fact I have been wondering for a long t...Well... in fact I have been wondering for a long time how to "measure performance" on a production database in a decent way.<BR/><BR/>We have to monitor client/server applications... connection pooled app servers... and the like.<BR/><BR/>I am very interested in the design of your approach, it would be very interesting if you posted some details.<BR/><BR/>AndreaAnonymousnoreply@blogger.com