本文介绍了如何使用 Microsoft SQL Server 2008 R2 中的性能工具 SQL Server Profiler 来创建追踪，以便监控数据库活动。通过获取数据库 ID 并设置新的追踪，可以利用过滤器来精确捕捉所需的事件。
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.
扫一扫
197
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
