Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Severe slowness accompanied by MSSQLSERVER Eventlog error 18056

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

60 Views

RSS

derekhaneman

(@derekhaneman)

Posts: 41

Trusted Member

Topic starter

Running Centricity 10.1.3.300

SQL 2008 R2

We have been experiencing some pretty bad slowness in the late afternoons normally between 3:30pm-6pm Mon-Fri. The weekends we don't see those errors pop up at all. The slowness itself only seems to last 5-10 minutes at a time when it runs into the error but the system is effectively down for that time period.

We've been trying to check to see if anyone is running any reports but that looks unlikely (not impossible though).

We installed a SQL patch last week that we had hoped would solve this issue and it was ok for a week and now the issue came back last night.

The plan is to catch up on the Servers Windows Updates tonight as we have let those slip a little bit.

Anyone else seen that SQL error or run into this issue?

Posted : April 2, 2013 12:15 am

abulsara

(@abulsara)

Posts: 150

Estimable Member

Check this site: http://blogs.msdn.com/b/sqlsak.....8-sp2.aspx

Posted : April 23, 2013 9:26 am

derekhaneman

(@derekhaneman)

Posts: 41

Trusted Member

Topic starter

Thanks for the link.

We had seen some of the SQL related KB articles and discussions on MSDN so we patched up SQL and the problems went away for a week. After about 10 days the slowness and errors came back in force and worse than before and instead of between 3pm-6pm it was all day long.

We now think that the SQL errors were more symptoms rather than the cause. After scrambling and trying to find what could be causing this we noticed that at times pings to the Server would fluctuate and take a bit longer to process and then return to normal, however pings outbound from the server to other areas of the network would completely drop when those fluctuations hit.

Performance ..server CPU load never really exceeds 30% and normally sits around 2-4%, memory sits around 80% used but we have 16 gb allocated just for SQL with 8GBS left for the OS/JBoss. Network monitoring shows that we are barely saturating a 10mb link and its on a gig switch.

We ended up updating the firmware on the server/network cards, installing newer drivers on the NIC, changed ports on the switch, plugged the cable into a different physical card in the server itself and replaced the cable.

We did that Last Wednesday night and so far we have not had an incident. However when we patched SQL we went over a week without incident. Additionally I manually rebooted our virtual server that houses DTS which is not something we do very often. It should also be noted that we reboot the main CPS server which has the applications/jboss/SQL on it weekly.

Posted : April 25, 2013 1:38 am

jdibiasio

(@jdibiasio)

Posts: 66

Trusted Member

I am experiencing the same thing. we never go over 4% CPU, and we only use 50-60GB of 144 GB of RAM. It happens a couple times a day, and only lasts in short spurts

server is on Windows 2008 R2 enterprise

SQL: 2008 R2 10.50.4000

Posted : June 25, 2013 4:11 am

Share:

24 Forums
9,942 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0