Jump to content

Database growth


kysmith
 Share

Recommended Posts

We're currently doing a trial run of PasswordState and having our database team create a SQL database for it. Our database administrator is asking for the projected growth of the database. I don't have any idea how to answer this.

 

Our use case is currently about 50 system administrators managing several hundred service accounts/passwords, but it could expand to several hundred IT staff supporting a few thousand passwords (guesstimating here). If theoretically we were to expand this to all of our users, it would be around 10,000 users.

Link to comment
Share on other sites

Hello Kysmith,

 

It's a bit difficult to provide projections for this, as it really depends on how Passwordstate is used i.e. do you intent to upload large documents into the system, how heavily will you use the API(s) as they can add a lot of auditing data depending on what types of calls you make.

 

In our development environments, the databases are around 150 to 170Mb, with several years of data - but that would not be a tru simulation of 10,000 users. On the screen Administration -> Auditing, there is also some instructions for your DBAs to archive the Auditing data, if it starts to grow too large - and by that we mean millions of records.

Regards

Click Studios

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...