Performance improvements for read only SQL Db that is only ever restored from backup
0
votes
3
answers
91
views
I receive a
.bak
file from a 3rd party on a monthly basis and create 1 db each receipt.
*.bak file size* is ~1Gb.
This data is for lookup only and I never write to it. Are there any steps I can take to improve performance for this scenario?
**I am considering:**
ALTER DATABASE [TESTDB] SET READ_ONLY WITH NO_WAIT
**Should I consider:**
- Shrink log file or any log file operations?
- Do anything with indexes such as [reorganize-an-index](
https://learn.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver16#reorganize-an-index)
I am using the current version of SQL Express.
Asked by ttugates
(37 rep)
Jan 14, 2025, 05:00 PM
Last activity: Jan 18, 2025, 11:28 AM
Last activity: Jan 18, 2025, 11:28 AM