Capturing Your Own Solaris 11.4 (12) Analytics / Sstore

Note: There is an updated process for Solaris 11.4+, please check out part 5 – Enhanced method on how to capture analytics in Solaris 11.4+ Note: The full code is available in a GitHub repository. to play with the code, feel free to just clone the Solaris Analytics Publisher repository.

• Please check out part 1 on how to configure analytics
• Please check out part 2 on how to configure the client capture stat process
• Please check out part 3 on how to publish the client captured stats.
• part 4 Configuring / Accessing the Web Dashboard / UI.
• Please check out part 5 Capturing Solaris 11.4 (12) Analytics By Using Remote Administration Daemon (RAD).

In the last post we populated the Stats store with our own stats .below I am going to show you haw to bring all of this together in the Solaris Analytics dashboard. First. Login to the dashboard at https://localhost:6787/. There are a number of Analytics you can add. Below are some examples. Example 1 (DB Session Count)

• In the Dashboard, click on the top bar, right side, Applications, and select Solaris Analytics.
• Click Add sheet, then give it a name
• Click on Add a Visualization, then click on the left side gear and select add statistic.
• Now select, I want to enter a new statistic
• You now have plenty of stats to choose from, below is an example.In Class : select. app/company/servers In Resource: select. server/your_server_name (or *) In Statistic: select. db1.ses-count In Operation: (optional) select. sum

After a few seconds you should see data in the charts. Example 2 (Disk Read Wait Time)

• In the Dashboard, click on the top bar, right side, Applications, and select Solaris Analytics.
• Click Add sheet, then give it a name
• Click on Add a Visualization, then click on the left side gear and select add statistic.
• Now select, I want to enter a new statistic
• You now have plenty of stats to choose from, below is an example.In Class : select. app/company/servers In Resource: select. server/your_server_name (or *) In Statistic: select. disk.read_wait-time-0B In Operation: (optional) select. sum

Below are screenshot of the steps in the Web UI. And below is the outcome. Below is a screenshot of the full dashboard.

Checking Stats with the commend line interface

You can also see the Stats store updates with the commend line interface, below is an example.

     
sstore capture //:class.app/company/servers//:res.server/*//:*
TIME                VALUE IDENTIFIER
2018-02-01T12:42:31 8 //:class.app/company/servers//:res.server/server1//:stat.cpu.usage-sys:*|grep disk|gr
2018-02-01T12:42:31 20 //:class.app/company/servers//:res.server/server1//:stat.cpu.usage-total
2018-02-01T12:42:31 11 //:class.app/company/servers//:res.server/server1//:stat.cpu.usage-usr
2018-02-01T12:42:31 1517506946 //:class.app/company/servers//:res.server/server1//:stat.date_time
2018-02-01T12:42:31 1517506943 //:class.app/company/servers//:res.server/server1//:stat.db1.date_gen
2018-02-01T12:42:31 5 //:class.app/company/servers//:res.server/server1//:stat.db1.qry-time
2018-02-01T12:42:31 1 //:class.app/company/servers//:res.server/server1//:stat.db1.ses-count
2018-02-01T12:42:31 0 //:class.app/company/servers//:res.server/server1//:stat.disk.read-megabytes-0B
2018-02-01T12:42:31 0 //:class.app/company/servers//:res.server/server1//:stat.disk.read-megabytes-0C
2018-02-01T12:42:31 17 //:class.app/company/servers//:res.server/server1//:stat.disk.read-ops-0B
2018-02-01T12:42:31 0 //:class.app/company/servers//:res.server/server1//:stat.disk.read-ops-0C
[..] snip

You can also clone a sheet (like the default system which is read only sheet or if the user does not have access). Click, Export sheet. Copy the json exported file to /webui/analytics/sheets/site Restart the webui service, bu running the below.

svcadm restart webui

Login as a user check out the new sheet. Note: The full code is available in a GitHub repository. to play with the code, feel free to just clone the Solaris Analytics Publisher repository. Note: There is an updated process for Solaris 11.4+, please check out part 5 – Enhanced method on how to capture analytics in Solaris 11.4+ You might also like – Articles related to Oracle Solaris 11.4/Solaris 12. Like what you’re reading? please provide feedback, any feedback is appreciated.