If you turn on your SQL logs you will see the complete traffic between the ARS server and the database.
Some of the things to think about. For forms (these all add up when a user opens a form): - Do your forms have any graphics (on buttons perhaps)? - How many Active links are defined on the form? For individual records: - How much data is in the diary fields for the records being viewed? Also how many records are being returned when a user performs a search (and how big are the records)? You say the numbers are since the sniffer is activated, so how many seconds of capture is the 140,607,100,000 bytes? Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mauricio M. Sent: Wednesday, February 09, 2011 11:54 AM To: arslist@ARSLIST.ORG Subject: Sniffer Pro v4.5 reports ARServer consuming too much bandwidth Hello, Does anyone can shed some light on how to troubleshoot and give a good approach to a situation I am facing with a customer? I am not a network expert, but our customer is reporting way too much bandwidth consumption between ARServer box and Oracle DB box in a L2L with 10Mbps. ARSystem is 7.0 on Linux, they are using a really old Remedy Helpdesk version 6.0 and the BD is Oracle10.12g. The linux box is dedicated to Remedy and it is not heavily used, there are a very few users connected any given time. The network guy is providing me with some graphs and data they have collected using Sniffer Pro Version 4.50.04. According to his explanation, the numbers and percentages he provides in the following output represent the amount of bytes that are being transmitted since the sniffer is activated. For instance, I have this snapshot at 10:45 am, where he reports a total amount of 199,350,000,000 bytes being transmitted in that particular moment, and Remedy using 140,607,1000,000 bytes of that total. The table he provides shows the following: Point 1 (Remedy) to Point 2 (Node 1 Oracle Database): 70.44% bandwith usage Point 1 (Inconcert) to Point 2 (x): 9.07% Point 1 to Point 2: 1.67% Point 1 to Point 2: 1.4% (Some other business applications are listed in the table, I am not listing them but they give me a total of 100%) I would appreciate some insight on this issue, what other factors should I consider Thank you Mauricio _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"