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'
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.
