How much memory for SQL

KoktGrus · 2007-04-17, 20:28

Can i set a upper limit for the MSSQL-memoryusage?

I only got 512 in my server (witch also runs a single-seat-setup)... Sometimes, when i check the SQL-server, it uses about 150 Mb, this feels a bit too much...

How much do i need and how do i adjust it??

anders.malm · 2007-04-17, 20:57

Hello! I have no idea how much memory you need but if you open SQL Server Management Studio Express, logon to the server, rightclick on it and select properties then you can edit the memorylimits.

Anders

Noelix · 2007-04-19, 08:13

http://wiki.team-mediaportal.com/TV-...0626fd4e709468

Check that out, it works.

2007-04-17, 20:28	#1 (permalink)
KoktGrus Portal Member Join Date: Nov 2006 Age: 19 Posts: 233 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	How much memory for SQL Can i set a upper limit for the MSSQL-memoryusage? I only got 512 in my server (witch also runs a single-seat-setup)... Sometimes, when i check the SQL-server, it uses about 150 Mb, this feels a bit too much... How much do i need and how do i adjust it??

2007-04-17, 20:57	#2 (permalink)
anders.malm Portal Member Join Date: Feb 2007 Location: Sollentuna Age: 45 Posts: 14 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	Adjusting SQL-server memory Hello! I have no idea how much memory you need but if you open SQL Server Management Studio Express, logon to the server, rightclick on it and select properties then you can edit the memorylimits. Anders

2007-04-19, 08:13	#3 (permalink)
Noelix Portal Member Join Date: Feb 2006 Location: Salt Lake City, UT Age: 26 Posts: 392 Thanks: 11 Thanked 1 Time in 1 Post Country: My System	http://wiki.team-mediaportal.com/TV-...0626fd4e709468 Check that out, it works. __________________

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
Use SQL Compact instead of SQL Express	Mottebelke	Improvement Suggestions	22	2007-03-29 15:02
SQLite instead of MS SQL	STSC	Improvement Suggestions	5	2007-03-27 07:45
Client or SQL issue???	Yucca	pre 1.0 RC1	5	2007-02-02 00:10
SQL Server Config	staigerpaip	General Talk	10	2006-11-09 16:36
Warum ausgerechnet Microsoft SQL?	lord_fritte	Media Portal - Allgemeines	8	2006-11-01 12:56