GilaMonster (8/10/2008)

---

Mike Alfa (8/10/2008)

---

I would love to see your comments on structural difference between SQL 2000 and 2005. As this database was designed on SQL2000 and we upgraded to SQL2005...

Thank Gila and Rowan,

You people are really too good.

I would love to see your comments on structural difference between SQL 2000 and 2005. As this database was designed on SQL2000...

So finally,

I need to do following:

# No /3 GB or/userva required

# AWA enable with memory lock pages

# Max memory set to 7 GB

Pls. confirm....

GilaMonster (8/8/2008)

---

Do not use either /3GB or /userva if you are using AWE. You're asking for a unresponsive server.

You do need to enable AWE if you want SQL to use...