New
#11
all i have seen so far is
sql server use up to 800 meg of ram
then media portal freezes and when i check some how mediaportal exe has taken the ram some how
i havent checked any further but i have turned on handles now so will check if i can find out more now
it can run for 2 hours or 2 days then the problem shows up
SQLServer attempts to collect as much memory as it can get its hands on, but it's all given back when it's needed. (SQL's own internal memory management complexity rivals that of the OS.)
The fact that your symptom is periodic and measured in days-after-reboot is strongly suggestive of a resource leak. It may not be a handle leak though - there are many other different types of memory/resources which are sometimes leaked due to programming oversights.
We should probably give the OP their thread back, but if you'd like to troubleshoot, I or others here can possibly help.
ok
it is a new problem about 6 to 10 weeks when it started i will open a new thread and maybe you can find my problem
cheers brad
It could be your utorrent is using up your resources. It a file sharing service.