Set specific ports for each database in Sqlserver

Asked

Viewed 236 times

2

Here at the company, we have a dedicated server hosted in a datacenter that maintains numerous databases using Sqlserver. These databases by default are working from port 1433 where it is already open to customers.

Today, I’m having difficulties regarding the connection speed of some people, and at peak times of work but, my server even at these times does not reach half the capacity that it supports both processing, hd(ssd), as memory.

From this I believe that the problem may be in the routers (either on the client side or on the server side). On the client side, we have already done firewall removal tests, instantiate in bridge mode and insert another router, etc... but on the server side I still look for options to improve performance.

I wonder if there is any way I can define a specific port for each database, so I could make each client access its port and (in theory) reduce the load of data traffic to server and firewall on the router.

sql-server

1 answer

2


You cannot access Database by Port specifies. You can access Instances. Instance is the installation of SQL Server itself and you can have more than one on the same machine. When there are multiple SQL Server instances on a network it is necessary to leave the service started SQL Browser that is installed next to SQL Server.

If your problem is on the network, there is nothing you can do through SQL Server.

  • Okay. So I get it. so if I generate instances for each database I can then define a specific port for each one, so it solves my problem... this not to mention that the processing queues are also by instance rs, worth partner for the idea

  • 1

    Remember that in order to install multiple instances on the same machine you will have to assign a name to each of them (Named Instances). This will affect the connection string of the systems. Also remember to distribute the resources of the machine between the instances (Memory and CPU)

  • Yes, to some extent it is better than having only one instance. because I have clients big and small on the same server and their flow changes.

Browser other questions tagged sql-server

You are not signed in. Login or sign up in order to post.