Define specific ports for each database in SQLServer

Navigation
2

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

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

From this I think the problem might be in the routers (either on the client side or on the side of my server). On the client side, we have already done firewall removal tests, instantiating in bridge mode and inserting another router, etc ... but on the server side I still look for options to improve performance.

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

    
asked by anonymous 24.02.2016 / 12:46

1 answer

2

You can not access Database by Port specifies. You can access Instances. Instance is the SQL Server installation 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 SQL Browser service installed with SQL Server.

If your problem is on the network, not anything you can do through SQL Server.

    
24.02.2016 / 13:56
Faster way to add an item to an array, use a structure Create web application that runs JUnit test cases in java files that will be submitted by a page?