SQL Server Performance Forum – Threads Archive

.net and Sql Server

We are having a memory problem with our SQL Server box
Our Layout is a Win 2003 Server running the front end sites and a 2000 Box with 1.5 Gig Ram only running Sql Server this keeps running out of memory and SQL is taking all of it.
It used to be fine until the developers started using VB.net to develop sites.
They have check the code and it appears to do as it is told but after queries Sql Server seems not to free memory and it keeps demanding more till the box runs out and stops responding And ideas greatfully received Sambino

Are you running IIS and SQL server on the same server? If so limit the ammount of memory the SQL Server can use to about 800 MB RAM and leave the rest for IIS and the operating system.

Are you able to monitor things like number of connections, etc to see what it is that sql is holding on to? if there any text column manipulation where the column pointers are not being released, or xml processing where the xml handle is not being cleaned up? It sounds like an application leak rather than sql itself? Cheers
Twan

IF possible differentiate the IIS & SQL on different machines for performance purpose. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>