chaft Posted May 21, 2015 Author Posted May 21, 2015 Today eportal was incredibly slow and I had restart the services (again!) I've noticed These errors are cropping up. Event Type: Error Event Source: Facility Data Server Event Category: None Event ID: 131 Date: 21/05/2015 Time: 09:37:06 User: N/A Computer: CHSMIS Description: Exception thrown in function: HandleMLSGetReminders(), place holder 1 .................................................................................................................... Event Type:ErrorEvent Source:Facility Data ServerEvent Category:NoneEvent ID:165Date:21/05/2015Time:09:37:06User:N/AComputer:CHSMISDescription:Win32 exception thrown with info: Win32 exception (C0000005:"Access violation" continuable:Yes) thrown at [1E56F738] ........................................................................................................................Event Type: Error Event Source: Facility Data Server Event Category: None Event ID: 131 Date: 21/05/2015 Time: 09:34:10 User: N/A Computer: CHSMIS Description: Exception thrown in function: CMSecManager::GetOwnerForResource() (ResourceType: 35 Keys: 2014/2015|RTH Expression: owner.code) (pCon: 1df2bae0 pNodeEval: 1e927f38, place holder 12 ........................................................................................................................ Event Type: Error Event Source: Facility Data Server Event Category: None Event ID: 153 Date: 21/05/2015 Time: 09:34:10 User: N/A Computer: CHSMIS Description: ODBC Error; -1; Connection is busy with results for another hstmt ; State:S1000,Native:0,Origin:[Microsoft][ODBC SQL Server Driver] ; Exception Source: CMSecManager::GetOwnerForResource() ........................................................................................................................ Event Type: Error Event Source: Facility Data Server Event Category: None Event ID: 131 Date: 21/05/2015 Time: 09:34:10 User: N/A Computer: CHSMIS Description: Exception thrown in function: CMSecManager::GetOwnerForResource() (ResourceType: 35 Keys: 2014/2015|RTH Expression: owner.code) (pCon: 1df2bae0 pNodeEval: 1e927f38, place holder 12 ........................................................................................................................Event Type: Error Event Source: Facility Data Server Event Category: None Event ID: 153 Date: 21/05/2015 Time: 09:34:10 User: N/A Computer: CHSMIS Description: ODBC Error; -1; Connection is busy with results for another hstmt ; State:S1000,Native:0,Origin:[Microsoft][ODBC SQL Server Driver] ; Exception Source: CMSecManager::GetOwnerForResource() .................................................................................................................... Event Type: Error Event Source: Facility Data Server Event Category: None Event ID: 131 Date: 21/05/2015 Time: 09:34:10 User: N/A Computer: CHSMIS Description: Exception thrown in function: CMSecManager::GetOwnerForResource() (ResourceType: 35 Keys: 2014/2015|RTH Expression: owner.code) (pCon: 1df2bae0 pNodeEval: 1e927f38, place holder 12 ........................................................................................................................Event Type: Error Event Source: Facility Data Server Event Category: None Event ID: 153 Date: 21/05/2015 Time: 09:34:10 User: N/A Computer: CHSMIS Description: ODBC Error; -1; Connection is busy with results for another hstmt ; State:S1000,Native:0,Origin:[Microsoft][ODBC SQL Server Driver] ; Exception Source: CMSecManager::GetOwnerForResource()
Michael Posted May 21, 2015 Posted May 21, 2015 Again all these are very specific e-Portal/Facility errors. Have you contacted whoever supports you for MIS regarding the major sluggish problems you're experiencing?
Michael Posted May 21, 2015 Posted May 21, 2015 Can you post a screen shot of Task Manager, on the Performance tab when your server's sluggish?
michael2k6 Posted May 21, 2015 Posted May 21, 2015 Are you using SQL 2005? If so, try (in Facility Controller) recreating your connection using 'SQL Native Client' rather than SQL Server. If you're unsure how to do this the helpdesk will be able to help you. if this doesn't resolve those errors, the errors are probably a symptom of the problem rather than causing the problem. The simplest way of explaining those errors is a backlog on the SQL processing end. Is you LDF and MDF on a separate RAID array to the O/S? I'm sure the helpdesk will provide suitable help and cover these topics with you also. Mic @ Advanced Learning 1
Scott_L Posted May 22, 2015 Posted May 22, 2015 I've been working on performance issues for a while in multiple establishments. Here are a few things that really helped improve their systems. -Please note these links are ones I've come across that have helped me, you can use a search engine to find them and I (or Advanced Learning) do not represent any of the following sites. It is worth setting up a maintenance plan to look after the SQL DB. https://msdn.microsoft.com/en-us/ms187658.aspx Ensure SQL is configured to utilise the server resources the best it can. A Sysadmin's Guide to Microsoft SQL Server Memory by Brent Ozar Unlimited® Configure the TempDB correctly Best Practices for SQL Server Tempdb--Placement With the MIS DB, set an initial size larger than what is required and set the auto growth to 50 or 100 MB at a time. The less time the server is requesting disk space, the more time it has to do its job. Make sure backups are taken before undertaking any work on a production environment! I hope this helps Scott
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now