chaft

yes. I logged a call yesterday with them

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()

15.1 is a whole other thread . Hopefully i won't get assigned those problems. I'm hiding under a rug from that atm. Monitoring registers is my top priority at the mo

we also now restart the services an hour before registration each day in the morning. although we had the resets in the evening i was concerned that i heard it often needs two resets on the services to actually have an effect. hopefully this too will help. the test will be whether the registers get slower in the afternoon periods

I will be able to know for sure by friday if the ip link resolves the problem but so far we've had positive responses.

Memory is lower than we would like for an MIS server but it's an old server and adding memory would be ideal but at the moment we don't have the budget to as we are moving to a new system in the summer. Also it's a little risky as any hardware change could cause stability issues. That aside the available reserved memory is about 500mb and the page file never fills up more than half way. The cpu isn't too high, it peaks at 70% at times but balances out between 5% and 50% most of the time with plenty of idle time too. Again upgrading that is ideal and in the summer we will move to a visualized server. For now I'm just trying to get the best of the system without too much risk or expense. This system did work for the last 7 years fine. Only recently it hasn't update on the ip address link---- It's working well. I can't explain or don't understand why it would work better. Does anyone have any idea why as I'd like to learn why it might impact performance.

The ram is a little low, but most of the time the 'available' reserved memory is 500mb and using process explorer i've never seen physical memory peak to it's maximum. The PF hardly changes from 4gigs and I have set it so it can grow to 7gig. I'd admit the 4gb is low for such a MIS but it's an old server and has for years been fine at the role of doing eportal. The server is exclusive to this role. The cpu isn't really taxed that hard in my opinion. I rarely see it peak to 70% of it's full potential. mostly hovers between 5-60%. There is plenty of idle time too. I've suggested adding more ram but this is an old server and adding ram is a risky maneuver even if it seems the obvious thing to do for performance. I've seen servers die after hardware changes. Long term we are moving the server to a visualized environment but now it's about keeping stability and lasting it out to the summer but resolving the performance as best as we can with what we have. It went from working fine to being slow recently. update-- i've had a few respond positively to the IP address link.. will update later if it holds throughout the next series of periods

my boss says easter but is there a way i can double check whether the transactional logs were done or not and when? the temporary internet files option is a group policy thing the users don't have access to change themselves. I'll have to think about whether that impacts anything else but it has been recommended for other eportal events issues. Not ruling it out though

rightio have sent the ipaddress out to some staff and will see that helps or not

yes i can get an ip http://(local ip)/eportal/index.jsp will this help with performance of the site if i point people to this address instead?

well I assume dns as they don't type a IP address in. They have website address but it's destination on one of our servers ( http://chsmis/eportal/index.jsp) i don't get an ip address from pinging this. It's an internal file.

A DNS name

I'll try the restarting the pc option. Thanks. I'll let you know if it improves the situation

Each morning begins the same with frantic emails telling me that staff can't access or get into registers and some waiting ages for screens to load. Then after the registration time the MIS comes to life and is usable again. I've used process explorer to monitor the server but the cpu barely peaks above 70% , the network and disk don't particularly go mad at registration times and yet the performance greatly suffers. We installed 15.1 of eportal/facility recently in hope that it resolves the performance but instead brought new problems of events being blank whilst keeping the same performance issues. We're not exactly a huge school but does anyone have eportal not slowdown to absolute crawl at registration time? I've followed their tech sheet for the problems: ................................................................................................................................................................................................................................................................................................... Below are links to guides to enhance the performance of ePortal. Please run through each of these articles one by one if you are experiencing performance problems. Before making any modifications please ensure that you have taken a back up of Facility Admin and made a copy of the ‘ePortal’ folder (usually located in C:\Facility\ePortal\Webapps, assuming a default install) to ensure you have a back up copy of the current configuration settings. Checking the Server Details Check the current server specification - intel xeon 1.9ghz 4gb ram Available disk space on server -10gigs on all disks free Size of audittrail and transaction Log -cleared at half term Check for multiple installs of ePortal -none Check for open ports -nothing has changed Conflicts with other software -no new software except eportal updates Check the regional settings -england gmt Scheduled task for an overnight stop/start of eportal -yup we have 2 batch files Check network communication between SQL and ePortal servers (if separate) -they aren't separate Force network speed for adapters and switches -haven't tried yet, not sure if applicable Monitor disk usage -yes and it doesn't seem intense but what measurements should i compare too? Disabling Microsoft Group Policy to troubleshoot poor ePortal performance -really don't want to have to do that SQL server priority boost setting -not done yet ePortal Configuration Settings Check the contents of the webapps folder -removed old files today Changing configuration files for roll call/registration -done Comment out alerts and behaviour bitlets Updating/Removing Data in Admin Reduce number of Admin users -not sure if we have too many but we try to restrict this Check number of users with BMFULL access Set behaviour alerts to expire -i am looking into this at the moment, but we are debating whether we will lose important information Remove all expired messages Regards Paul ......................................................................................................................................................................................................................................... Is anyone else having Eportal issues of slowdown? have you resolved yours? if so please help me.