On a sql server dedicated to a Dynamics CRM database, I've been seeing some odd behavior. While monitoring growth using the following query as basis, I've noticed tempdb has grown quite frequently ...
I have a database its size around 200G and it is heavy loaded with many inserts happens every day (it is grow around 3 to 4 GB every day), but the Auto-Grow setting is set to 1 MB. I think this is a ...
My requirement is to get the database size information collected daily, I did not find any option to get database growth over a period of time. Someone please advise what the correct method for this ...
My question regards PostgreSQL database size. How can I create new database with fixed size? (e.g. 5 GB) Once I have created fixed sized PostgreSQL database, how can I resize it ?
Is it best not to use Percentage file growth for autogrowth settings? The below recommends using percent value growth for databases under 500GB but is this recommended? ...
I am using event notifications to capture data and log file autogrowth events for all databases on my servers. I'm using the data to for analysis of database storage configuration. In looking at the ...