August 28, 2020 at 4:09 pm
I left for vacation 2 weeks ago and while I was out, the tempdb drive had to be extended because it was growing like crazy. Before I left, I was monitoring some connections in the Activity Monitor; and upon leaving, I just locked my desktop. Would the Activity Monitor cause the tempdb to grow like that?
August 28, 2020 at 8:45 pm
Offhand, I am not sure if activity monitor could do that, but I would not be surprised. If I remember right, it opens a transaction when you open it and closes it when you close it.
Personally, I have never liked activity monitor. Anything that is constantly pinging my SQL instance is using resources that may be wasted. Monitoring tools are the exception to this but they are also visible to everyone (with permissions). Activity monitor is visible to my one single SSMS session and there is no good way to share the info. And if I forget it on, it is wasted resources.
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply