March 25, 2013 at 12:19 pm
Hi Mates,
One of the instance is hosted in a cluster node with 128GB of ram and 80 processors allocated to this instance...
And last week, we had an issue with temp DB as it was full.We increased the drive space over the weekend.
Now whenever we connect this instance from other server through remote SSMS, we see, refreshing the object including connecting to this instance is very very slow...It takes more than 10 sec. Initially this was not the case. Even hear from end user that the application is performing gradually slow.
I check the network, fregmentation, settings across this instance, and all looks good.
Any suggestions please? Thanks
March 26, 2013 at 3:51 pm
You can take a trace on server which filter is your remote client hostname any query have problem in duration if it do not check your client anti virus or another
security settings
March 25, 2015 at 11:21 am
I never had this issue before, but I recently joined new company and this issue of slow connection to the remote SQL Server 2012 from my laptop SSMS showed up. I research all over everyone provided many solutions and none of them worked. But one thing solved my issue was updating the host file at windows directory at my desktop referred by some forum online, I apologize for not remembering it.
Open the file from C:\Windows\System32\drivers\etc\hosts using a Notepad or any text editor.
I add an entry for my server, lets say my IP as 192.168.2.115 and the host name of the Server IP as dbserver.corp.com as below:
192.168.2.115 dbserver.corp.com
Save and Close the editor.
Make sure to open the above file in admin mode so that you can save the changes.
Somehow name resolving helped me. Hope it helps others as well. I am asking IT guys, why is the case, you never know they might have answer for me.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply