Prioritize connection to IP for MS-SQL
-
I've just started up a pfSense box for my company.
At the moment we are using a CDN connection (about 2 MBit up/1.8 Mbit down) and we need to connect our ERP software (run on Windows 2003) to a remote MS-SQL server.
But when a user download something the connection of our ERP to SQL dramatically slow down (sometimes it's not even able to connect to SQL!).There is a way to give max priority to this connection?
thanks in advance!
-
you can add a rule that match the destination port
1433/tcp Microsoft-SQL-Server
1434/tcp Microsoft-SQL-Monitor
1434/udp Microsoft-SQL-Monitorand give them maximum priority
-
@Evald:
you can add a rule that match the destination port
1433/tcp Microsoft-SQL-Server
1434/tcp Microsoft-SQL-Monitor
1434/udp Microsoft-SQL-Monitorand give them maximum priority
Thanks!
Could you explain how to do that in details? :P