Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

User Connection Memory - Memory Leak?? Expand / Collapse
Author
Message
Posted Wednesday, June 12, 2013 8:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 11, 2014 7:31 AM
Points: 105, Visits: 777
Hello,

I have had an issue on a SQL and SSRS server that i have been unable to resolve without getting someone to restart the application services to drop and recreate the TCP connections made to SQL. I have used Quest to look into this but can find very little apart from which SPID it is and where it is coming from.

We are using WebSense and on the server there is one TCP connection of concern, that at the start, has a memory allocation of 2....and 10 days since that restart....it is 474,849....which equates to around 3.8GB. We have a MIN and MAX memory setting of 4.8GB.

Currently we have 3MB for the procedure cache when it was originally just under 2GB....and 1GB for the buffer cache where it was originally just under 2GB also. This is not a heavily used server so luckily the performance impact is minor. However, since yesterday the alerts for recompilation (all <40%) are driving me crazy!! The procedure cache is shrunk all the way down....and once the procedure cache is down to its smallest, the buffer cache starts to suffer and lose its allocation.

I refuse to stop the alerts on this server just to make it quiet. I have checked the DBCC MEMORYSTATUS which gives very little information that i have already. The MEMORYCLERKS DMV shows 3.7mil single-pages for SQLCONNECTIONPOOL. ReportingServices is only using 150MB and doesnt seem to be used much anyway.

I have logged a call with WebSense but they dont seem to have any idea what could cause this. I was hoping someone here could point me in the right direction or to assist in trying to get more imformation, and more importantly, a way to show WebSense, or myself, the cause of the issue and hopefully resolve it.

I have read that something using prepared statements can cause a memory leak....but unsure how to find any evidence for this.

The server details are:

Windows 2008 R2 SP1
SQL 2008 SP3 Enterprise (10.0.5500)
2 x vCPU
8GB vRAM

I saw another post relating to a similar issue but no answers. My memory usage graph is a dead straight line with no deviations....meaning the consumption was constant. I would not expect the WebSense logging utility to be as busy during the day as at night so was thinking this was not related to the SQL activity....more along the lines of the type of connection or something in the application....but again.....how do i show this?

Any help would be much appreciated.

Regards,

Samuel
Post #1462675
Posted Monday, June 17, 2013 8:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 11, 2014 7:31 AM
Points: 105, Visits: 777
hmmmm....nothing??
Post #1464174
Posted Monday, June 17, 2013 9:46 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:36 PM
Points: 3,118, Visits: 11,555
"3MB for the procedure cache"???

Did you really mean 3 GB for the procedure cache?

How many connections are open to the server?
Post #1464227
Posted Tuesday, June 18, 2013 4:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 11, 2014 7:31 AM
Points: 105, Visits: 777
there are only 15 connections....rarely more than 2 active at any time

and yes....the procedure cache started at 2GB but was reduced down to 3MB once the connection memory was so high is caused the memory allocation to the cache to be reduced

thanks
Post #1464556
Posted Friday, June 21, 2013 2:32 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 22, 2014 2:41 PM
Points: 62, Visits: 470
Did you get the Solution for the same?i am facing the same problem on my server.

Total amount of dynamic memory the server is using for maintaining connections:-7.718276977GB

Its a 16 Gb box with(10GB max memory) lock pages in memory is enabled.

it seems that there is some problem with ODBC connection from Websense Server.
Post #1466392
Posted Friday, June 21, 2013 3:06 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 22, 2014 2:41 PM
Points: 62, Visits: 470
I got the answer..this issue is fixed in 2008 R2 Sp1 CU5.
Post #1466399
Posted Monday, June 24, 2013 6:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 11, 2014 7:31 AM
Points: 105, Visits: 777
thanks deepak....

i dont have R2....and cannot find the particular fix detailed in the CU5 release notes.

Do you or anyone know exactly what fix this is and whether it can be downloaded and applied to SQL 2008 (non-R2)??

many thanks
Post #1466707
Posted Wednesday, December 18, 2013 8:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 8, 2014 7:01 AM
Points: 5, Visits: 189
Were you able to find a resolution to this issue? I am encountering the same issue with Websense 7.7.3 and SQL Server 2008 R2 SP2 w/ CU3. User connections slowly eat up all the memory allocated to the instance hosting the log databases. ARGH! :-S
Post #1524167
Posted Tuesday, February 18, 2014 11:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 3:39 PM
Points: 4, Visits: 57
I am having this problem as well. I have a SQL Server 2008 R2 SP2 STD on 16 GB memory and Win 2008 R2 64 BIT, at the beginning, the Memory Manager -> Database Memory takes most of the SQL used memory, but the Memory Manager -> Connection Memory counter keeps increasing until it consumes almost all memory after about a week. I have to restart SQL server to release the memory used by Connection Memory.

When I cut the connections by websense accounts, the memory was release right away. So for now I set a job to cut the websense connections each sunday.
Post #1542684
Posted Sunday, February 23, 2014 9:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, April 6, 2014 11:16 PM
Points: 1, Visits: 4
how to cut the connections by websense accounts, to release the memory right away.
please guide me by some steps
Post #1544346
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse