Sample Header Ad - 728x90

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