hi, i am using windows2003 and sql 2000 standard edition. The maximum capacity of sql engine in this situation is 2gb of ram. If i have say 4 gb of ram, can operating systme use it or any amount of ram beyond 2gb is will not be used os or sql. regards thiru THIRUVENGADAM
Yes SQL Standard edition uses is limited to use only 2GB and the remaining RAM will be controlled by Windows2k3. _________ Satya SKJ Moderator SQL-Server-Performance.Com