Application runs with different speed for two different user logins on windows server
- by karthi
We have a application in Windows Server that download data from SQL server and store in our local machine. Now the problem I have is my Windows Server has two logins and in one login the app runs real slow, like gets 1 row in a minute, and from another login it fetches 20 rows in a minute. We have this problem only for a last couple of days. What could have caused this?
More details:
SQL server:S QL server2008
Os: Windows server 2008
Access method: Remote connection.
Application: Custom .Net application to get data
Both accounts are limited rights accounts. Any tools to track this? I am not sure what should I start with.