Results 1 to 10 of 14

Thread: Slow connection to SQL Server

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    May 2020
    Location
    Malta
    Posts
    249

    Default Slow connection to SQL Server

    Df19.158
    SQL Express 2012 hosted internally
    Two different Windows Application accessing different databases on the same server and also hosted internally

    Hi,

    We have started experiencing a very sluggish performance on our system. When we load the windows application and the user enters the login name and password, it takes approx 20 seconds to show the application. Reports and processes have also become very slow. Accessing data through Management studio is not slow when compared to the windows application.

    When I login, the login date and time are immediately updated in the user record. So, I don't think it is taking long to establish the connection. I have also rebuilt all the indexes.


    The only change in the architecture was the installation of a new firewall and as far as I am aware, the firewall should not effect the internal access to the db.

    Accessing the data through a web service is fast.


    Any ideas on what else we can check?

    TIA
    Last edited by jcachia; 3-May-2021 at 07:29 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •