Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Growth Expand / Collapse
Author
Message
Posted Monday, December 2, 2013 9:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 21, 2014 4:44 AM
Points: 44, Visits: 237
Hi,

If a database is used only to read from, will its data files still grow? Only select queries are executed against the database, and there are no inserts/updates being carried out.

Thanks.
Post #1519058
Posted Monday, December 2, 2013 9:53 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 29, 2014 11:29 PM
Points: 147, Visits: 587
Your database should not grow if it is readonly, but if you have complex select queries with lot of sorting, grouping then your tempdb will keep growing.



Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Post #1519065
Posted Monday, December 2, 2013 10:00 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 21, 2014 4:44 AM
Points: 44, Visits: 237
Hi,

Thanks for the speedy reply.

The database is not set to read_only.
All users are restricted to db_datareader access. Only "Select" queries are run against the database. No users are permitted to execute insert/update/alter etc.

Thanks.
Post #1519069
Posted Monday, December 2, 2013 10:10 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 29, 2014 11:29 PM
Points: 147, Visits: 587
through SELECT queries your database size will not grow however as i mentioned earlier tempdb might still grow also if you carry out any database maintenance tasks on this database then your log file will also grow.



Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Post #1519070
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse