Subject:Size of SQL database
Hi. We're working toward our deployment of RDM here and our datbase people want to know what they can expect in terms of the size of the database. We have between 6000 & 7000 servers here and I expect to have secondary connections and file attachments in play for most of them. I'm trying to get an idea of how much space each record might take. Is this information available?
All Comments (1)
You have 4 major tables to look at, they are: Attachment, Connections, ConnectionHistory, ConnectionLog
An average row size are as follow:
- Connections 6-8KB
- ConnectionLog 1KB - one row per action (connect, disconnect...) - can be purged if need be
- ConnectionHistory 6-8KB - one row per session modification - can be purged if need be
- Attachment, it all depends of the file uploaded
Of course this is all approximated, but it's a good starting point.
Side note, with the amount of sessions you will be created you might want to split the data into multiple data sources. Not for the DB load but rather the client load. Over 5000+ sessions, client load times will be affected. Client side caching and the such help but we recommend splitting your data in order to minimize load times. You can start in one data source and split it if/when performance becomes an issue.
Best regards,
Stéfane Lavergne