SAP CCMS and SQL Server Blocking session :- question Posting second time

[Former Member]

We are on NW 7.01 and SQL server 2005 and I want to monitor Blocking sessions

You can see these Blocking sessions in

DB02 -> Database Processes --> Blocking session id ( This is Fourth column, which I want to monitor using SAP CCMS)

Using SAP CCMS I want to monitor these "Blocking session id"

i.e Alert should be generated when blocking locks exists in system.

Is it possible to do this? In SAP CCMS I did not see any "method" which I can use it. So how I can achive it?

Any help is much appreciated.

[Former Member]

Hi Sandeep,

I just browsed through RZ20 and I found one node <SID>\Microsoft SQL Server\Performance\CPU\Oldest blocked Spid and MTE class CCMS_MSS_PERF_ma . This will give you the Oldest blocked Spid. I am not sure how much it is useful.

Moreover, I would suggest rather use MS SQL server management to alert the blocked sessions instead of CCMS if it is not catering your requirement.

I got one blog where you will get the code for SQL server which you can configure to alert the blocked sessions.

http://hassanszone.wordpress.com/2011/03/19/sqlserver-block-monitoring-mail-reporting-using-sqlagent...

May be this help you.

Thanks,

Jagadish.

[Former Member]

Hi Sandeep,

I would also suggest to post this query in SAP on SQL server so that you may get some more suggestions/guidance.

Thanks,

Jagadish.