Using the SQL profiler
The SQL profiler is a very helpful tool to monitor the T-SQL command sent through NAV by a specific user. Let's take a look at the basic configuration of this tool.
How to do it...
Go to Start | All Programs | Microsoft SQL Server 2008 R2 | Performance Tools | SQL Server Profiler.
Click on File | New Trace. This should prompt a new window to connect to the SQL Server.
On successful connection to the SQL Server, the next window will be Trace Properties.
Provide a name to the trace and the saving details. Open the Events Selection tab to choose an event and a field, which needs to be recorded.
On completion of the setup, click on Run. This will begin the trace and we should get an output similar to the following window:
How it works...
We can see, username reads and writes on the database execution time and actual query in our trace result window. There are many fields and events, which can help to trace issues, such as system slowness.
See also
Identifying Blocked and Blocking...
