September 14, 2010 at 2:02 pm
hi all
on our new sql 2005 setup, both the below options are enabled
1.auto set processor affinity for all processors
2. auto set i/o affinity mask for all processors
but from reading i dont think i should have both enabled at once? (not for each processor either 1 0 or 0 1)
is this correct? how should this be setup for a 4 proc system
also i notice that auto growth of the main db is set at 1mb unrestricted! is that a little mean?
September 14, 2010 at 2:37 pm
Hello there,
As for how you should set your procesors i cant comment as i dont know. =[ sorry
As for the main db with auto growth to 1MB... if i was you i would give your main db to start the amount of space it needs and about 20% extra then auto grow on your databases by percentages(usually 10%-15%). I prefer percentages but growing with MB's give a bit more control in the end as to how much you are allocating to your dta when it needs it. I use both in my environemts and either has been working well in my different environments. I am sure others will have different ideas which means there are plenty ways to skin a cat =]. Also you have to make sure that when you auto grow you might want to make sure you "cap" it so that you dont out grow the area you have your data stored.
Good Luck
DHeath
September 14, 2010 at 2:47 pm
You have to license all 4 processors, so why not let SQL use them? Are there other applications running on this server that you need?
Typically these are set by default to work with all CPUs and it works fine.
As far as db disk growth, I agree with what is above in that you set a size, add some pad. I don't know if I'd do 20%. I'd guess what I'll need over the next few months and set it for that amount of space. You do not want the database autogrowing as this fragments the files, and can worsen performance. I manage space proactively, adding chunks as needed, and not relying on autogrow.
September 14, 2010 at 2:53 pm
hi guys
thanks for input
no other apps on server, so what about the i/o mask do i leave that enabled for all as well?
September 14, 2010 at 3:03 pm
Yes
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply