cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Traffic Prioritisation

cortexa
Newbie
Posts: 3
Registered: ‎28-10-2008

SQL Traffic Prioritisation

Hi,
Can anyone tell me what the prioritisation level of SQL traffic running over port TCP1433 and UDP1434 is.
As we seem to be getting quite a bit of lag when trying to perform queries on remote SQL servers.
I'm trying to establish if the traffic is being set to low priority or if there is some other problem.
Thanks,
Lee
5 REPLIES 5
zubel
Community Veteran
Posts: 3,793
Thanks: 4
Registered: ‎08-06-2007

Re: SQL Traffic Prioritisation

Good question, and probably best answered by running a wireshark trace while some queries are being sent and then attaching to a ticket for profiling.
B.
cortexa
Newbie
Posts: 3
Registered: ‎28-10-2008

Re: SQL Traffic Prioritisation

Hi Barry,
Not sure if that's really going to help is it?
How will using Wireshark to monitor the traffic tell me if the traffic is being set to low priority? Is there something in particular I need to look for?
Thanks,
L.
jelv
Seasoned Hero
Posts: 26,786
Thanks: 990
Fixes: 10
Registered: ‎10-04-2007

Re: SQL Traffic Prioritisation

There's an indicator in the packet header that says whether it is Platinum, Gold, Silver etc.
http://www.plus.net/support/broadband/troubleshooting/wireshark.shtml#analysing
jelv (a.k.a Spoon Whittler)
   Why I have left Plusnet (warning: long post!)   
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£14.40/month)
Mobile: iD mobile (£4/month)
dave
Plusnet Staff
Plusnet Staff
Posts: 12,170
Thanks: 19
Fixes: 1
Registered: ‎04-04-2007

Re: SQL Traffic Prioritisation

Hi,
The standard SQL ports 1433 and 1434 will be picked up as gold priority on the network, we class SQL as an "Enterprise Application" so fits in to a similar band with  remote access services like SSH or Remote Desktop.
How much lag are you seeing?
Dave Tomlinson
Enterprise Architect - Network & OSS
Plusnet Technology
cortexa
Newbie
Posts: 3
Registered: ‎28-10-2008

Re: SQL Traffic Prioritisation

Thanks for the info Barry and jelv.
Did a Wireshark and apparently one of our servers was using non-stardard ports which was being set to Bronze priority, did some checking and found out as mentioned by dave that stardard SQL traffic TCP port 1433 and 1434 is set to Gold Priority.
Thanks all for you help.
Lee.