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

SQL Agent memory issue Expand / Collapse
Author
Message
Posted Wednesday, September 5, 2012 3:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 8, 2014 3:25 AM
Points: 2,283, Visits: 781
Hi

I have a bunch of(6x) 64 bit sql 2008 (not R2) standard edition servers that seem to be leaking memory

the sql agent process is ramping up to 3GB in a single day (approx 40Kb per second) (note this is sqlagent.exe NOT sqlserver.exe)

the SQL agent is quite busy (29 jobs on 15 minute schedules)

Jobs simply perform remote proc calls on a linked server then wait for a specified period and then loop (until a specified amount of time has elapsed)
if i stop all of the jobs and disable them then the memory is not released.

also there is no SSIS use or CLR use. purely TSQL

i found the following article

http://support.microsoft.com/kb/971622

i'm not using sql variants and all of my servers are on sp3 (well above sp1 cu8)

Has anyone seen this before ? or have a fix?



MVDBA
Post #1354403
Posted Thursday, September 6, 2012 12:33 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:20 AM
Points: 1,616, Visits: 1,544
Doesn't sound like a memory leak. You're over-working SQL Agent running linked server queries (which do not use the buffer pool) and it's requiring 3 GB of memory. I would not expect SQL Agent to release memory it has taken even if it's not currently all in use.



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1355048
Posted Thursday, September 6, 2012 2:52 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 8, 2014 3:25 AM
Points: 2,283, Visits: 781
thanks for that - but on other servers we can see the memory being released.... thats what looks unusual

MVDBA
Post #1355127
Posted Thursday, September 6, 2012 12:33 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:27 PM
Points: 7,107, Visits: 12,657
Same Windows and SQL Server Build # on all servers?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1355558
Posted Friday, September 7, 2012 2:55 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 8, 2014 3:25 AM
Points: 2,283, Visits: 781
yes all of them - originally i posted 6 servers, but it's actually 18.. the other 50 or so servers (all win 2008 datacentre with sql 2008 sp3) seem to run at about 18Mb

MVDBA
Post #1355831
Posted Friday, September 7, 2012 4:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:27 PM
Points: 7,107, Visits: 12,657
Well something must differ between the servers. I am thinking code now. Are they running the exact same set of jobs?

Relevant link?

http://blogs.us.sogeti.com/sqlserver/monitor-sql-agent-memory-consumption/


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1355887
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse