| Wiki Markup |
|---|
{scrollbar}
----
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:
* O3CubeService.log
* Audit.log
* Cubes.log
* Sessions.log |
| CubeQueriesPerformance.mdl | For a given cube, it lets you build its analysis cube. \\
In order to do so, it uses the Queries.log file corresponding to the cube you wish to analyze. |
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:
{code} |
...
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:
| Code Block |
|---|
serverHost = <host>
serverName = O3Server
[cubeName = <statCube>]
[profCubeName = <cube>]
model = <path>/CubeQueriesPerformance.mdl | model=<path>/ServerPerformance.mdl
user = <username>
password = <password>
{code}
|
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.
| Code Block |
|---|
serverHost = MyHost
serverName = O3Server
cubeName = O3ServerStats
model = <path>/ServerPerformance.mdl
user = admin
password = admin
{code}
|
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.
...
| Code Block |
|---|
serverHost = MyHost
serverName = O3Server
cubeName = DemoStats
profCubeName = Demo
model = <path>/CubeQueriesPerformance.mdl
user = admin
password = admin
{code}
|
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:
...
| Code Block |
|---|
builder -profiling -cfg=<file>.cfg <file>.srv
{code}
|
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:
...
| Code Block |
|---|
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
{code}
|
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.
...
...
| Child pages (Children Display) |
|---|
| Wiki Markup |
|---|
{scrollbar} |