Try out following test case to check the slowness issue.
If the slowness issue is on the server system
1. Check the query that is taking to long to load the data on the server system
2. Check the indexing and create the Indexing.
3. Check the RAM and CPU usages on the server system
If the slowness issue is on the client system
1. Check the ping connection issue if the ping is getting higher then the 5ms then we need to talk to the client to check this issue to their networking person
2. If the ping connection is fine then do the software installation in the local system
3. If after the software installation in the local system then also the software is slow then do the following step
open Internet Option --> Advanced --> in advance option there is one field name as Security --> uncheck two options
1. Check for publisher's certificate revocation
2. Check for server certificate revocation
4. After all this step if there will be a slowness issue then disable the TCP/IP option in the SQL server configuration management and restart the SQL services.
Comments
0 comments
Please sign in to leave a comment.