how to find network issues for sql prod server ?

  • Hi Experts,

    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.

    Thanks,

    Sam

  • The ping command is your buddy.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply