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