Limit of records in user table

Go to solution
Anuja Jadhav1
Tera Contributor

‎11-01-2022 12:08 AM

How many records we can insert in the sys_user table and sys_user_group table? Is there any limitation to inserting the records?

0 Helpfuls
  • 682 Views
1 ACCEPTED SOLUTION

Go to solution
Saurav11
Kilo Patron
Kilo Patron

‎11-01-2022 12:20 AM

Hello,

 

There is no such limit. A few million records should not have a problem.

 

As per the answer by ServiceNow employee in the below thread:-

 

For your info, 4TB should be a contractual limit, not a physical/Technical limit. The current servers are having capacity ranging from 12 TB -21 TB. As such, the technical limit would the size of the servers. That said, there are other mechanisms such as gateways to move some of the approved tables to another database catalog to address the disk space issues. Please also note that the hardware capacity are subjected to changes are there may be new servers with larger disk space in the future.
 
 
Please mark my answer as correct based on Impact.

View solution in original post

0 Helpfuls
1 REPLY 1

Go to solution
Saurav11
Kilo Patron
Kilo Patron

‎11-01-2022 12:20 AM

Hello,

 

There is no such limit. A few million records should not have a problem.

 

As per the answer by ServiceNow employee in the below thread:-

 

For your info, 4TB should be a contractual limit, not a physical/Technical limit. The current servers are having capacity ranging from 12 TB -21 TB. As such, the technical limit would the size of the servers. That said, there are other mechanisms such as gateways to move some of the approved tables to another database catalog to address the disk space issues. Please also note that the hardware capacity are subjected to changes are there may be new servers with larger disk space in the future.
 
 
Please mark my answer as correct based on Impact.
0 Helpfuls