Network related issue in sql server

  • Hi All,

    We are experiencing some performance related issues on the app server.

    I started my troubleshooting from the db perspective and seems everyting fine.

    I suppose it could be a network related issue from the app server to the DB server.

    Can any one let me know how to check the network related issues (network latency ) from the app server to the DB server.

    Regards,

    sandhya

  • Hi,

    have you check the performance of the statements of the app server with SQL Server Profiler to ensure that the statements are not the bottle necks?

    The same you should check on the app server, especially the sending time of the statements, so you can the sending time of the statement and the starttime of the statement at SQL Server.

    P.S.: Sry for my english 🙂

    Greetz

    pitcher

    [font="Arial"]Kind regards,

    Patrick Fiedler
    Consultant

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]

  • To troubleshoot network related issues start with the below command (run it for some time from the app pointing to the DB server) and see if there are any "Request Timed out" messages or the "time<" duration is considerably high.

    ping DBServerName -t C:\PingResults.txt

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • I take it from your statements and question that you have not done a waitstats analysis. Search web for sql server 2005 waits and queues and you will find a great best practices document on the MS site. Also search for track_waitstats_2005 and use it's goodness to get information on your system. I also recommend the free Ignite tool from Confio.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 4 posts - 1 through 3 (of 3 total)

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