Question : On a sql server dedicated to a Dynamics CRM database, I’ve been seeing some odd behavior. While monitoring […]
Tag: auto-growth
Autogrowth Analysis in PROD DB based on the trace file data
Question : I have used the below query to check our Production Database Autogrowth events so that we can set […]
Looking for help understanding what is happening in this SQL Script that shows key info about SQL Server Autogrowth Events
Question : Here is the code below: DECLARE @current_tracefilename VARCHAR(500); DECLARE @0_tracefilename VARCHAR(500); DECLARE @indx INT; SELECT @current_tracefilename = path […]
autogrowth set higher than available disk
Question : First all our autogrow settings are either turned off or the file size is set to the max […]
SQL Server 2008 R2 – Track Database Growth (Production Database)
Question : My requirement is to get the database size information collected daily, I did not find any option to […]
Tempdb log growth 3x as slow on new server, SP does not perform
Question : We are running into the issue that our stored procedure on our new SQL Server performs a lot […]
Why Does the Transaction Log Keep Growing or Run Out of Space?
Question : This one seems to be a common question in most forums and all over the web, it is […]
Changing Auto-Growth Setting in AOAG for log file
Question : We are on AOAG SQL Server 2014. I am planning to change Auto-Growth setting from % –> MBs […]
What factors do we need to consider in order to enable auto-growth settings for my PROD database
Question : I want to know the factors that we need to consider in case we need to enable auto-growth […]
Restore database without overriding Auto growth
Question : I created a database with auto growth 200MB. After restoring database auto growth changed to 1MB. Because my […]