dotTrace from Jetbrains and ANTS Profiler from Red Gate seem to be resonable priced products. I believe both have trail versions.
The IBatisNet.DataMapper.Test.NUnit.SqlMapTests.Perf namespace has tests which compare a SqlMapper to normal ADO.Net. The recent IL enchancements for getting/setting values helped out a lot. I think that feature is disabled by default (add useReflectionOptimizer="true" to your settings to turn it on). ----- Original Message ---- From: Michael Schall <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, October 26, 2006 12:46:15 PM Subject: Profiling .Net code We are running into some performance issues in our applications using iBatis. Looking at a log4net rolling file, times from start to finish of select statements can vary from 15ms to 400+ms for the same call with a sql trace saying that the sp has 0 duration. I am looking for a profiling tool that can help us pin point where this time is being spent. I have downloaded nprof, but it is not the easiest to use, and there are no docs helping me out. What are people out there using for a profiling tool? What have you tried and liked / not liked? Thanks. Mike
