Network Interface 100%
Posted 11 May 2005 - 01:52 PM
Could you please help us solving the issue?
Posted 11 May 2005 - 03:39 PM
One thing I would check for is a virus in your network.
Another thing might be to upgrade the driver on the NIC or even swap out the NIC. You could have a "chatty" NIC.
One other idea comes to mind. Turn off the ProIV service. Is the network traffic still at 100%?
Posted 12 May 2005 - 05:48 AM
We have McAfee antivirus on all of servers and Norton on client side and updated on the fly all time. We used Distinct Netowork monitoring tool to identify the traffic between these two servers and found that 90% of traffic is TCP - TDS stream on port 1433 which is SQL server traffic and the rest is PROIV client connections through port 23. We tested by stopping PROIV service and then NIC traffic becomes normal. So it is genuine traffic. Is there any tweaking required on PROIV level to reduce the SQL traffic?
I will check with our Network administrator regarding the 'chatty' NIC.
Posted 12 May 2005 - 01:15 PM
Is there any tweaking required on PROIV level to reduce the SQL traffic?
If there is, I'm blissfully ignorant of it.
I'd be tempted to install the application on another computer - even a workstation and just see if that kind of traffic recurs there as well. For whatever reason, my gut reaction would be to try to isolate the issue as potentially hardware / networking and not necessarily ProIV. Of course, I reserve the right to be wrong!
Posted 12 May 2005 - 01:28 PM
The application and SQL server were on the same box before where we had issue of 100% CPU usage and the system was response less and thats when we decided to seperate it. Now CPU usage is normal on both servers and NIC is 100%. Can it be from the application the way the SQL statement constructed which fetches all the data? Since PROIV uses embedded cursors, how can we see the actual SQL statement executing?
Posted 12 May 2005 - 06:09 PM
Posted 12 May 2005 - 06:41 PM
Can it be from the application the way the SQL statement constructed which fetches all the data? Since PROIV uses embedded cursors, how can we see the actual SQL statement executing?
There certainly could be issues of performance problems due to the ProIV generated SQL, the database design, etc.
However, these issues would seemingly not lead to 100% NIC usage all of the time.
If you are seeing 100% NIC with 1 user logged in, it's overwhelmingly likely that you are not dealing with a ProIV issue. If the NIC usage rises with the overall system usage, then application design / lack of SQL tuning could be an issue.
One (unlikely) thing you may want to check:
Make sure that all of your tables have indexes. I have seen issues through one of our clients where, when migrating a SQL database through a bulk data transfer, all of the indexes disappeared.
If you think it is application related, then look for functions that read large amounts of records only to DSELect the majority of records that they just read.
Posted 16 May 2005 - 07:06 AM
Since the application is a thirdy party one we can not look into the functions, but I have checked the SQL tables which all of them are having indexes. Is there any debugging tool which we can use it for identifying the SQL sts from PROIV?
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users