One of the more essential SQL Server tools is its trace utility. With it you can view the activity occurring against a SQL Server for diagnostic, informational, and other purposes. Because it lets you ...

In the past, the question of how to perform auditing under SQL Server has had a simple answer: Do it yourself. But now, SQL Server 2000 has eased the burden of auditing by introducing an extensive and ...

SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our current ...

SQL ServerProfiler是一款数据库分析工具，可用于监控SQL语句的执行过程，捕获并追踪数据库中的操作行为，帮助我们分析性能瓶颈、排查问题，对日常运维和故障诊断具有重要参考价值。 1、 本文采用SQL Server 2008R2作为数据库管理系统。 2、 启动已安装的SQL Server ...

In an earlier blog I talked about the difference in mentality between the typical developer and the typical DBA. One of the characteristics of the DBA is the distrust of the Microsoft Wizards. “Give ...