Memory Leak?

[Jon Mundsack]

I am watching the "Mem Usage" for the sqlserver.exe process in the Windows
NT Task Manager climb at a rate of about 400k per minute. This has been
going on steadily since the server was rebooted yesterday. We're now up to
50% memory used out of a 2gb "limit"
I don't know if it was doing this before, but it may be that this apparent
memory leak is what caused the server to crash yesterday (which is why it
was rebooted).

What kinds of things can I look for that may be causing the leak?

[Andrew J. Kelly]

That is normal sql server memory usage under load. SQL Server does not give
back ram once it takes it unless the OS specifically calls for it. See
here for details:
[url]http://www.support.microsoft.com/?id=321363[/url] SQL Server 7 & 2000 memory
usage

--

Andrew J. Kelly
SQL Server MVP


"Jon Mundsack" <mundsack@rochester.rr.com> wrote in message
news:bef4da$4ft4q$1@ID-168020.news.dfncis.de...

> I am watching the "Mem Usage" for the sqlserver.exe process in the Windows
> NT Task Manager climb at a rate of about 400k per minute. This has been
> going on steadily since the server was rebooted yesterday. We're now up

to

> 50% memory used out of a 2gb "limit"
> I don't know if it was doing this before, but it may be that this apparent
> memory leak is what caused the server to crash yesterday (which is why it
> was rebooted).
>
> What kinds of things can I look for that may be causing the leak?
>
>
>

[Swyl webforumsuser@macromedia.com]

I am trying to run a media display off of a director projector, I pull all the files from a directory and read them based upon a few different timers. The projector is running on Microsoft Windows Embedded. My problem is after a few minutes I get the following Application Error.

The instruction at "0x6a0236c4" referenced memory at "0x00000010". The memory could not be "written".

Could this be related to the timers? Perhaps a memory leak. I have included the following code which includes all my functions which are called by the timers at varying intervals.




Thanks in advance,
Sean

global preSet, currentBottomFile, currentImageFile, currentRightFile, currentLogoFile, theFiles4, theFiles, theFiles2, theFiles3
-- *Read Logo Dir Function
on readImageDirectory
imageType = "png"
theFiles2 = bafilelist(the moviePath & "LogoSource\","*." & imageType)
set the fileName of member ("LogoHolder") = string(the moviePath & "LogoSource\"&theFiles2[currentLogoFile])
end
-- *Read Image Dir Function
on readSecondDirectory
imageType = "psd"
theFiles3 = bafilelist(the moviePath & "ImageSource\","*." & imageType)
set the fileName of member ("ImageHolder") = string(the moviePath & "ImageSource\"&theFiles3[currentImageFile])
end
-- *Read Text Dir Function
on readTextDirectory
imageType = "html"
theFiles = bafilelist(the moviePath & "RightSource\","*." & imageType)
end
-- *Read Bottom Text Dir Function
on readTextBotDirectory
imageType = "html"
theFiles4 = bafilelist(the moviePath & "BotSource\","*." & imageType)
end
-- *Read Logo
on readNextLogo
currentLogoFile = currentLogoFile+1
if currentLogoFile > count(theFiles2) then
currentLogoFile = 1
end if
set the fileName of member ("LogoHolder") = string(the moviePath & "LogoSource\"&theFiles2[currentLogoFile])
end
-- *Read Image
on readNextImage
currentImageFile = currentImageFile+1
if currentImageFile > count(theFiles3) then
currentImageFile = 1
end if
set the fileName of member ("ImageHolder") = string(the moviePath & "ImageSource\"&theFiles3[currentImageFile])
end
-- *Read File Function
on readFromFile
put theFiles[currentRightFile]
set nada = ""
member("FieldTest").html = nada
global myFile
if objectP(myFile) then set myFile = 0
set myFile = new(xtra "fileio")
setFilterMask(myFile,"HTML Files,*.HTML,All Files,*.*")
filename1 = theFiles[currentRightFile]
if not voidP(the moviePath & "RightSource\" & filename1) and not (the moviePath & "RightSource\" & filename1 = EMPTY) then
openFile(myFile, the moviePath & "RightSource\" & filename1, 1)
if status(myFile) = 0 then
set theFile = readFile(myFile)
member("FieldTest").html = theFile
currentRightFile = currentRightFile+1
if currentRightFile > count(theFiles) then
currentRightFile = 1
end if
else
alert error(myfile,status(myfile))
end if
end if
closeFile(myFile)
set myFile = 0
end
-- *Read Bottom File Function
on readFromBottomFile
put theFiles4[currentBottomFile]
set nada = ""
member("FieldTest2").html = nada
global myFile2
if objectP(myFile2) then set myFile2 = 0
set myFile2 = new(xtra "fileio")
setFilterMask(myFile2,"HTML Files,*.HTML,All Files,*.*")
filename2 = theFiles4[currentBottomFile]
if not voidP(the moviePath & "BotSource\" & filename2) and not (the moviePath & "BotSource\" & filename2 = EMPTY) then
openFile(myFile2, the moviePath & "BotSource\" & filename2, 1)
if status(myFile2) = 0 then
set theFile2 = readFile(myFile2)
member("FieldTest2").html = theFile2
currentBottomFile = currentBottomFile+1
if currentBottomFile > count(theFiles4) then
currentBottomFile = 1
end if
else
alert error(myfile2,status(myfile2))
end if
end if
closeFile(myFile2)
set myFile2 = 0
if preSet<1 then
nextTime = timeOut("swapTime").new(6000, #setTheTime)
preSet=2
end if
end
-- *Clock
on setTheTime
member("FieldClock").text = the long time
put the long time
end
-- *Preload Function
on preloadMembers
if currentImageFile+1 > count(theFiles3) then
preload(the moviePath & "ImageSource\"&theFiles3[1])
unload(the moviePath & "ImageSource\"&theFiles3[currentImageFile-1])
else if currentImageFile-1 < 1 then
preload(the moviePath & "ImageSource\"&theFiles3[currentImageFile+1])
unload(the moviePath & "ImageSource\"&theFiles3[count(theFiles3)])
else
preload(the moviePath & "ImageSource\"&theFiles3[currentImageFile+1])
unload(the moviePath & "ImageSource\"&theFiles3[currentImageFile-1])
end if
end