When Safeguard Privilege Manager for Windows is installed, it uses the default file and log sizes specified by SQL Server. The default file size is 3 MB for the database and 2 MB for the database logs.
NOTE: Consider that once these files exceed the initial file size settings, further file size increases may result in data fragmentation in the disk, and corresponding performance issues.
To prevent such performance issues, scale the log file sizes accordingly. For example, if the database is expected to grow to a specific size in a month, One Identity recommends that you take the expected value, double it, then use the doubled value for the initial size.
For example, if the database is expected to grow to 2,000 MB in a month, set the initial database size to 4,000 MB. This will reduce the number of auto-growths and reduce fragmentation, as a larger allocation means that more database-related information can be accessed from the same disk location. The following table breaks down the recommended initial size for the database based on a range of 1 to 100,000 users for the different database size estimations.
Table 6: Initial size recommendation for different Safeguard Privilege Manager for Windows environment sizes
|
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 |
NOTE: Steps may be slightly different for other supported versions of SQL Server.
To change the Initial Size settings
-
Start SQL Server Management Studio.
-
Highlight, then right click the PAReporting database and navigate to Properties.
-
In the left panel, select Files from the Database Properties dialog box. Use the Properties window to change the Initial Size.
-
Identify the PAReporting name under Logical Name and change the Initial Size. For example, you can set the Initial Size (MB) to 13,752,8MB. This value is two times the size of the database. For more information, see Initial database size.
Product Improvement Program
To assist in the development of new features, as well as drive future improvements, we implemented a Product Improvement Program. Feedback from this program provides Product Management with valuable insight into how our products are being used. This information is essential to help the R&D team prioritize existing enhancement requests within the roadmap of each product. Participation is voluntary, and no personal contact information is ever collected.
Frequently asked questions
Topics:
How do I participate in the Product Improvement Program? What if I change my mind?
How will the collected information be used?
Where is the data being stored?
What information is collected?
How does the Product Improvement Program work?
How long will collected data be stored?
Will I receive spam if I participate in the Product Improvement Program?
Do I need an Internet connection?
Can I see the data that is collected before it is transmitted?
How long will my participation in the program last?
How is my privacy protected?
How do I participate in the Product Improvement Program? What if I change my mind?
There is an option in Safeguard Privilege Manager for Windows that can be used to verify or change your participation at any time. Select the Help menu and then click on Product Improvement Program to change your participation option.
How will the collected information be used?
Information collected will be used to develop new features and improve Safeguard Privilege Manager for Windows.
Where is the data being stored?
The data is stored on a secure server within the USA and will be accessed only by the members of the Safeguard Privilege Manager for Windows R&D team.
What information is collected?
-
Safeguard Privilege Manager for Windows features usage data such as Console configuration settings
-
System information such as operating system, processor, and memory installed
-
Domain information such as number of users, servers, and workstations being managed
-
Browser type and version
-
Product information such as version
-
License information such as type and number of seats
NOTE: The General Data Protection Regulation (GDPR) and California Consumer Privacy Act (CCPA) define a set of data protection and security measures that restrict access to personally identifiable information (PII). The Safeguard Privilege Manager for Windows Client collects user-specific data from managed devices, and sends it to the Server. This information is not shared with One Identity. The only exception are domain names associated with users who ran the elevated or Blacklisted process.
How does the Product Improvement Program work?
You choose to participate and allow Safeguard Privilege Manager for Windows to send usage data, associated with an anonymous user ID from your computer. If you are offline at any time, the data will be sent the next time an internet connection is available.
How long will collected data be stored?
We will store the collected data on our secure server for as long as the Product Improvement Program is in place.
Will I receive spam if I participate in the Product Improvement Program?
You will not receive any e-mail regarding the Product Improvement Program, regardless of whether you participate. We do not collect personally identifiable information.
Do I need an Internet connection?
An Internet connection is required for participation. However, it can be an intermittent connection. When an internet connection becomes available, the information is automatically transmitted with minimal impact to your system.
Can I see the data that is collected before it is transmitted?
No, the information cannot be displayed on the customer side. The collection of the desired data occurs seamlessly in the background without affecting the product. Additionally, all formatting and processing of the collected data are done post transmission.
How long will my participation in the program last?
Information is actively collected as long as you use the product version for which you have agreed to participate or until you decide to end your participation.
How is my privacy protected?
We take many precautions in protecting the information that is collected and transmitted. You can learn more about how we handle user information by reviewing our Privacy Policy.
Since no personally identifiable information is collected, the anonymous data will not be meaningful to anyone outside of our company.
