I’ve been wondering about these connection errors, but put it down to a temporary glitch, until schooner mentioned his own SQL exceptions - different server, but similar problem.
Wonder if the SQl Servers are overloaded. Odd we are now both getting these isues on different servers.
There is only one time of day the SQL servers are even over 30% CPU usage, and that is at 2am EDT when the backups start and it depends on the transaction logs for the day on how long they take.
By the times you are both mentioning I think it may be at this time the errors are happening?
Not sure I understand your question Stephen.. The times I gave were the exact first and latest times that the errors occurred. The same error occurred 9 times within that period.
Thank god for these forums, it would be hard trying to explain this kind of problem over support email.
eh, mssql7 has something happening this morning, I am checking it now, but its been fine prior to about 2 hours ago.
Also if we’re talking max # of SQL connections, that doesn’t relate to CPU… is there any chance the max # of SQL connections per server is being hit?
Is there a maximum?
It is not the SQL server max, it is when the cpu use gets high it blocks connections, but as I said that is only during backups that it should even happen.
It certianly wasn’t at those times for me. We have been seeing sporadic 1-2 min delays/outages randomly. Some last evening, some this morning. Jsut appears to maybe be a SQL issue but hard to know for sure.
Err I meant to say the isues weren’t during the 2AM periods Stephen listed, they were during nromal up times.
Sorry schooner I know my problem is a different server, I don’t mean to hijack the thread - but they may be related.
Stephen, given the times I gave you, is it possible for you to examine the SQL5 server log around those 2 times (or at least the latest one) to see if there’s anything obvious there?
Keep in mind the times I gave are in GMT.
MSSQL7 issue I am working to resolve, the backup application is frozen using 57% cpu +
antic - I meant to say my issues weren’t at the 2AM maintenance times, they were more sporadic like yours. No isseus on posting to this thread, looks like similar issue so the more info the better to help them fix it.
Schooner, MSSQL7 shoudl be better now.
Antic, I am going to have to check SQL5 and do some conversion on times 
But I have to go make my car payment first, I don’t want a repo man coming to take it away (ha, its due tomorrow, so no problem, but I need to pay it as fridays are always crazy)
heh, no problemo Stephen!
Thanks schooner. I guess the only they they’d be related is if there was some kind of intermittent network problem, which is unlikely. But just seemed too coincidental not to butt in.
Antic, feel free to give me a full list of times.
Schooner, any way you cna get times for me to check?
The DNN log viewer gave SQl Exceptio errors at the following times:
5/25/2006 6:12:32 AM
5/25/2006 3:14:51 AM - This is probably during the maintenance period I’d guess.
But it seemed to have some glitches trhoughout the day the last couple days but I have no exact times. Just seemed it was fine one minute, then big dealy, then back to normal. Both I and another user reported it at same time as we were using site and chatting at same time. Both on different ISPs.
I’ll try and keep a closer eye on it and report any issues.
I’ve only got those 2 times on record, Stephen. It only records first occurrence and latest occurrence. But if it happens again, I can post another time.
Oh, no problem, please do so.
Antic - your custom code, that a seperate app you run or part of your main site app?
[QUOTE=schooner]
Antic - your custom code, that a seperate app you run or part of your main site app?
[/QUOTE]
The code is part of a CMS I built, and am busy developing, which a few clients use at the moment. I’ve built script error logging into it, with email notification.
[edit] I don’t bother logging every single error, though an option in the setup can tell it to do that for particular types of errors or in particular scripts/modules.
I am restarting SQL services on MSSQL5 to start the performance counters over.