Notifications
Clear all
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
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
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
