April 16, 2007 at 11:57 am
Hi all,
For the past few weeks we've had a very strange behavior with our database server. For almost 10 days now we have a ticket with Microsoft but no lock... here is the story
Basically if we haven't restarted SQL Agent for a while (about 10 hours) our systems are getting slower and slower. The longer we wait the slower our systems get. Then we restart SQL Agent and everything runs fine... What we've done as a temp solution (ugly but it works...) is we created a job that restarts SQL Agent if we have more then 500 connections. The job runs every hour. When this sqlagent-autorestart job is enabled everything is fine but if we disable it the old problem comes back.
At first we thought one of the sql job might be causing this so one by one we deactivated each job and wait a bit to see if the problem was happening still, our conclusion is that it's not caused by one of our SQL Job...
As I said Microsoft support looked into it, as well as the software company providing us with the software using this database server... no luck so far
Anybody experienced something similar to this before? Any comment is welcome
thanks
April 17, 2007 at 1:58 am
What is slow when your system slows down, I mean what do you see as the bottleneck when you leave sqlagent for over 10days (memory,disk or cpu)? Does SQL server consume more memory, cpu or disk is really what I am asking?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply