question

AmyHarrison-6411 avatar image
0 Votes"
AmyHarrison-6411 asked ·

sqlcmd: Microsoft ODBC Driver 17 for SQL Server Paging error

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-general
· 3
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

How much physical memory on the server? It may be the memory (physical and virtual) is undersized for your workload.

0 Votes 0 ·

Could you please check your memory?

0 Votes 0 ·

Hi, we have not get a reply from you. Any update for this?

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered ·

Hi @AmyHarrison-6411,

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.

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Carrin, I think you need to read the question a little better. Amy has a paging problem with the ODBC Driver - not the SQL Server Engine.

I refrained from answering when I saw the question, since I don't really have an answer. May I suggest that you consider this strategy for the future as well?

Although the obvious question to ask Amy would be what size does C:\Pagefile.sys actually have?

0 Votes 0 ·