Is there a dirty trick or easy way to check network issues or slow network for the database server without using any 3rd party monitoring tool? Can we use continous ping from some quite non-prod server to prod sql server ? can we do that or is there a better way to do it?
The reason why I am asking is, today some users complained they aren't able to login and seeing connection timeout expired.
We we approached Network team, they said everything is fine. But I personally, experienced disconnects/reconnecting from Remote Desktop tool.
How can we prove there is a potential issue with the network? and issue is also intermittent? look for easy solution which is light weight in nature.
If anyone does have a solution then please share it.