I have several applications which run on top of SQL
Server. These applications use both ODBC and ADO to
execute SQL statements which INSERT, DELETE, and QUERY
data out of the database. Nothing to Exciting, but it
hits the database a lot (~100 hits per minute). The
problem I am running into is that SQL seems to grow until
it consumes all the memory on the server machine. We can
solve this problem by capping the memory that SQL uses.
But need more information as to why this is happening and
what the performance side effects. Does anyone have a Q
article or something?