June 7, 2010 at 7:21 am
Hi,
Am very much confused with the term how do you configure your sql server 2000/2005/2008?
I would like to know what configurations can be made before / after install?
What would a senior DBA would expect if he is asking a new guy getting into SQL Server Administration??
Thanks in Advance.
June 7, 2010 at 12:46 pm
I can't imagine that being a straight forward question. I would estimate that the majority of installs are ready to run with no additional configuration out of the box. I would also say that 95% of Sql servers will end of with some sort of configuration post install as roles change and business needs arise. I would also say that 100% of DBA will take a different approach to those as defined by there own stiuations dictates.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 7, 2010 at 3:29 pm
it all depends on
32 bit or 64 bit
memory available
CPUs available
SQL Server edition
and others besides. For example, What is the servers intended workload?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 8, 2010 at 8:04 am
I have more number of CPU's on my server. How to enable the multi-processor ?
Is that always good to take advantage of multiple CPu's or else any drawbacks or limitations or measures we need to take care while configuring multiple CPU's
I would like to know more on SQL server configurations. Want to know more specific configurations which done while confiuring a sql server for optimal performance and etc...
Thanks!
June 8, 2010 at 9:12 am
Oracle_91 (6/8/2010)
I have more number of CPU's on my server. How to enable the multi-processor ?
multiple sockets or cores or both??
Oracle_91 (6/8/2010)
Is that always good to take advantage of multiple CPu's or else any drawbacks or limitations or measures we need to take care while configuring multiple CPU'sI would like to know more on SQL server configurations. Want to know more specific configurations which done while confiuring a sql server for optimal performance and etc...
Thanks!
as i said it all depends, there is no hard and fast config except that which comes out of the box!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2010 at 2:52 am
There are no short-cuts to knowing what is the best configuration for your installation. You need to try things out to gain experience of what works best, or hire an expert to show you what to do.
Part of gaining experience is looking at forums such as this one, picking the questions that interest you and looking at the answers. You will soon find there are people who often give an answer that others find difficult to improve on, so you can learn from their advice. There are other good forums on the net, Google can find them for you. Remember, everyone you find who you consider to be an expert started by knowing nothing about SQL Server and learning from other people.
Also try to find a local SQL user group. These can be a good way of getting advice from people with more experience.
The FineBuild tool that I publish has a large section on configuring SQL Server, with the scripts to do the work. The FineBuild default configuration is good for most installations, but if you have unusual requirements then you need to work out your own configuration.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 9, 2010 at 9:39 am
Thanks So much. That is what am try to do. Thanks for the suggestions.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply