Sql server really slow, unless i eliminate the gateway

Home Forums Other Microsoft Servers and SaaS SQL Server 2005 / 2008 / 2008 R2 / 2012 / 2016 Sql server really slow, unless i eliminate the gateway

Viewing 1 post (of 1 total)
  • Author

  • Kobe 310

    I’m using a software program that was hosted by another company, and it ran fast, now I host it and the query’s run slow. if I put no gateway on servers nic, then it runs blazing fast. I ran wireshark on it, (my backup server) new to wireshark, don’t really understand how it works, but i figured it’s worth a try. I’m trying to analize the diffrence between the query’s with and without the gateway, any suggestions. I have to have the gateway for production.

    Here is what I’ve done,

    cisco router
    using virtual machines
    created another nic, and went straight to comcast modemrouter(diffrent network(3), i have 3 comcast modems), still did same thing. so i’m pretty sure i just eliminated my network.
    I have support with vmware, they boosted my box to 6 cpu’s and 6g ram, there are only 5 users. they log on through terminal services inside the network.

    Hope that helps


Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Don't leave your business open to attack! Come learn how to protect your AD in this FREE masterclass!REGISTER NOW - Thursday, December 2, 2021 @ 1 pm ET

Active Directory (AD) is leveraged by over 90% of enterprises worldwide as the authentication and authorization hub of their IT infrastructure—but its inherent complexity leaves it prone to misconfigurations that can allow attackers to slip into your network and wreak havoc. 

Join this session with Microsoft MVP and MCT Sander Berkouwer, who will explore:

  • Whether you should upgrade your domain controllers to Windows Server
    2019 and beyond
  • Achieving mission impossible: updating DCs within 48 hours
  • How to disable legacy protocols and outdated compatibility options in
    Active Directory

Sponsored by: