I have been asked this question in an interview that how much would be the DB size for a standalone SQL server if 650MB of data is processed every month. I couldn't give any answer to this question in my interview and later on didn't find any answer either. Any help would be highly appreciated.
SQL Server Database Size Requirements and Design Considerations
database-designdisk-spacerestoresql serversql-server-2012
Related Question
- SQL Server 2000 Backup Fails with Status 33 – How to Resolve
- Sql-server – SQL Server 2012 Performance – Reads per second
- SQL Server – Where to Find the Size of Data Types?
- Sql-server – Audit Requirement – Capture Logins vs Database
- Sql-server – NULL values in unique constraints
- SQL Server – How to Get Current Month and Year as Macro
- SQL Server – Autogrowth Set Higher Than Available Disk
- SQL Server – Database Stuck Trying to Restore Itself Automatically
Best Answer
This is an open-ended interview question that doesn't have a precise answer. The interviewer might expect you to ask additional questions for clarity.
Actual space requirements will depend on what is meant by "processed" (inserted?), data retention (are data ever deleted?), column data types, indexes, storage overhead, use of compression features (including columnstore), plus additional free space for routine maintenance.