I'm a newbie, greeting everybody from Hungary, and thanks for your time :) Generally the SQL system runs smoothly. There is a SP which runs two times daily, and it logs the begin/end times. It takes about 20 minutes each time, normally. Suddenly I see that it takes 3-4 hours. Each time the same degradation. Other SPs which have nothing to do with the tables/indexes involved in this SP, suffer from the same degradation, 5-10 times slower, and each slower by the very same factor.
All I could figure out is that this phenonemon has something to do with the IP telephony. When this phenomenon popped up first, the VOIP specialist was installing the VOIP system. Occasionally, when the slow down would come up, somebody would reset the VOIP device, and then the speed goes back to normal. But there are times when this doesn't help. This was the case last Friday, for two days the system was almost unusable. And nobody does know what caused the speed up.
I'm just a programmer, so I can't be more specific. And I'm sitting at 120 miles from the network, so can't investigate.
Have you heard/experienced something like that?
Thank you in advance,
Software/Hardware used: Windows SBS 2008 6.0 build 6002 Service Pack 2, Windows Server Standard FE , Intel Xeon X3430 2.4 Ghz 4 proc. , RAM 8 Gb