In order to carry out analysis of O3 Server statistics through the use of O3 Browser, two models that let you build an analysis cube for the server in general and an analysis cube for each of the cubes published in it are provided.
These models are found in the "server" directory below the O3 setup directory.
The models are:
Model Name |
Description |
|---|---|
ServerPerformance.mdl |
It lets you build the O3 Server general analysis cube through the use of the 4 log files:
|
CubeQueriesPerformance.mdl |
For a given cube, it lets you build its analysis cube. |
When you use the ServerPerformance.mdl model, it is necessary to generate the four files mentioned above.
Once the log files have been generated, and through the use of the aforementioned models, you may go on to build (or rebuild) the analysis cubes.
The building or rebuilding of cubes is performed through the use of O3 Builder (as expected) with a special parameter "-profiling" and using a .srv file with data about the server for which statistics are to be calculated. The buildings are always complete, that is to say no incremental loads are performed on these cubes.
As a consequence, in order to build the statistics analysis cubes the following command should be used:
Builder -profiling <file>.srv
Where the <file>.srv file must contain the following data:
serverHost = <host> serverName = O3Server [cubeName = <statCube>] [profCubeName = <cube>] model = <path>/CubeQueriesPerformance.mdl | model=<path>/ServerPerformance.mdl user = <username> password = <password>
Please see the section: "Generating the configuration file for O3 Builder"
Property |
Description |
|---|---|
ServerHost |
Name or IP address of the machine currently running the O3 Server from which statistics will be taken. |
ServerName |
Name of the O3 Server. (This value must always be 'O3Server'). |
CubeName |
It is optional and must only be used in case the cube with statistic information (<statCube>) to be built or rebuilt, is published in O3 Server. |
ProfCubeName |
This parameter must only be included when you attempt to build a cube with statistics coming from other cube published in O3 Server. |
Model |
The model to use for the building of the statistics cube. If you wish to build an O3 Server general statistics cube, the ServerPerformance.mdl model must be assigned as value, and if you wish to create a statistics cube for any given cube published in O3 Server, the CubeQueriesPerformace.mdl model must be assigned as value, and the cube to analyze must be specified through the use of the profCubeName parameter mentioned before. |
User |
It is the user through which connection to O3 Server is made. |
Password |
Password of the user through which connection to O3 Server is made. |
The following example of .srv file is used to create the O3 Server general statistics cube in the maching called MyHost and published as O3ServerStats in the same server.
serverHost = MyHost serverName = O3Server cubeName = O3ServerStats model = <path>/ServerPerformance.mdl user = admin password = admin
By using this second example of .srv file a statistics cube of the cube published in O3 Server under the name "Demo" is built.
Besides, this statistics cube is published in O3 Server under the name DemoStats.
serverHost = MyHost serverName = O3Server cubeName = DemoStats profCubeName = Demo model = <path>/CubeQueriesPerformance.mdl user = admin password = admin
The administrator shall provide a file of this type for each of the files in their O3 Server for which they wish to create the corresponding statistics analysis cube, by modifying the cubeName and profCubeName respective values.
If the statistics cube you are building is not published in O3 Server, the cubeName parameter will not be included in the .srv file.
In this case, the Builder standard parameter (-cube=<path>/<cubeName>) can be used to specify the path where to save the built cube and the name to give to it.
If this parameter is not specified, O3 Builder will use its default settings, and create the cube in the same directory where the .mdl file used is located, giving it the same name, and .cube extension, of course.
As for any cube building process from ascii files, it is necessary to specify the location of the files used as data source, (in this case, the log files generated by the O3 Server Profiles service)
By default, when O3 Builder receives the -profiling option and logs in to the O3 Server specified in the .srv file received as parameter to build a given statistics cube, it automatically extracts the location of the log files it needs for the building from the O3 Server setup.
If by any reason it is necessary to build statistic cubes from log files in a different location to the specified in the O3 Server setup, the -cgf=<file>.cfg option of O3 Builder should be used.
The command to use in these cases will be:
builder -profiling -cfg=<file>.cfg <file>.srv
As a rule the -cfg option lets you specify new values for the parameters of the model you are using to build the cube. In this case the models have a set of parameters that specify the path to the log files needed for the building and it is therefore possible to modify them this way.
The <file>.cfg fiile must, as a consequence have the following format:
O3_CUBE_SERVICE_PATH = <path>/O3CubeService.log AUDIT_PATH = <path>/Audit.log CUBES_PATH = <path>/Cubes.log SESSIONS_PATH = <path>/Sessions.log QUERIES_PATH = <path>/<cubename>Stats.log
The values of parameters must include the path and logfile name.
The first 4 parameters are necessary when the server general statistics cube is built, whereas the last one is necessary if you are building a statistics cube for a specific cube.