SQLServer Memory

hurz8888 · 2008-07-09, 13:41

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 · 2008-07-09, 15:13

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 · 2008-07-09, 15:42

Install this first:
http://wiki.team-mediaportal.com/TV-...agement-Studio

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

/Juppe

2008-07-09, 13:41	#1 (permalink)
hurz8888 Portal User Join Date: Jul 2008 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts	SQLServer Memory 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

2008-07-09, 15:42	#3 (permalink)
Juppe Portal Member Join Date: Nov 2006 Posts: 177 Thanks: 5 Thanked 4 Times in 4 Posts Country: My System	Install this first: http://wiki.team-mediaportal.com/TV-...agement-Studio Then the last picture on this side might help. TV-Server/Configuration/SQL-Server - MediaPortal Wiki Documentation /Juppe Last edited by Juppe; 2008-07-09 at 15:45..

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySQL or MS SQLServer ???	vvulture	MediaPortal 1 Talk	8	2007-07-11 17:25
SQLServer Problems with latest releases.	joboehl	pre 1.0 RC1	4	2007-01-26 12:14
The database backend (provider SQLServer) could not be reached.	YAG	Television (MyTV frontend and TV-Server)	25	2007-01-09 11:33
SQLServer Express on VIA Eden	THDBASED	MediaPortal 1 Talk	4	2006-10-26 11:47
Memory Footprint	Anonymous	Improvement Suggestions	1	2004-07-14 06:55

2008-07-09, 15:13	#2 (permalink)
disaster123 MP Donator Join Date: May 2008 Age: 28 Posts: 1,970 Thanks: 75 Thanked 199 Times in 92 Posts Country: My System	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.