how to find network issues for sql prod server ?

  • vsamantha35

    SSChampion

    Points: 11004

    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

  • Grant Fritchey

    SSC Guru

    Points: 395449

    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

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

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

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