Bandwidth used for Foglight Oracle monitoring (4228170)

Testing Strategy & Architecture

1. in order to obtain the send/receive rate of the network (bandwidth), Foglight Infrastructure Agent is used to monitor the network of the host 
   1. monitoring Host C-NC2 will get the bandwidth from FglAM to Monitored Host (or vice versa)
   2. monitoring Host A-NC2 will get the bandwidth from FglAM to FMS (or vice versa)
2. in order to eliminate the testing noise, a private network is set up that is dedicated to the Oracle monitoring
3. in order to imitate user access to the monitored Oracle, benchmark factory tool is used to feed data to the Oracle
4. in order to gauge the bandwidth for each different type of monitoring, DB monitoring, OS monitoring, and SQL PI will be enabled one by one  

Note:Oracle host is Linux

Test Tool: Benchmark Factory

Benchmark Factory is used to feed some data into DB instance. TPC-E  is used  and  it is the newest online transaction processing (OLTP) benchmark.  TPC-E involves a mix of 10 concurrent transactions of different types and complexity executed either online or queried for deferred execution.  The database is comprised of 33 tables with a wide range of record and population sizes.  TPC-E is measured in transactions per second (tpsE)

Test Steps and Results

Note:

1. The chart "Send/Receive Rate" choose Maximum metrics. We also choose Peak value in the curve. The data has a certain deviation within the acceptable range
   
2. The online status is defined as set collections frequency to  high and stay at Database Global View page. 
   
3. Compared with SQL Server, when only monitoring the database metrics, the send rate is higher than oracle because the collections concurrency of Sracle is lower than SQL server.
4. When monitoring a Linux OS, the send/receive rate does not largely increase because monitoring Linux OS generates a smaller send/receive rate
   
5. After PI is enabled, the send/receive rate increases tremendously as SQL PI sampling frequency is 1 sec. and the online frequency and offline frequency of PI is same, so the online data is slight greater than offline;
6. If multiple Oracle instances are being monitored, the FglAM Send/Receive Rate is: Send/Receive Rate for single instance X the number of instances.