sqlcmd: Microsoft ODBC Driver 17 for SQL Server Paging error

Amy Harrison 1 Reputation point
2021-03-15T11:35:46.29+00:00

We receive this error periodically when trying to run queries via automation using sqlcmd. The paging file is system managed, we have updated driver to latest version but still get this and memory allocation issues if any activity us taking place on the db. Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Specified driver could not be loaded due to system error 1455: The paging file is too small for this operation to complete. (ODBC Driver 17 for SQL Server, C:\windows\system32\msodbcsql17.dll).

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,340 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,866 Reputation points
    2021-03-16T03:29:35.747+00:00

    Hi @Amy Harrison ,

    Which version of SQL Server do you used? Because there have memory limitation for different version of SQL Server, you can find the details form this link.

    When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free memory. Maintaining this free memory prevents the operating system (OS) from paging. Please find more details from this link.

    Best regards,
    Carrin


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.