HPE Community
Server Management - Systems Insight Manager
1828671 Members
2679 Online
109984 Solutions
New Discussion

HPSIM SQL lock outs

 
Andy Anderson
Occasional Contributor

‎06-06-2007 02:05 AM

‎06-06-2007 02:05 AM

HPSIM SQL lock outs

We are having some issues with SQL Locks occurring on both of our centralized SQL Server Databases. The locks are occurring with our Services accounts to manage SIM we see this reported:

Description:
The program "jTDS" has been blocked for 6 minutes on database Insight_v50_0_104659343 in the SQL instance MSSQLSERVER. The defined acceptable blocking threshold is 3 minute(s). "jTDS" is running on SPID 170 as login ABC\SRVHPSIMTST and is blocked by SPID 95. The resource id is TAB: 86:167671645 []

Now is the time to shine.
0 Kudos
Reply
1 REPLY 1
loafclover
New Member

‎02-04-2011 04:23 AM

‎02-04-2011 04:23 AM

Re: HPSIM SQL lock outs

We seem to be having the same issue on HP SIM 6.2 Update 1. Thou I cant see any errors being generated in the event viewer (both HP SIM & SQL Server) but the server is very sluggish.

It almost comes to a grinding halt and only is responsive if either the processes are killed in the database and or server rebooted !!!

HP or can any one else advise me ? Is this a known application bug in the v6.2 Update 1 ?
and how to fix this issue ?


0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.