SQLServer Memory (1 Viewer)

[hurz8888]

Hi,

the SQL Server grabs about 750MB of memory. In trying to set the upper limit to 128MB, I cannot find the application, where I can set the DB limit.

My START->PROGRAMS->SQLSERVER->CONFIG TOOLS menu shows only the "SQL Server Configuration Manager" and the "SQL Server Surface Area Configuration" programs...

(Media Portal RC 1.0 RC1 / TV Server 1.0 RC1 / Windows XP SP2)

Where is the config app?
How to set the limit manually?

Regards,
Rainer

 

[disaster123]

I know, that this is not an answer of you question - but it is a solution.

Use MySQL with the following addition options in the my.ini:
Unter [mysqld]:
myisam_recover=BACKUP,FORCE
query_cache_size = 42M

and you'll get happy.

 

[Juppe]

Install this first:
http://wiki.team-mediaportal.com/TV-Server/install-SQL-Management-Studio

Then the last picture on this side might help.
TV-Server/Configuration/SQL-Server - MediaPortal Wiki Documentation

/Juppe