February 13, 2003 at 12:37 pm
Hi,
Wondering if anybody can help me with advise:
Original trouble.
Tere has been an ongoing trouble with our SQL users/clients disconnecting intermittently throughout the day. When the customer moves the WAN connection to a slower speed backup circuit there is no longer any troubles/disconnects. Customer is using MS2000 SQL server to run an accounting application called CMS. Clients are using MS2000 SQL client for CMS.
Our findings up until today.
We have made several changes on the customers router and found a couple contributing factors to affect the disconnects positively and negatively.
Contributing factors
1. Customer has applied a video conference policy on the router. When this is taken off the SQL disconnects stop.
However, this same policy is also applied to all other 3 remotes, but neither of them have the same SQL disconnects problem.
SQL setup
-The customer has 4 remotes sites, and one host in Toronto.
-There is one sql server for each office for document management.
-The Accounting (CMS) server is one only in Toronto as it does not support replication.
-The sql server has a userid/password pair for each user set by the accounting program. The program actually picks up the active directory userid and add cms in
front for the sql user id, and the password is some kind of hash from the userid.
-There is no replication, however there are scripts that the customer wrote to add file number to the document management server twice per hour from the accounting server.
-The customer has found that there is no errors on the server-side at all.
February 13, 2003 at 1:12 pm
Keep in mind that I have foundational knowledge of networking concepts, but am in no way an expert, especially as far as QoS is concerned. But here are some questions that came to mind:
(1) Is QoS applied on the backup circuit with the same video conference policy?
(2) How heavily is video conferencing going on with respect to each of the 4 circuits?
(3) Has SQL Server traffic been prioritized over normal traffic or is it in the same grouping as everything else (email, web browsing, etc)?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
February 13, 2003 at 2:59 pm
Thanks for reply.
Q) Is QoS applied on the backup circuit with the same video conference policy?
A) Yes.
Q) How heavily is video conferencing going on with respect to each of the 4 circuits?
A) the load is moderate.
Q) Has SQL Server traffic been prioritized over normal traffic or is it in the same grouping as everything else (email, web browsing, etc)?
A) It is in the same grouping.
Thank you very much.
Vato
February 13, 2003 at 3:58 pm
Sounds like someone needs to go look at that video conference policy, though. If removing it solves the issue, and other links have the policy and don't have problems, it might be a config issue. Perhaps someone fat-fingered something on that one circuit's config? I'll check with a QoS guru I know and see what he says. Cisco equipment?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
February 14, 2003 at 7:14 am
Hi Brian,
Thanks for your replies. Yes, there's Cisco equipment. However, at this point today the customer has finally indicated through a voice conversation that this is no longer an issueand, I am not sure what to assume... At this point we are trying to have this confirmed and explained in writing. Sorry to have dragged you into this for nothing.
Anyway, your response was very much appreciated.
Thanks again,
Vato
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply