 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008processor and ram
hi guys, i need some advice. we have here: win2003r2sp2-32bit 4gb ram dual quad-core xeon (8 cpu´shown and managable) 2 instances sql2000sp4, both with default settings, both equally used ... what would now be the recomended settings to provide the best solution. how should ram and procs be splitted to maximize performance? ram for system: 1gb ram for sql#1: 1.5gb ram for sql#2: 1,5gb proc 0+1 : system proc 2-4: sql#1 proc 5-7: sql#2 or what do you guys think? thanx in advance juergen ladrick I would definately let SQL and the OS manage processor resources. There is also a good case to leave both instances's memory dynamic. Either way, we do not have enough info to say how it should be split.  SignatureJason Massie Web: http://statisticsio.com RSS: http://feeds.feedburner.com/statisticsio hi guys, i need some advice. we have here: win2003r2sp2-32bit 4gb ram dual quad-core xeon (8 cpu´shown and managable) 2 instances sql2000sp4, both with default settings, both equally used ... what would now be the recomended settings to provide the best solution. how should ram and procs be splitted to maximize performance? ram for system: 1gb ram for sql#1: 1.5gb ram for sql#2: 1,5gb proc 0+1 : system proc 2-4: sql#1 proc 5-7: sql#2 or what do you guys think? thanx in advance juergen ladrick You need to provide more information regarding your performance requirements and the characteristics of teh workloads for each instance. No specific recommendations can be made based soly on the info you have provided. Linchi > hi guys, > [quoted text clipped - 24 lines] > > juergen ladrick |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.