locked
SQL Server slow running Windows 7 with RDP RRS feed

  • Question

  • My client moved a server to a hosted environment.  Prior the data connection was satisfactory.  After the move the data is very slow.  Any suggestions to improve speed.
    Wednesday, October 11, 2017 3:43 PM

All replies

  • Where do you see a relation between SQL Server and RDP = "Remote Desktop Protocol"? There is none.

    It's to less on information to give you further advice. How high is latency when you ping the server? How high is CPU utilization on the server? Are queries run from SSMS also slow?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, October 11, 2017 4:33 PM
  • Hi SystemLink Globla,

     

    Normally, Remote Desktop Protocol will not affect the performance of query, besides, you have moved the client to the local host, it should runs faster than before. Please refer to Olaf's reply to check it, this problem may occurs in the following scenarios:

     

    The connection from SSMS on your previous machine and the local machine are considered by database engine as two sessions, SQL Server may generate two different query plans, please check the session setting of two SSMS.

     

    Another possibility is that the resource on your local machine is not enough, it will affect the performance of SQL Server and RDP when they are running together, please check the CPU and Memory usage on your machine.

     

    Best Regards,

    Teige

     


    MSDN Community Support<br/> Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:MSDNFSF@microsoft.com">MSDNFSF@microsoft.com</a>.

    • Proposed as answer by Teige Gao Thursday, October 19, 2017 1:40 AM
    Thursday, October 12, 2017 6:35 AM