What is the unit of duration in SQL Profiler?
Also to know is, what is duration in SQL Profiler trace?
When looking at the duration field in Profiler, the duration field is represented as milliseconds(1 sec = 1000 ms), but if save the trace to a database or file, duration is represented as microseconds (1 sec = 1000000us).
Furthermore, how do I view SQL Profiler traces? Upon opening Profiler, in the menu bar go to Open -> Trace File, as shown in the picture below. The Open File dialog box appears and we need to navigate to the location where the trace file is saved. Choose the trace file and click the Open button on the dialog box.
Keeping this in consideration, how do I run SQL Profiler?
To open the SQL Profiler in SQL Server Management Studio:
- Click on Tools.
- Click on SQL Server Profiler.
- Connect to the server on which we need to perform profiling.
- On the Trace Properties window, under General tab, select the blank template.
- On the Events Selection tab, select Deadlock graph under Locks leaf.
What is reads in SQL Profiler?
One "read" in Profiler simply equates to reading one 8kb page. This does not equate to IOPS, nor does it necessarily mean that data was read from disk. When performing a read, SQL Server will read data from disk only if that page does not already exist in the buffer cache. SQL Reads are when SQL analyzes a disk block.