data file autogrow

Fix Error 1101: Could not allocate a new page for database

We get error 1101 because of space issues. Database engine doesn’t able to allocate new pages to the database because…

7 years ago

Whenever you extend the size of your data or log file with a larger value or your database perform autogrow…

7 years ago

I was getting wait type PREEMPTIVE_OS_WRITEFILEGATHER during database size allocation. Yesterday, I was configuring database size to the value that…

7 years ago

I am working on a project where we are migrating Oracle databases to SQL Server for SAP applications. We are…

7 years ago

We use SQL Server database Autogrowth setting to automate database file growth. This property is very helpful if you use it…

8 years ago