SQL Profiler Practice.
![知识共享许可协议](http://i.creativecommons.org/l/by/3.0/80x15.png)
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.
- Make people around you successful is the biggest contribution to ourselves. -