Manage Pyodbc Memory Usage

I am using pyodbc (3.0.7) to retrieve data from a SQL Server database. My OS is windows 7 and python is 2.7.7 64 bit. I am running into memory usage issues and I was wondering if t

Solution 1:

By default, SQL Server will allocate as much memory as it can for the buffer pool. This is great for performance, allowing data to be accessed from (fast) memory instead of (slow) disk. For development workstations, this can become a problem when you have other applications competing for resources.

To resolve, configure a maximum amount of memory that SQL Server should allocate. The amount you set depends on the amount of memory installed and the type/number of applications you are using. As a very general recommendation for a developer workstation with 8GB installed, I would set the SQL Server maximum to 2048MB.