Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Prioritize connection to IP for MS-SQL

    Scheduled Pinned Locked Moved Traffic Shaping
    3 Posts 2 Posters 2.3k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • R
      Rashef
      last edited by

      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!

      1 Reply Last reply Reply Quote 0
      • A
        albgen
        last edited by

        you can add a rule that match the destination port
        1433/tcp Microsoft-SQL-Server
        1434/tcp Microsoft-SQL-Monitor
        1434/udp Microsoft-SQL-Monitor

        and give them maximum priority

        1 Reply Last reply Reply Quote 0
        • R
          Rashef
          last edited by

          @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-Monitor

          and give them maximum priority

          Thanks!
          Could you explain how to do that in details?  :P

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.