How much RAM does TVservice needs? (1 Viewer)

[Gixxer]

Gixxer

I take it you have MSSQL memory set to use 128mb, does it exceed this at all.

Just to be exact on this i'm on a singleseat setup using RC3 with no svn, also using dvbepg grab, 3 hrs running and 43mb, will disable standby and check in morning for any major changes.

im running tvserver with no svn.

right now tvservice has not gone very mad 113 mb

but sqlservr.exe is at 340mb

is there a way of limiting the amount of ram sqlservr can use?


why does this happen? any guess?


i want to really fix this issue and not just kill + start tvservice every 24 hours. also, we are working on this, so have a look anyone who is interested...

https://forum.team-mediaportal.com/plugins-47/tvsauditor-48675/

 

[tourettes]

but sqlservr.exe is at 340mb

is there a way of limiting the amount of ram sqlservr can use?

why does this happen? any guess?

SQL server will use all available free RAM for its cache. It will release it as soon as there is some real need for the RAM. So you should be actually happy that SQL server is using the memory as it will speed up TVE3's functionality (mainly EPG related).

If you really want to limit the memory usage (and performance gains) then you can limit the RAM usage of SQL server. Check the wiki for more details (sorry cannot remember the exact place where the RAM limit can be set).

 

[Paranoid Delusion]

TV-Server/Configuration/SQL-Server - MediaPortal Manual Documentation

After 12 hours of non stop running 49mb, SQLserver 188mb out of max memory set 256mb.

Would not think these resources would change much in the next 12 hrs, but will leave running anyway, got some transcoding to do.

 

[charli181]

Mine is a 24*7 server as well. I just rebooted mine today after 6 weeks of operation but my total memory usage never goes over 600MB. this is for the following
SQLServer - Gets hit every second of the day with select statement - (due to design of another time dependant application application)
Apache Web
MP Web Interface
TV Server with 2 DVB-T cards (1.0 RC3 Only - Rolled back today for other reasons)
LanSuite 2004 (Email,Web Proxy, FTP Server)

My OS is Win2003 Standard and the CPU is never maxed out (SD TV is 7%, HDTV is 14%). I will update in a couple of days with my stats again.

currently 25/11/208

SQL Server is 101,300K - 32 threads, 457 Handles
SQLBrowser - 2,312K - 3 Threads - 85 Handles
SQLWriter - 3,628K - 7 Threads - 71 Handles
TVService is 42,380K - 24 Threads, 658 Handles

 

[Da_JoJo]

reducing the amount of ram msql uses is not a good practice as it will take the ram that is available and release it when it is needed.for caching purposes. It is not a problem in my opinion.

 

[andreaswith]

I have this problem also. Found another thread about it here (seems like the same problem to me, at least):

https://forum.team-mediaportal.com/1-0-rc3-svn-builds-289/memory-leak-tv-server-48231/

 

[Gixxer]

but sqlservr.exe is at 340mb

is there a way of limiting the amount of ram sqlservr can use?

why does this happen? any guess?

SQL server will use all available free RAM for its cache. It will release it as soon as there is some real need for the RAM. So you should be actually happy that SQL server is using the memory as it will speed up TVE3's functionality (mainly EPG related).

If you really want to limit the memory usage (and performance gains) then you can limit the RAM usage of SQL server. Check the wiki for more details (sorry cannot remember the exact place where the RAM limit can be set).

hi tourettes, thanks for that info. i thought it was bad that sql was using so much ram, i thought something wrong was happening. if thats the way of working for it, then great. as long as it does what u said, and release the ram when others need it.

about tvservice, i think its a different issue. i dont think its meant to use so much ram. i have 2 gb for a server so there is plenty left, however when cpu usage goes up <== NOT GOOD !!

im going to continue logging to see if i can find any reason for this happening. specially with rc4, to see if its a problem with my setup or tvservice (as others have also reported this problem)

everyone for the input !!