Network World

SQL Profiler keeps an eye on those Wizards

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 ...
中关村在线

SQL Server Profiler跟踪入门

SQL ServerProfiler 提供了一个功能全面的界面，可用于创建、管理跟踪，并对跟踪结果进行分析与重播。它在实际应用中有多种用途，本文重点介绍如何通过捕获 ERP 系统中的各类事件，定位并解决 SQL Server 中的问题，对测试工作的开展以及故障排查具有重要支持 ...
Network World

Don’t play the victim – use the SQL Profiler deadlock graph

One of the dreaded error codes we get in the SQL log is the “1205”. It represents the infamous deadlock where two transactions are locking each other out. No way ...