To clarify, this is CF 5. I can't log in right now to see what version of SQL server is involved.
On 11/9/06, Jennifer Larkin <[EMAIL PROTECTED]> wrote: > We are having a problem with our MS SQL server. We have a script that > detect whether or not CF can connect to the SQL server and if it can't > connect, SQL server is restarted. This happens _a_lot_ (like 20+ times > per day-- I had to change the logging settings to find out) and we are > thinking of killing the function just so the sql server stops > restarting so much. > > The reason that the script is there is that SQL server has this > tendency to switch to single user mode and when that happens, CF is > frequently unable to connect. > > I have a theory that this is being caused by the CF app. You see, the > app gets about 35 deadlocks per day. The restarts don't coincide with > the deadlocks and are frequently 20-40 minutes after a group of > deadlocks. (The deadlocks and the restarts frequently come in groups.) > We can't figure out why SQL server keeps switching to single user > mode, but it seems feasible to me that SQL server notices the number > of deadlocks and attempts to protect against the deadlocks by > switching to single user mode. > > Anyway, I know that we should eliminate the deadlocks and I am working > on that but it seems that I'm the only person who is interested in > eliminating the deadlocks. Everyone else just accepts that this is > normal for the app.Unfortunately, the SQL server problem is > interfering with my ability to fix the deadlock problems. (And keeping > me from fixing the problem that I was actually assignd to fix.) > > Has anone else ever seen a SQL server behaving like this? Do you think > that the frequent deadlocks could be the problem? Should I take the > server out back and shoot it? > > Wait, I already know the answer to that last one.... > -- > "If Dag thinks that the only way to contain this is to boil her, then > I'm backing him 110%. That means I can backtrack 10% and I'd still be > completely behind him!" Garth Marenghi's Darkplace > > Now blogging.... > http://www.blivit.org/blog/index.cfm > http://www.blivit.org/mr_urc/index.cfm > -- "If Dag thinks that the only way to contain this is to boil her, then I'm backing him 110%. That means I can backtrack 10% and I'd still be completely behind him!" Garth Marenghi's Darkplace Now blogging.... http://www.blivit.org/blog/index.cfm http://www.blivit.org/mr_urc/index.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Server/message.cfm/messageid:6159 Subscription: http://www.houseoffusion.com/groups/CF-Server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.10
