Chatee ahora con Soporte
Chat con el soporte

Safeguard Privilege Manager for Windows 4.7 - Administration Guide

TitlePageProxy Copyright Table of Contents About this guide What is Safeguard Privilege Manager for Windows? Installing Safeguard Privilege Manager for Windows Configuring Client data collection Configuring Instant Elevation Configuring Self-Service Elevation Configuring Temporary Session Elevation Configuring privileged application discovery Deploying rules Removing local admin rights Reporting Client-side UI customization Using Microsoft tools Maintaining a least privileged use environment Database Planning Product Improvement Program About us

Database Planning

Detailed information about this topic

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

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

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

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:

  1. The Activity table generates one thousand records per user.

  2. The number of Computer records are equal to the number of user records.

  3. 20 reports represent one user.

  4. The DatabaseVersion table should be one record irrespective of the number of user in the environment.

  5. The DataError table is estimated to be twenty records to one user.

  6. The DeployedRules table should generate twenty records per one user.

  7. The Discovery table should generate roughly thirty records per user.

  8. The number of Domain table records are set to one per user.

  9. Twenty ElevationRequest records are generated per user.

  10. There are ten Reports_Scheduled records per user.

  11. There are ten Reports_SharedFilters per user.

  12. Twenty Rule records are generated per user.

  13. 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

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación