cancel
Showing results for 
Search instead for 
Did you mean: 

Monitoring MS SQL Deadlocks 一些Prognosis在MSSQL配置上的问题(非开箱即用)

IR Partner

Monitoring MS SQL Deadlocks 一些Prognosis在MSSQL配置上的问题(非开箱即用)

Q1:特定显示SELECT * FROM TBDemo1,2,3等,忽略条件where后面的所有参数,如何合并显示并统计sql的性能参数;
Q2:把sql放进prognosis定时执行返回结果;
Q3:关于超时和运行中的sql,需要Q1和Q2作为前提;

Q4:我想找出发生死锁的sql,在配置event log监视1204和1222两个ID后,我用sql语句模拟deadlock并没有触发相关的event记录,我做了relay功能去检查,MSSQLSERVER是正确输出的(理论上产生了DeadLock这里也会有产生一些log?),但是1204和1222在模拟deadlock后prognosis可以见到已产生死锁,但是都没数据输出到event log

1 REPLY 1
Community Manager

Re: 一些Prognosis在MSSQL配置上的问题(非开箱即用)

Hi There!,

 

Prognosis does have an out-of-the-box display "SQL Server Locks" that should detect deadlocks. Is it useful for this problem? described in Online Help:

Prognosis for Infrastructure > Prognosis for Distributed Systems > Database Server Management > MSSQ...

 

And to configure Prognosis to monitor MSSQL:

Prognosis for Infrastructure > Prognosis for Distributed Systems > Database Server Management > MSSQ...

 

Latest versions Prognosis 11.4 and 11.5 support Microsoft SQL Server 2017 and recent previous versions of SQL Server.

The license for "Prognosis Database Server Management" (PDS license code) is required.

HTH

Blog: What Optimal Transaction Performance Means

A number of our customers use Prognosis to monitor the health of their payment systems. As part of this, they monitor the transactions flowing through the system ...

Read blog
Top Liked Members