October 22, 2014 at 1:34 am
Hi,
We are running SQL Server 2008r2 SP2 Standard Edition.
Connections into an instance came in from various application servers. Connections from a specific server are causing us performance issues. Is there any way with 2008r2 Standard Edition to limit the number of connections from a specific location. Connections from other servers are not causing us issues.
I am assuming this cannot be done at Standard Edition and we'd require Enterprise and Resource Governor.
Thanks in advance.
Rick.
October 22, 2014 at 2:18 am
Resource Governor would be a perfect fit for this.
In Standard Edition there's not much you can do. You could refuse connections from an application server in a logon trigger, but that would cause errors in the application and I have no idea whether that is ok for you or not.
However, instead of limiting resources or refusing connections, I think you should try to identify the root cause of the performance issues and fix them. Have you tried that?
-- Gianluca Sartori
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply