After a couple of weeks without touching, the SQL service will be sitting at over 1gb memory usage, and have to reset it. Apart from that I leave it alone.
After a couple of weeks without touching, the SQL service will be sitting at over 1gb memory usage, and have to reset it. Apart from that I leave it alone.
Have you had a look at this
http://wiki.team-mediaportal.com/TV-Engine_0.3/config-SQL-Server
About limiting memory usage for the SQL server
I had not seen it, not sure how I missed it during install OR why I didn't think to look when it first happened!
Install and setup was relatively painless apart from a few issues I had with getting MySQL to install the service correctly.
Can you elaborate on the issues you had and what steps you took to rectify ?