If you were on normal SQL Server, you might consider using SQL Profiler.
如果你是在正常的SQL服务器,您可能会考虑使用SQL事件探查器。
If you were on normal SQL Server, you might consider using SQL Profiler. You'd be able to see what is getting executed against the database.
如果你是在正常的SQL服务器,您可能会考虑使用SQL事件探查器。你可以看到什么是要对数据库执行。
Note that the IBM Data Studio Developer tool offers a debugger and an SQL profiler component that can be used to analyze execution of SQL PL procedures.
注意,IBMDataStudioDeveloper工具提供了一个调试器和一个SQL分析器组件,可以用于分析SQLPL过程的执行。
The simplest approach is to use SQL Profiler. There is "Deadlock graph" event in the "Locks" event group you can use. Click on the picture to open it in the different window.
最简单的方法就是采用SQL自带的性能监控工具,这里我们可以使用跟踪属性下面的事件选择项卡,展开锁节点,下面的有一个死锁图可供我们选择,它能帮忙我们分析死锁原因。
A user name and password for a user who has sufficient privileges to start and operate a statement event monitor as well as to create a schema where the SQL Profiler holds its local data.
某用户的用户名和口令,该用户拥有足够的权限启动和操作语句事件监视器,以及创建模式,而SQL Profiler将在该模式中保存其本地数据。
In previous articles, I have described how to find performance using the SQL PL Profiler and logic problems using SQL Procedure Tracing.
在前面的文章中,我曾描述了分别利用SQLPLProfiler和SQL过程跟踪来发现性能和逻辑问题。
The SQL Procedure Profiler (or simply SQL pl Profiler) tool can be set up as an applet accessible through a Web browser, or it can be set up as a standalone application.
既可以将SQLProcedureProfiler(或简称为SQLpl Profiler)工具作为applet安装,并通过Web浏览器来访问,也可以将之作为单独的应用程序安装。
The SQL Procedure Profiler (or simply SQL pl Profiler) tool can be set up as an applet accessible through a Web browser, or it can be set up as a standalone application.
既可以将SQLProcedureProfiler(或简称为SQLpl Profiler)工具作为applet安装,并通过Web浏览器来访问,也可以将之作为单独的应用程序安装。
应用推荐