SQL Profiler Practice.

1.  Microsoft SQL Server 2008R2->Performance Tools->SQL Server Profiler.

2. Before start to run a new Trace for you DB you should to get you DB id by this way;

use master

SELECT * FROM sysdatabases WHERE name = 'DBName'

3. Create a new trace.

 

 4. There has a lot of event and history in list, so we need some filters to get what we want .  We need to define some right condition for the filters.