53.2. Samples #
53.2.1. Taking a sample #
Before performing this instruction:
To take a sample:
Go to samples in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Samples.
From Instance, select the instance.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Samples.
In the top-right corner of the page, click Take snapshot.
Specify parameters of the new sample (parameters marked with an asterisk are required):
Database: The database for which the sample will be taken.
Server: The profiler server whose directory will be used to store the sample.
skip_sizes: Specifies whether to skip the collection of relation sizes when taking the sample.
Possible values:
true: The collection of relation sizes will be skipped when taking the sample.
false: The collection of relation sizes will not be skipped when taking the sample.
Click Save.
53.2.2. Viewing Samples #
Go to samples in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Samples.
From Instance, select the instance.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Samples.
From Database, select the database.
From Server, select the profiler server.
Click Select.
The table of samples with the following columns will be displayed:
ID: The unique identifier (ordinal number) of the sample.
Time: The date and time when the sample was created.
Sizes were collected: Specifies whether relation sizes were collected when taking the sample.
Possible values:
yes
no
Database stat reset: Specifies whether database statistics were reset when taking the sample.
Possible values:
yes
no
Bgwriter stat reset: Specifies whether
bgwriterstatistics were reset.Possible values:
yes
no
Archiver stat reset: Specifies whether archiver statistics were reset.
Possible values:
yes
no