SQL Server Profiler

SQL Server Profiler is a tool that allows you to inspect what commands are being executed on your SQL Server database. If you have the management tools installed, then you should already have it on your machine. This is how you can access it:

1. If you are using Microsoft SQL Server, then SQL Server Profiler can be accessed from the Tools menu of SQL Server Management Studio (SSMS):

1. Load SQL Server Profiler and connect to the database that you are using. Name your trace and select the Tuning profile template:

1. Click on Run and you should see that the trace has begun. You are now ready to run your code against the database to see what queries it's actually executing: