How much memory for SQL (1 Viewer)

[KoktGrus]

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]

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

 

[Noelix]

http://wiki.team-mediaportal.com/TV...head-9b06f87b569f381bc4ad67df250626fd4e709468

Check that out, it works.