C
cikavuve
Hello guys I need your help troubleshooting multiple issues on Windows Server 2016.
First thing I noticed is when I connected using Remote Desktop and tried to do a query on SQL Server, it took ~7.5 seconds to query 72k rows, but when I connect application remotely on my PC it takes ~3 seconds.
Also I think server has huge Active Directory and DNS problems which might be related to SQL poor performance and if someone can point me in the right direction I would appreciate that so much. I will provide any information you need.
Thanks in advance!
EDIT: I want to add that server also has Active Directory Replication problem.
Continue reading...
First thing I noticed is when I connected using Remote Desktop and tried to do a query on SQL Server, it took ~7.5 seconds to query 72k rows, but when I connect application remotely on my PC it takes ~3 seconds.
Also I think server has huge Active Directory and DNS problems which might be related to SQL poor performance and if someone can point me in the right direction I would appreciate that so much. I will provide any information you need.
Thanks in advance!
EDIT: I want to add that server also has Active Directory Replication problem.
Continue reading...