October 29, 2008 at 8:02 am
Minimum space on the server and Maximum space on the server, how much should I put?
October 29, 2008 at 8:27 am
What type of space do you mean? Space on HDD or RAM
October 29, 2008 at 1:39 pm
Lots of space - whatever that means to you :hehe:
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 29, 2008 at 1:53 pm
The more the better (and more $$ too)
For SQL Server 2005 minimum requirements
http://www.microsoft.com/Sqlserver/2005/en/us/system-requirements.aspx
October 30, 2008 at 7:28 am
My space is on RAM 7935. My minimum server memory on the server (I got it from server properties is 0 MB) and maximum is 2147483647 on the server. Is HDD means hard drive space?
October 30, 2008 at 7:41 am
I think you're confusing space and capacity.
RAM is a set number in the server. You can add more, but at a given time, that doesn't change. How much should you allocate to SQL? If this server runs SQL Server only (and Windows), then let SQL Server manage it. If you need to limit SQL Server, do that. The minimum doesn't matter.
For hard drive space, you need what you need. That's completely data dependent.
October 30, 2008 at 8:40 am
So you are saying I can leave it as minimum 0?Thank you
October 30, 2008 at 9:58 am
I think you are talking about min/max server memory which you do from sp_configure. try the following and see what you get:
sp_configure ' show advanced option', 1
reconfigure
sp_configure
from there you should be able to see your min and max memory allocated to the server.
Basically, here is what I did for my environment. We have total 18GB
I gave min = 8GB and max = 12GB.
This leaves the OS to take 6GB which will make the server optimize.
At the same time, SQL will never fall inder 8GB at anytime making it optimized for SQL as well. You can mimic my specs here for you if you have the same.
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
October 30, 2008 at 11:00 am
This is what I have
affinity mask-2147483648214748364700
allow updates0100
awe enabled0100
c2 audit mode0100
cost threshold for parallelism03276755
Cross DB Ownership Chaining0111
cursor threshold-12147483647-1-1
default full-text language0214748364710331033
default language0999900
fill factor (%)010000
index create memory (KB)704214748364700
lightweight pooling0100
locks5000214748364700
max degree of parallelism03200
max server memory (MB)4214748364721474836472147483647
max text repl size (B)021474836476553665536
max worker threads3232767255255
media retention036500
min memory per query (KB)512214748364710241024
min server memory (MB)0214748364700
nested triggers0111
network packet size (B)5123276740964096
open objects0214748364700
priority boost0100
query governor cost limit0214748364700
query wait (s)-12147483647-1-1
recovery interval (min)03276700
remote access0111
remote login timeout (s)021474836472020
remote proc trans0100
remote query timeout (s)02147483647600600
scan for startup procs0100
set working set size0100
show advanced options0111
two digit year cutoff1753999920492049
user connections03276700
user options03276700
October 30, 2008 at 11:24 am
Whatever total space you have, allocate 20% to the OS and the rest you can allocate to SQL Server. Then within that 80% that you are allocating to the SQL Server, take 40% of that for the Minimum and Maximum stays at the 80% of total system resources.
Hope this helps.
October 30, 2008 at 2:44 pm
Looks like you never configured the server memory. Allocate them as I have said above and you should be having an optimized server.
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply