Safeguard Privilege Manager for Windows 4.7.1

The goal of this topic is to proactively manage disk capacity as it relates to Safeguard Privilege Manager for Windows. The capacity planning information provided here contains steps to help understand, install, and configure the Safeguard Privilege Manager for Windows database environment.

Eighty percent of database issues deal with disk capacity problems and in many cases, they are caused by failure to adhere to best practices. Failure to adhere to best practices should never happen as these issues are very predictable and could be prevented with a comprehensive database plan.

This section gives you a breakdown of the Safeguard Privilege Manager for Windows database structure to better understand the database environment and walks through capacity planning best practices to minimize the risk of disk over- utilization.

Safeguard Privilege Manager for Windows Database Diagram

Database Planning > Safeguard Privilege Manager for Windows Database Diagram

Figure 2: Safeguard Privilege Manager for Windows Database Diagram

Users	Database size	Initial size
1	4.7 MB	9.4 MB
10	10.5 MB	21.0 MB
100	73.0 MB	146.0 MB
1,000	692.6 MB	1385.2 MB
2,000	1,378.6 MB	2,757.2 MB
5,000	3,439.9 MB	6,879.8 MB
10,000	6,876.4 MB	13,752.8 MB
15,000	10,313.0 MB	21,626.0 MB
20,000	13,749.5 MB	27,498.0 MB
50,000	34,368.8 MB	68,736.0 MB
100,000	68,734.2 MB	137,468.4 MB

Safeguard Privilege Manager for Windows Tables

Database Planning > Safeguard Privilege Manager for Windows Tables

Table Name	Description
Activity	Contains rule and Instant Elevation activity. Includes Elevation type and item.
Computer	Contains client computer information such as its name, domain, class, Organizational Unit, operating system and the version of Safeguard Privilege Manager for Windows installed.
Database	Contains the database version of the Safeguard Privilege Manager for Windows database.
DataError	Contains database exceptions and includes exception messages, host address, host name and the XML data document that caused the exception.
DeployedRules	Every time a new rule is deployed, a record is created for every user associated with this rule. This keeps track of all deployed rules, assigning the rules a status (active \| inactive), and tracks date (added \| removed).
Discovery	Contains information on any process that starts or fails to start on a client computer. Data stored here includes the product name and requested execution level. It is used by the Privileged Application Discovery component.
Domain	Contains records of the network domains.
ElevationRequest	Contains Elevation requests made on the client, including information about the name of products the request is being made for and the reason for the request.
Reports_Scheduled	Contains records of the scheduled reports to be generated.
SharedFilters	All shared filters created.
Rules	Rules created and saved in the Safeguard Privilege Manager for Windows Console.
Users	Users who have logged into a Safeguard Privilege Manager for Windows Client machine.

Data Storage Estimates

Database Planning > Data Storage Estimates

Table 1: Table size estimate for one Safeguard Privilege Manager for Windows user
Table Name	Number of Rows	Byte Size per Row	Total Size (bytes)
Activity	1,000	4,222.68	422,268.00
Computer	1	84.38	84.38
DatabaseVersion	1	72.09	72.09
DataError	20	8,834.25	176,685.00
DeployedRules	20	49.15	983
Discovery	30	3,8049.23	1,141,476.9
Domain	1	84.38	84.38
ElevationRequest	20	54,540.61	1,090,812.2
Reports_Scheduled	10	4,575.25	45,752.50
Reports_SharedFiles	10	9,436.70	94,367.0
Rule	20	304.99	6,099.8
User	1	4,443.48	4,443.48
Total Size 4,683,128.73 bytes

As the number of users grow, some tables increase in size more rapidly than others. For this reason, the database size does not grow proportionately.

Database size calculation uses the following rules:

The Activity table generates one thousand records per user.
The number of Computer records are equal to the number of user records.
20 reports represent one user.
The DatabaseVersion table should be one record irrespective of the number of user in the environment.
The DataError table is estimated to be twenty records to one user.
The DeployedRules table should generate twenty records per one user.
The Discovery table should generate roughly thirty records per user.
The number of Domain table records are set to one per user.
Twenty ElevationRequest records are generated per user.
There are ten Reports_Scheduled records per user.
There are ten Reports_SharedFilters per user.
Twenty Rule records are generated per user.
One user record exists in the User table per user.

Table 2: Database size for multiple users
Users	Database size
1	4.7 MB
10	10.5 MB
100	73.0 MB
1,000	692.6 MB
2,000	1,378.6 MB
5,000	3,439.9 MB
10,000	6,876.4 MB
15,000	10,313.0 MB
20,000	13,749.5 MB
50,000	34,368.8 MB
100,000	68,734.2 MB

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

Safeguard Privilege Manager for Windows 4.7.1 - Administration Guide

Database Planning

Detailed information about this topic

Safeguard Privilege Manager for Windows Database Diagram

Safeguard Privilege Manager for Windows Tables

Data Storage Estimates