DBA in Unit 7 (12/15/2010)
Yes, you are right. I am looking at a 'performance' problem. The application side was complaining that it is slow to pull out of data from Database. and I went to the server, this high network I/O waits is the only thing that looks out of normal to me.
I am thinking it is something with the APP side too in my case.
As DBA, before we are proved innocent, we are always Default Blame Acceptor.
I have to show them something:
Could you please give some advise on the methods to get the proof showing the app side that their DB requests are processed and waiting on the APP side?
I'll run offending query both from the application and on the server.
If query takes about the same time then you are ruling out network as the root cause of the issue and you can focus on fine tuning the query.
If query from app side really takes much longer then you contact your Network guys and ask them to monitor network status.
Just for fun...
how many hops in between app client and server?
what's the latency in between app client and server?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at Amazon and other bookstores.Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.