SQL Traffic Prioritisation

[#1]

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

[#2]

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.

[#3]

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.

[#4]

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

[#5]

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?

[#6]

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.