Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-02-03 : 22:14:42
|
| Hi,I have a question on server Level configurations when we are going for 2008 migration from 2000.What all parameters can i set to the 2008 instance to improve the performance compared too sql 2000 Like Memory settings, multiprossor settings so that utilise my cpu's optimally ....Thanks in Advance. |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-02-08 : 15:31:51
|
| Take a look at the output of SP_Configure. First run USE master;GOEXEC sp_configure 'show advanced option', '1';inorder to set it to show all of the configuration info.In my personal opinion, and other more experienced DBAs may contradict me here, but I believe SQL Server 2008 is generally pretty well tuned out of the box when it is installed onto a proper I/O subsystem.I would not tweak anything in SP_Configure without having a very specific reason and only after testing it. I have seen people who have SQL Server 2008 on systems that are not only used as DB servers set the memory to lower than the max available, though, so that the other applications have enough memory to run properly, though. |
 |
|
|
|
|
|
SQL 2008 instance level settings for better perfor