Regenerate memory in SQL!!! | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Regenerate memory in SQL!!!

Hello, guys
I’m new on this, but i have 2 questions for you.
I’m using xseries206 3.0Ghz / 1Gb Ram /3 73gb 10k(RAID 1 S.O. + aplications in separate drives, but in same disk).My database is 10gb file, for about 30 people.I have a problem of performance of course!!!!My questions are, what should i do improve with this hardware, or what you should i buy!!!!???The second question is, does sql server standart edition/Windows 2000 Server, regenerate the memory?It’s because, when the sql server process (sqlservr.exe), achive the total of memory in server -1 Gb- i have to make a reboot of the sql server services to re-estabilish the normality.
Do you have any recommendations?
Regards, Paulovsky Regards, Paulo Soares
SQL try to get all memory he can, and that is normal.
If you don’t have a SQL server dedicate, then you can adjust max SQL memory (see sp_configure in BOL). About performance, I suggest to run Performance Monitor to and Profiler, you can find lot of articles in our forum. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
If SQL Server is the only application on the server, MIN SERVER MEMORY and MAX SERVER MEMORY to the same value and that means leave the memory settings to DYNAMIC. If SQL Server co-exists with one or more applications, lower the MIN SERVER MEMORY setting to count for the memory demands of the other application(s). If the other application fails to start in a timely manner, it may be because SQL Server has been operating at or near the MAX SERVER MEMORY setting and is slow in releasing memory to the new, and now starved, application. In this instance, lower the value of MAX SERVER MEMORY. Obviously, MAX SERVER MEMORY always needs to be greater than or equal to MIN SERVER MEMORY. Links and KBAs for your reference
http://www.sql-server-performance.com/sg_sql_server_performance_article.asp
http://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp http://support.microsoft.com/default.aspx?scid=kb;en-us;322883
http://support.microsoft.com/default.aspx?scid=kb;en-us;298475 Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>