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 |
|
Soumya Kar
Starting Member
7 Posts |
 Posted - 2012-03-23 : 02:16:27
|
| We are working for a client with an asp.net/SQL server application which has been using a SQL Server 2005 system till now. The client has decided to upgrade the database to SQL Server 2008 R2 and has procured a powerful server machine with 16 processors with enough RAM and installed Windows Server 2008 64 bit on the system. Now we are tasked with the installation of SQL Server 2008 on the system followed by migration of the existing DB from the SQL 2005 box. Now I am not a SQL Server DBA nor am I a System Administrator by role. Hence, in spite of reading up a lot of the literature on the net, I am not quite able to make sense of it all or put it in the right order of execution. Can somebody explain me the following items, preferably in terms of bullet lists:• What are the points of consideration during installation of SQL Server 2008, specifically in terms ofo Configuring memory usageo Configuring the SQL Server to take advantage of the multiple processors availableo Other factors to configure to enable SQL Server 2008 features for performance and scalabilityo Other points, if any, for configuring the Windows Server 2008 with respect to SQL Server 2008 Note: We will only use the Database Engine services in SQL Server. The applications does not use SSIS, SSRS, etc. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2012-03-28 : 01:02:14
|
| I would recommend capping the RAM available to SQL Server via the "max server memory" property. - http://msdn.microsoft.com/en-us/library/ms178067.aspxThere isnt anything else that needs to be done specifically to make SQL Server recognize the additional resources.. Use your favorite search engine to look for "SQL Server 2008 Upgrade Technical Reference Guide". Highly recommended.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
SQL Server 2008 Installation pointers for optimizi