October 23, 2010 at 10:04 am
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
October 23, 2010 at 11:27 am
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
October 24, 2010 at 1:48 am
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
October 24, 2010 at 10:43 pm
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