August 7, 2025 at 3:19 pm
Hi we're noticing this 2022 server gets into a funk now and then. Specifically, i notice when i script existing tables to the clipboard etc it just hangs with that circle continuing to spin. i notice that if i reboot, the problem goes away for a while. does the community have a similar experience? Unfortunately, this is our dev machine right now.
August 7, 2025 at 5:26 pm
As a guess - how much free resources (memory specifically) do you have when it gets into the funk and what is your max memory configuration? I am thinking it is probably filling the RAM and paging to disk which would make it slow.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 7, 2025 at 5:40 pm
i will try to find out. i dont think any kind of "hog" is running there but i'll show our dba what you suggested. I think that server is basically idle all day, especially now that we've concluded some cdata testing. thx.
August 7, 2025 at 7:54 pm
Another thing it can be that I have seen is if I leave SSMS open and connected to a system for a long period of time, SSMS gets slow. If I disconnect and reconnect to my sessions OR I restart SSMS, performance improves.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 8, 2025 at 1:02 pm
interesting. i generally rdp into that machine and more often than not when i disconnect, ssms is still left running under my creds. let me see if that makes a difference. i'l include this suggestion in the ticket i opened.
August 8, 2025 at 5:30 pm
interesting. i generally rdp into that machine and more often than not when i disconnect, ssms is still left running under my creds. let me see if that makes a difference. i'l include this suggestion in the ticket i opened.
For RDP sessions, it is best practice to log out when you are done not disconnect. Disconnect can cause unexpected behavior if the server needs a reboot as whoever is rebooting it needs to force-terminate your session and your apps will not close nicely.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply