hi all,<BR>actually the title is a bit missleading, but true.<BR><BR>i have a asp.net website where i use some long SP within. the problem is that when i monitor the performance in the management menu in the Process Info in sql, i see so many sessions opened all of which are usning that SP.<BR><BR>i checked my code manytims, every Connectin.open() has its correspondent Connetion.close()<BR><BR>i know that the sp is too long and heavy...but even though...how do the sessions still exist when no one is using the site?!!( i know because i made a test on local server )..and even though too...it shouldn't EAT my cpu that much !!<BR>am using C# and SqlDataAdapter.<BR><BR>anyone can help ?! my cpu is deing !!!