zaretto / slimtune Goto Github PK

The new RunDialog in 0.2.0 still doesn't remember the path of the last 
application that was run, between different SlimTune instances. I thought 
that had been announced on the blog and was expecting it!

Sorry but I'm having problems profiling one of our websites.
Currently using Visual Studio dev web server on WinXP

Thanks
Steve Brown

There seems to be some strange behavior in sample counts when a thread is 
suspended for example in Monitor.Wait.

Here's a simple console app to illustrate the behavior:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;

namespace SuspendTest
{
    class Program
    {
        private static object lockobj = new object();
        private static int step = 0;

        static void WaitForStep(int waitStep)
        {
            while (step != waitStep) Monitor.Wait(lockobj);
        }

        static void Main(string[] args)
        {
            Thread producer = new Thread(() =>
                {
                    lock (lockobj)
                    {
                        do
                        {
                            WaitForStep(0);
                            // generate data
                            for (int i = 0; i < 10000000; i++)
                            {
                                double a = Math.Pow(123, 123);
                            }
                            step = 1;
                            Monitor.Pulse(lockobj);
                        } while (true);
                    }
                }
            );

            Thread consumer = new Thread(() =>
                {
                    lock (lockobj)
                    {
                        do
                        {
                            WaitForStep(1);
                            // process data
                            for (int i = 0; i < 10000000; i++)
                            {
                                double a = Math.Pow(123, 123);
                            }
                            step = 0;
                            Monitor.Pulse(lockobj);
                        } while (true);
                    }
                }
            );

            producer.Start();
            consumer.Start();
        }
    }
}

It basically alternates execution in each thread, majority of time spent 
in the for loop. However the results from profiling return very strange 
results.

A dump of SELECT * FROM Callers JOIN Functions ON CallerId = Id gets

    3   2   4   1954    2   2   0
    System.Threading.ExecutionContext.Run
    (System.Threading.ExecutionContext, 
System.Threading.ContextCallback, object)
    3   3   2   1954    3   3   0
    System.Threading.ThreadHelper.ThreadStart   ()
    3   4   0   19  4   1   0
    SuspendTest.Program.<Main>b__0  ()
    3   4   5   1935    4   1   0
    SuspendTest.Program.<Main>b__0  ()
    3   5   0   1935    5   1   0
    SuspendTest.Program.WaitForStep (int)
    4   1   0   39  1   1   0
    SuspendTest.Program.<Main>b__1  ()
    4   1   5   2009    1   1   0
    SuspendTest.Program.<Main>b__1  ()
    4   2   1   2048    2   2   0
    System.Threading.ExecutionContext.Run
    (System.Threading.ExecutionContext, 
System.Threading.ContextCallback, object)
    4   3   2   2048    3   3   0
    System.Threading.ThreadHelper.ThreadStart   ()
    4   5   0   2009    5   1   0
    SuspendTest.Program.WaitForStep (int)

This agrees with display in per-thread trees visualizer, which indicates 
that about 98-99% time is spend in WaitForStep function. However when the 
thread is in that function it is actually in WaitSleepJoin thread state in 
most cases. Even if it would count samples there one would expect the 
samples in wait to be at about 50% due to the symmetry in the threads. 
Even better would be if there was a switch somewhere to disable collection 
of samples in threads that are in WaitSleepJoin state.

Using Win2K3 R2 Web Edition SP2

After attaching the profiler multiple issues were observed:

1. Site failed pre-compile stage with "Invalid Path" errors for pages that
had not already been pre-compilied. "Invalid Path" error points to ASP.Net
Temporary Files directory, but this is not the actual reason for the error.
(See below)

2. Lucene Search Index could not obtain/create lock file in the %TEMP%
directory. 

Further analysis showed that the %TEMP% variable was pointing to the
current logged on user's TEMP folder (under documents and settings). The
Network Service account didn't have rights to write into this area, even
after granting "Everyone" full access to that folder. This is similar to an
issue reported on stack overflow:

http://stackoverflow.com/questions/794323/iis-6-0-and-asp-net-could-not-write-to
-output-file-the-directory-name-is-in


===========

Workaround: 

Go to My Computer->Properties->Advanced->Environment Variables

Change %TEMP% and %TMP% to point to %SYSTEMROOT%\TEMP for the User that
will run the profiler. 

Restart IIS, and log out. Relog in as the same user. 

Reset permissions on %SYSTEMROOT%\TEMP to allow "BUILTIN\NETWORK SERVICE"
full access to the directory.


*** IMPORTANT: Be sure to remove full control for this account after you
are done profiling, especially if you are profiling in your production
environment, as this can cause a security vulnerability. ***

Thanks for a great tool, I hope this info helps you out!

Nick P.
[email protected]

Allow Inlining option already exists, but it is not currently exposed in 
the launcher properties.

What steps will reproduce the problem?
1. Open a profile
2. Open the NProf-Style visualizer
3. Unfold tree nodes

What is the expected output? What do you see instead?
Most nodes take about 3 seconds to unfold and freeze the whole app during 
that time.

What version of the product are you using? On what operating system?
0.2.0 backend, r168 UI

Please provide any additional information below.
Either optimize the code/query or make it run on a background thread and 
show some UI cue of what's going on.

There appears to be some inconsistencies in collected samples data:

For example

SELECT * 
 FROM Samples 
WHERE FunctionID = 2772

gives

ThreadId FunctionId HitCount
    5   2772    230
    4   2772    344

On the other hand

SELECT * 
 FROM Callers
WHERE CallerId = 2772

gives

ThreadId CallerId HitCount CalleeId
    5   2772    1   0
    5   2772    4248    2774
    4   2772    13406   2774
    4   2772    3   3223

The error appears to be in SQLiteEngine.cs in FlushSamples.

Binding for 3rd argument should have been threadKvp.Value.

The title says it all really. 

I think the list of results used when searching for a function in the function 
details visualizer is cropped(to around 200 functions?) and so even if I enter 
the name of a heavily called function it is not displayed if it was called 
after a certain execution time(I think, might have been based on thread as the 
game logic thread takes a while to start...).

If it has to be cropped, then it would be much better to crop based on the 
amount of time in the function(inc children). Also 200 is a very low number for 
a non trivial app in any case.

When building SlimTuneCLR:
1>LINK : fatal error LNK1104: cannot open file 
'libboost_date_time-vc90-mt-gd-1_42.lib'

SlimTune needs instrumentation support. Although this is supported by the
CLR backend, the UI currently ignores all of the data. Apart from standard
min/max/avg data, the storage engine needs to record a statistical
distribution, powered by the binning system. Need to work on a good
heuristic for bin merging as well.

In the Function Details visualizer of version 0.2.0, it would be nice to be 
able to click on sections of the pie chart to go to that method. Even nicer 
would be previous/next navigation buttons.

What steps will reproduce the problem?
1. Get a 3D, SlimDX 2.0 game.
2. Run it in SlimTune.
3. I get no data at this point.

What is the expected output? What do you see instead?
Timing data. No timing data at all.


What version of the product are you using? On what operating system?
2.1, Windows XP


Please provide any additional information below.
I ran it for from about 30 seconds to the time needed to munch on a potato.

There are a number of UI issues/requests I will record here:

Function View:

Displays numbers instead of function names for pie chart tool tips.
Would be very helpful to have better ways of finding functions.
Also hyperlinks for functions names in the pie chart display.

Some sort of inverse pie chart would be very helpful, so for example, 
select a function(eg Vector3.Length()) then a pie chart is displayed which 
shows the numbers of callers to this function from each origin. (even 
better would be the time for this function attributed to each call chain).

Might want to prune the smaller pie segments, otherwise the number of 
legends gets confusing.

Per Thread Call Trees

The little text box at the bottom updates on all mouse moves, would be 
better if it only updated when the selection changed. In addition allowing 
info to be copy-pasted out of the text box would help.

Sometimes when expanding a tree, the selected item will jump to one lower 
down and I have to scroll back up the tree.

Performance Counters

Some sort of UI to select the perf counters...

When starting a profile, the "Connecting to Target" progress box is set to 
always-on-top when it doesn't need to.

What steps will reproduce the problem?
1. Open a v0.1.5 mssql profile
2. Open the Performance Counters visualizer

What is the expected output? What do you see instead?
I see a dialog box saying "This connection doesn't have performance counter 
data", as expected. However, after a second or so (even if I don't close the 
message box), an exception dialog appears saying "The specified table does 
not exist. [ Counters ]" with no stack trace.

What version of the product are you using? On what operating system?
0.2.0 backend, r168 UI, 0.1.5 profile, Win7

When trying to profile .NET 4.0 (beta 2) executables, SlimTune fails to 
connect to its target.

Damnit, I knew I forgot something.

What steps will reproduce the problem?
1. Profile using v0.2.0
2. Open the performance counters visualizer
3. Look at the "Process: % Processor Time", "Process: Private Bytes" and 
".NET CLR Memory: #GC Handles" counters

What is the expected output? What do you see instead?
All three counters show the exact same value which is some kind of 
oscillation between zero and negative values of a ridiculous magnitude. 
Here's a screenshot: http://yfrog.com/0sperfcounterj

What version of the product are you using? On what operating system?
0.2.0 backend, r168 UI, Win7

Please provide any additional information below.
If those counters are only supported in certain conditions, they should 
only appear if those are met.

Sorry Promit :(

Specific filenames:
libboost_thread-vc90-mt-1_42.lib
libboost_thread-vc90-mt-gd-1_42.lib



1>------ Build started: Project: SlimTuneCLR, Configuration: Release x64 ------
1>Linking...
1>LINK : fatal error LNK1104: cannot open file 
'libboost_thread-vc90-mt-1_42.lib'

1>------ Build started: Project: SlimTuneCLR, Configuration: Debug x64 ------
1>Linking...
1>LINK : fatal error LNK1104: cannot open file 
'libboost_thread-vc90-mt-gd-1_42.lib'

Currently the search query used is

SELECT Id, Name 
 FROM Functions F 
 JOIN ( 
         SELECT CallerId, SUM(HitCount) ""HitCount"" 
         FROM Callers 
         WHERE CalleeId = 0 
         GROUP BY CallerId 
 ) C 
 ON F.Id = C.CallerId 
 WHERE Name LIKE '%{0}%' 
 ORDER BY Name 

What is the purpose of joining on Callers table? It seems it just removes 
all functions that never appear as a leaf. Is that intended? 

1)  dbghelp.dll is only delay-loaded for the Release build, not the Debug 
build, of SlimTuneCLR.

2)  Profiled processes continue to crash unless dbghelp.dll is copied into 
their output directories -- SlimTuneCLR seems to completely ignore %PATH%, as 
far as I can tell.  Even if I set %PATH% in cmd.exe by hand, then launch 
SlimTuneUI from that console, and then run the process to be profiled, it 
crashes in the exact same manner.  Copying the same dbghelp.dll from the 
directory referenced by %PATH% into the to-be-profiled exe's directory fixes 
the crash.

Most of the functions listed in the Function Detail visualizer have only 
samples for 
(self), and their pie chart is therefore uninteresting. Coloring the names of 
such 
functions in the list on the left in another color would be nice. You could 
also possibly 
add a checkbox to hide those functions.

Error in implementation causes inconsistency between Callers and Samples 
tables.

DataEngineBase.cs, ClearData function only clears m_callers cache, but not 
m_samples, causing the two to be out of sync for the first batch of 
samples after clear data is called.

I like the graying out of the System/Microsoft methods in the dotTrace 
style visualizer, but it would be even better to collapse them. Ideally 
there would be some way to indicate whether there is a nonfiltered method 
in the subtree. It would be nice if all child nodes that don't contain 
nonfiltered methods would be grouped in a single node showing the 
aggregate data for % time spent.

The Performance Counters and Function Details visualizers should include a 
refresh button, to be used while the profiler is sampling, and for more 
symmetry with the NProf-style and per-thread visualizers.

1.  Run SlimTuneUI without admin elevation
2.  Click "Run..."
3.  Try to close RunDialog

System.IO.IsolatedStorage.IsolatedStorageException: Unable to create mutex. 
(Exception from HRESULT: 0x80131464)
   at System.IO.IsolatedStorage.IsolatedStorageFile.nOpen(String infoFile, 
String syncName)
   at System.IO.IsolatedStorage.IsolatedStorageFile.Lock()
   at System.IO.IsolatedStorage.IsolatedStorageFileStream..ctor(String 
path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, 
IsolatedStorageFile isf)
   at System.IO.IsolatedStorage.IsolatedStorageFileStream..ctor(String 
path, FileMode mode, FileAccess access, IsolatedStorageFile isf)
   at SlimTuneUI.RunDialog.RunDialog_FormClosed(Object sender, 
FormClosedEventArgs e) in C:\tools\slimtune\SlimTuneUI\RunDialog.cs:line 
270
   at System.Windows.Forms.Form.OnFormClosed(FormClosedEventArgs e)
   at System.Windows.Forms.Form.WmClose(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& 
m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, 
IntPtr wparam, IntPtr lparam)

It is a convention in most tab-based software to make a middle-click on a tab 
close that tab. As a user, I expect SlimTune to respect that convention :).

It is currently impractical to find a particular method by its name in both 
views, especially if it doesn't have a big impact on performance. Sometimes, 
it's useful to see how much time a specific method takes, even though it 
isn't a bottleneck. For example, when comparing before and after an 
optimization. A search box (if possible search-as-you-type) would be nice.

I'm not sure if this is even possible, but it would be nice to have some API 
available to pause and resume the data gathering of SlimTune in a 
programmatic way. A static class like what System.Diagnostics.Debugger 
provides for debuggers would be nice, but a hack such as listening for 
specific command strings sent to the debug output (using Debug.WriteLine) 
could also work.

This would simplify the profiling of very specific events. For example, in a 
game I'm developing, I'd use it to profile what happens between the moment I 
click on the "start game" button and the moment the first update frame is 
run. 

Steps that have produced the bug:
1. Start a profile session with an in-memory sqlite database, with the 
default visualizer set to Function Details.
2. After some time, close the profiled program.
3. Open the N-prof style TreeViews Visualizer.
4. Select some stuff, click refresh, select more stuff.
5. Close the window using the X, agree to close the connection.

I haven't been able to reproduce the bug.

What is the expected output? What do you see instead?
A NullReferenceException occurs:

System.NullReferenceException: La référence d'objet n'est pas définie à une 
instance d'un objet.
   à SlimTuneUI.SlimTune.WindowList_SelectedIndexChanged(Object sender, 
EventArgs e) dans 
D:\Promit\Documents\Projects\SlimTune\trunk\SlimTuneUI\SlimTune.cs:ligne 
133
   à System.Windows.Forms.ListBox.OnSelectedIndexChanged(EventArgs e)
   à System.Windows.Forms.ListBox.NativeRemoveAt(Int32 index)
   à System.Windows.Forms.ListBox.ObjectCollection.RemoveAt(Int32 index)
   à System.Windows.Forms.ListBox.ObjectCollection.Remove(Object value)
   à SlimTuneUI.SlimTune.window_FormClosed(Object sender, 
FormClosedEventArgs e) dans 
D:\Promit\Documents\Projects\SlimTune\trunk\SlimTuneUI\SlimTune.cs:ligne 58
   à System.Windows.Forms.FormClosedEventHandler.Invoke(Object sender, 
FormClosedEventArgs e)
   à System.Windows.Forms.Form.OnFormClosed(FormClosedEventArgs e)
   à System.Windows.Forms.Form.WmClose(Message& m)
   à System.Windows.Forms.Form.WndProc(Message& m)
   à System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   à System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, 
IntPtr wparam, IntPtr lparam)

What version of the product are you using? On what operating system?
0.2.0, Win7

What steps will reproduce the problem?
1. Click the Run button in the main window
2. In the RunDialog fill out the Application information
3. In the lower pane, enter some text in the "Results File" text box (for
example just the directory name) and click Browse -> Unhandled exception.

What is the expected output? What do you see instead?
Exception instead of a save file dialog.

What version of the product are you using? On what operating system?
v0.2.1 on Windows XP.

Please provide any additional information below.

Ctrl+O should map to File->Open...

>What steps will reproduce the problem?

1. Download the XNA winforms content pipline sample 
(http://creators.xna.com/en-GB/sample/winforms_series2). Note this 
requires instalation of XNA game studio.

2. Run the sample under SlimTune 0.1.5, open cats.fbx. The application 
will then crash if running in the profiler.


>What is the expected output? What do you see instead?

Application should run and SlimTune should display profile results.

>What version of the product are you using? On what operating system?

SlimTune 0.1.5 and XNA Game Studio 3.0/3.1

>Please provide any additional information below.

I initially found this bug in my own app(which uses the content pipeline), 
but the sample is the easiest way to reproduce the problem.

(I have also had problems with this sample and my own app when running 
under PIX, the app was throwing an exception when processing a texture(XNA 
seemed to incorrectly initialize D3D in order to use D3DX to process the 
texture).

What steps will reproduce the problem?
- Open a profile database created with SlimTune 0.1.5 (MSSQL db)
- Select "Function Details" visualizer

What is the expected output? What do you see instead?
- Instead of showing the function details visualizer, I get an 
ArgumentOutOfRangeException:

System.ArgumentOutOfRangeException: StartIndex ne peut pas être inférieur à 
zéro.
Nom du paramètre : startIndex
   à System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 
length, Boolean fAlwaysCopy)
   à SlimTuneUI.SqlServerCompactEngine.Query(String query, Int32 limit) 
dans 
D:\Promit\Documents\Projects\SlimTune\trunk\SlimTuneUI\SqlServerCompactEngi
ne.cs:ligne 234
   à SlimTuneUI.CoreVis.FunctionDetails.UpdateFunctionList() dans 
D:\Promit\Documents\Projects\SlimTune\trunk\CoreVis\FunctionDetails.cs:lign
e 86
   à SlimTuneUI.CoreVis.FunctionDetails.Initialize(ProfilerWindowBase 
mainWindow, Connection connection) dans 
D:\Promit\Documents\Projects\SlimTune\trunk\CoreVis\FunctionDetails.cs:lign
e 73
   à SlimTuneUI.ProfilerWindow.m_openVisualizerButton_Click(Object sender, 
EventArgs e) dans 
D:\Promit\Documents\Projects\SlimTune\trunk\SlimTuneUI\ProfilerWindow.cs:li
gne 123
   à System.Windows.Forms.Control.OnClick(EventArgs e)
   à System.Windows.Forms.Button.OnClick(EventArgs e)
   à System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   à System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons 
button, Int32 clicks)
   à System.Windows.Forms.Control.WndProc(Message& m)
   à System.Windows.Forms.ButtonBase.WndProc(Message& m)
   à System.Windows.Forms.Button.WndProc(Message& m)
   à System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   à System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, 
IntPtr wparam, IntPtr lparam)

In english: StartIndex cannot be < 0

I'm run SlimTune on Windows 7 x64. And try profile my application (i try both 
x64 and x86 variants). SlimTune successfully connects, start app, but no any 
data collected from my app.
What the problem it can be?

it would be nice to have the times spent in the profiled function, in addition 
to percentage

What steps will reproduce the problem?
1. Call WritePerfCounter with a counterId of any value within [0, 31]
2. Check at the generated graph in Performance Counters view

What is the expected output? What do you see instead?
I expect to see the data logged to counters 0 to 31 but they do not appear 
at all, only counters with ids > 31 work. Counters with ids 1,2 and 3 do 
not interfere with built-in Process: % processor time and such counters.

What version of the product are you using? On what operating system?
0.2.0, win7

Please provide any additional information below.
If that's intended behavior, documentation would be nice.

What steps will reproduce the problem?
1. Open a profile db in 0.1.5 mssql format
2. Open the Per-Thread Call Trees visualizer
3. Click on the drop-down besides "filter"

What is the expected output? What do you see instead?
The drop down drops down and a second later an exception message pops. It 
does not specify the name of the exception or a stack trace, but there is 
this message:

The specified table does not exist. [ Snapshots ]

What version of the product are you using? On what operating system?
0.2.0, Win7

It would be good to support building with Visual Studio Express. This 
would allow a wider range of developers to contribute to SlimTune. 
(including me:-)

The steps needed to allow this:

1) Some build fixes, the repository is missing a couple of boost libs. 
regex + data time(were they built with default options?) [check options?]

2) Move the SlimTune API into the UI solution, Express only allows just 
C++ projects in a solution or C# projects.

3) Add replacement for CComPtr<> => SlimComPtr<> [minimally done]

3) Remove ATL and add our own class factory. [done stubs]

4) Have someone check things still build with Pro for x64 after saving 
projects with Express.

5) Add some docs for additional SDKs needed.

What steps will reproduce the problem?
1. Open a profile
2. Open three visualizers
3. Select the third visualizer tab
4. Close it

What is the expected output? What do you see instead?
I expect the second tab to be selected as the third one gets deleted. What 
I see is that the first tab gets selected and drawn for half a second while 
the third tab is getting closed, then the second tab gets selected. That 
flicker is slightly annoying.

What version of the product are you using? On what operating system?
0.2.0 backend, r168 UI, Win7

What steps will reproduce the problem?
1. Open a v0.1.5 mssql profile
2. Open the Nprof-Style visualizer
3. Attempt to unfold a node in the bottom pane

What is the expected output? What do you see instead?
An exception dialog appears without any stack trace saying:

In aggregate and grouping expressions, the SELECT clause can contain only 
aggregates and grouping expressions. [ Select clause = ,CalleeId ]

What version of the product are you using? On what operating system?
v0.2.1, win7

Please provide any additional information below.
Maybe the sqlite performance fix caused this?

It would be nice to have the functions of the "Function Details" visualizer 
sorted in alphabetical order. Currently, they seem to be in a random order, 
unless they are sorted by number of calls, but that information isn't 
displayed in that visualizer so anyhow alphabetical order would make more 
sense to me.

SlimTune should be able to take snapshots of profiled data, and allow you
to view all available snapshots. It should probably also be possible to
compare snapshots, but this is lower priority.

UI is needed for snapshots, auto snapshots, visualization, etc.

In the current dotTrace visualizer only time% spent in method including 
all children is displayed. It would be beneficial to explicitely display 
the time spent in the method itself. Currently the only way to get that 
info is to sum up all children and subtract from 100%.

It would be nice to be able to load a profile session by drag-and-dropping 
its database file on the main SlimTune window.

What steps will reproduce the problem?

1. Attempted to run with Azure application
2. Couldn't see any output

Is Microsoft Azure Support Planned ?

What steps will reproduce the problem?
1. Open a 0.1.5 mssql profile db
2. Choose the Performance Counters visualizer

What is the expected output? What do you see instead?
An exception dialog pops without a stack trace or exception name but with the 
message:

The specified table does not exist. [ Counters ]

What version of the product are you using? On what operating system?
0.2.0, Win7

What steps will reproduce the problem?
1. Open a file created with 0.1.5
2. Try and open new visualizers(eg perf counters or Function View)
3. An exception is thrown, later SLimTune itself crashes.

What is the expected output? What do you see instead?

Should open, or at least display a dialog saying why the file/visualizer 
cannot be opened and which versions can use the file.

What version of the product are you using? On what operating system?

0.2.0

The graph shown does not represent the actual underlying information. 
Attached is an example shown in Function Details and corresponding Tree 
Graph.

The data in Tree Graph seems to be correct and corresponds to raw dump 
from SELECT * FROM Callers WHERE CallerId = 2527 which returns

    1   2527    0   39
    1   2527    2417    3
    1   2527    2470    1
    1   2527    2535    3
    1   2527    2536    1
    1   2527    2540    15
    1   2527    2541    6
    1   2527    2545    1
    1   2527    2547    1
    5   2527    0   4292
    5   2527    1746    20
    5   2527    2417    184
    5   2527    2470    28
    5   2527    2535    381
    5   2527    2536    6
    5   2527    2540    2447
    5   2527    2541    248
    5   2527    2699    192
    5   2527    2719    10
    5   2527    2742    11
    5   2527    2795    1
    5   2527    2800    4
    5   2527    2823    7
    5   2527    2442    11
    5   2527    2545    6
    5   2527    2815    9
    5   2527    2829    2
    5   2527    2890    5
    5   2527    2547    9
    5   2527    2933    2
    5   2527    2952    1
    5   2527    2959    3
    5   2527    2975    2
    5   2527    2980    3
    5   2527    2858    1
    5   2527    3017    1

From this data it's clear that time spent in self should be much higher 
than what is represented in the graph.

The issue appears to be

const string kInFunctionQuery = @" 
 SELECT HitCount 
 FROM Callers 
 WHERE CallerId = {0} AND CalleeId = 0 
 "; 

which should have SUM(HitCount) instead.

I'm using the SQL Visualizer to check which classes are most often 
instanciated to determine what causes GC pressure. To do this, I'm looking 
for calls of functions ending with ".ctor". However, this finds both calls to 
reference and value type constructors, and I'm not interested in value types 
as they cause no GC overhead. Being able to discriminate between the two 
would be nice.