As so many of us know, Red-Gate has some really awesome database tools. The Compare and Data Compare
tools are totally awesome and I donât know how Iâd do many of the
things I do without those tools. Well, I know how Iâd do
them. The same way I used to. But never again will I work
with databases between servers without the help of these tools.
But Iâm here to tell you about ANTS (Advanced .Net Tool Suite) Profiler.
Iâm not going to tell you much other than if youâre not using this tool
to profile your managed code applications, your wasting time with your
other means of gathering information. I canât believe how
intuitive and complete their performance and memory profiling
information is. Actually I can believe it, because Iâve seen it
for myself. I canât tell you just how much you need this
tool. It will blow your mind just how indepth, yet simple, the
tool is to use and produce reports.
Now Iâm not going to provide screenshots and all that jazz for ya. Iâm going to let you go to Red-Gateâs website and see that stuff for yourself. Instead, I want to point out a couple of very awesome items.
Talking about the performance profiler:
1. On the summary page, right when you take a snapshot of the
the performance profile, it tells you the slowest 10 lines of code that
have executed to that point. Click on one, and down in the bottom
it shows you the source of that line of code, points you to the
line, and has a little âtime to executeâ bar graph out to the side.
2. Right underneath the slowest lines of code are the slowest methods to execute with the same type of information.
3. Under the all methods tab, you can see each method that has
executed, what namespace in executed in, the time to execute, hit
count, source file and each of those columns can be sorted and the
namespace column can be filtered and sorted. Click on a method
name it in the pane below it shows you the source code.
Talking about the memorty profiler:
1. On the summary page it shows the top 10 largest objects and the
top 10 classes with the most live instances at the time the snapshot
was taken.
2. Under the all classes tab, you see the namespace, classname,
module name, live count, live size in bytes, total number created and
the total size. All columns, again, are sortable.
For me, and probably for you too, ANTS
is the easiest tool out there to use for profiling your code. You
NEED to be using this tool. Its much easier to use and contains
much more information than what CLRProfiler provides (granted,
CLRProfiler is free). Its also uses about half the memory, when
running, than CLRProfiler. For the money, the Red-Gate ANTS Profiler canât be beat.