SQL Server Performance Forum – Threads Archive
Process killed-need help
"On the MYSERVER Server, there is a process that runs to automatically track the user logins into that server. Around 12:37 PM on 3/4/05, there was a lock conflict on MYSERVER, and the process somehow was killed. I restarted the process, but I’d like you to investigate what might have triggered this issue" This is a request mail i recieved from client about.I have never worked before this kind of issues.anyone have any idea how to proceed? Please tell me ur experiences . The stored procedures that run the checks on these logins are (in DBA database on MYSERVER):MonitorUserActivity
RefreshUserActivity
ShowUserActivityand stores datas on table useractivity please advice
For the process to have been killed, it must have been a deadlock.
See the articles on this site for all the advice yuo need Possibly the hard bit will be reproducing the error
Ok thanks I wil refer those articles. Still waiting for more suggessions .
Please somone give some good startpoint for me do some r&d. or tel me som solutions.
Serverlog file i saw the following message 3 times consecutivly.<br /><br />Spid34<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />QL server has run out of LOCKS.Rerun your statement when there are fewer active users. or ask system administrator to reconfigure SQL server with more locks.<br /><br />Spid34:Error: 1204,Severity:19,State 1<br /><br />any idea??
Here are some vaues returnd by sp_configure.<br />Locks 5000—2147483647—0—0<br />MaxserverMemory 4—2147483647—2147483647—2147483647<br /><br />my total RAM size is 328MB . Can anyone guess hw to solve it .<br />I believ Satya is outof station <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /> .
Hey… i’m back, was away for a training.
Rfer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;323630&sd=tech to resolve the issue. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi, Mine is 328MB RAM.SQLserer uses 245MB. i have issued sp_configure ‘LOCKS’ LOCKS—5000—2147483647—0—0 so maximum it can afford 2147483647 locks.means 2147483647 * 96Bytes=206,187,321,123 bytes (206GB) . So configuring sp_configure ‘locks’ ,’0′ make any sense??? whts the pupose of this configuration actually??
Check your other post about configuring the locks… Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>