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
autogrowth setting
Fix SQL Server Msg 5144 and 5145 for long or failed autogrow of data and log files
Whenever you extend the size of your data or log file with a larger value or your database perform autogrow…
7 years ago
How to Reduce PREEMPTIVE_OS_WRITEFILEGATHER Wait Type in SQL Server?
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
How to Improve SQL Server Bulk Data Import Performance?
I am working on a project where we are migrating Oracle databases to SQL Server for SAP applications. We are…
7 years ago
Understanding Database Autogrowth in SQL Server
We use SQL Server database Autogrowth setting to automate database file growth. This property is very helpful if you use it…
8 years ago