DX NetOps

The Spectrum Sizer asks for events/sec. How can you determine this? 

Hi Sheldon,

You can query the DDMdb (Archive Manager's database).

In the example below, it will pull the number of events in 24 hours:

1. Open a bash shell (bash -login)
2. Navigate to $SPECROOT/mysql/bin directory

    cd mysql/bin

3. Launch the MySQL command prompt

    ./mysql -uroot -proot ddmdb (for Windows)

    ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot ddmdb (for Linux or Solaris)

4. Run the following MySQL query:

SELECT count(*) as Total_number_events from ddmdb.event where utime > UNIX_TIMESTAMP('2017-12-01 00:00:00') and utime < UNIX_TIMESTAMP('2017-12-02 00:00:00');

/ 24 --> number of events in 1 hour

/ 24 / 60 --> number of events in 1 minute

/ 24 / 60 / 60 --> number of events in 1 second

Thanks,

Silvio

Hi Sheldon,

There are a few of ways to get the number. The easiest way is to go to the OneClick Web page - Administration Pages. Select the Debugging link in the small gray header, and select the "Event Domains" link on the left hand side of the page. There you will see the Event Statistics for each Event Domain in the DSS. You will want to convert the value to Events/sec. This may not be the most accurate number due to rounding.

Another way is to us the Locater Tab and run a Application Models search By Name. Search for the "SSPerformance" model. In the Component Detail pane - Performance Tab, look at the drop-down list for "EventsGenerated". This will graph out the number of events generated over a specific period of time. I think the default is 1 hour. You can then divide that number by the number of seconds in the specified time range you are looking at, and get a rough estimate of the Event Rate for the VNM.

For Example:

The average number of events generate in the last hour is 26552.617 events. The Event Rate would be 24, 556 events / 3600 seconds would give you an average rate of 7.376 events/second.

You'll get more accurate results if you make you time period larger.

If I go out 4 weeks, is have an average of 57562.252 events generated / 2419200 seconds = 0.024 events/sec (1.44 events/min) over the 4 week period.

Hope this helps,

Brad

Hi Brad,

This was exactly what I was looking for. This information should be included with the Spectrum Sizer.

Regards,

Sheldon

Sheldon Chapman

Service Delivery Analyst

Enterprise Service Monitoring

The TJX Companies, Inc. | 400 Value Way | Marlborough, MA 01752

Location: MRO.400.3BS | Phone: 774-308-8341