If the footprint of the app just gets bigger over time then you've already identified that it is leaking memory.
You can confirm this by profiling this process from another machine using perfMon. Log data for some period of time for the process object, then graph the Private Bytes of the application. If you see an upward stepping pattern or an upwardly slanted line, that application is leaking memory. (Of course the advantage of charting it with perfmon in this manner is you can send that log to the developer as confirmation.) A well formed application will show flat memory usage. It is unusual to see significant noticeable variation in the Private Bytes statistic for most processes. -Tip : When you graph Private Bytes set the scale to its lowest setting as there is a tendency for this statistic to run off the top of the graph in which case Perfmon erroneously graphs it as a flat line at the top of the graph. ----Original Message Follows---- From: "Robert J. VadeBonCoeur" <[EMAIL PROTECTED]> Reply-To: "MSWinNT Discussions" <[EMAIL PROTECTED]> To: "MSWinNT Discussions" <[EMAIL PROTECTED]> Subject: Memory error? -NT4 SQL Server Date: Fri, 26 Oct 2001 13:12:05 -0500 (Ignore prior message, this one is correct message - sorry). Have a NT 4 Ent. (SP6A) SQL 7.0 Server (Cluster). I believe I have a memory leak, but not sure if it is a hardware problem, NT problem, or SQL problem. Server memory is being used up by SQL, and is paging it appears. SQL app just keeps using more and more memory. I think it is a SQL problem, but thought I would leave it with you guys for your opinion. Server has 1 GB RAM. Here is process information at time of problem. Image SQLSERVR.EXE, PID321, CPU00, MEM USAGE 965016 (That is alot of memory just for SQLSERVER APP!-I know we are not using it that much. Size never decreases, just gets bigger over time!). Physical Memory (k) Total 1037952 Available 4972 File Cache 13292 Kernal Memory (k) Total 20620 Paged 12580 Non 8040. ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED] _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
