OK thanks

I mean ..Anyone agree with me ???

What I need is to have the possibility to schedule backups...so I left active the SQL server Agent. Stop.

BTW I was always told of a 4GB limit on 32bit machine......

OK I disabled The SQL analisys service, the full text search, the SQL integration service and the reporting service (I did not install the SQL package and I assume that...

I monitored with sysinternal Process Explorer and discovered that , apart the Main SQL Service, the other does not take as much memory, and I think I could disable some...

I have the following running services

"SQL server",

"SQL server Agent",

"SQL Server Analisys Service",

"SQL Server Full text Search",

"SQL Server Integration Services",

"SQL Server Reporting Services",

"SQL...

I mean , what memory would you allocate for my server with 4GB RAM onboard ?? (my databases size is approximately 2 GB)

TIA

OK I'm gonna look for that..But in the meantime : what would you suggest for a server with 4GB RAM onboard?????

At this point a "rule of thumb" could be: set the maximum memory for the server to half the total RAM you have onboard... Could it be a goode guide...

Ok.. Tks I've got it !!..

What remains is the abnormal high value of the default setting ..it dos not make any sense!!! :crazy:

Since I've planned to add 2 more...

Please let me understend or I'll go nuts!!! The Default Memory for the server is set to 2147483647 (MB) right ??.

Does it mean over 2 Billion MB...

I mean a max memory usage set in SQL server 2005 of 1073741824 is approximately 1024 MB ???????????????????????????????????

TIA

ok i'll try to set th max memory usage at 1073741824 and see wha happen...

tks

You mean that the default value are OK (max 2147483647 is 2048MB???)

(I just can't figure out how the memory value is represented in SQL 2005 when you try to adjust...

my databases size is approximately 1.5 GB. Should I go for 4 GB RAM; and if I expand the RAM memory to 4 GB , shall I adjust...