My company has SQL 2000 standard edition, loaded on win2k server, standard edition. my live database is currently 4982 MB in size. i understand that SQL 2000 standard edition will only allow a maximum of 2GB RAM allocated to itself regardless of how much RAM it really needs.
My question is, at what stage [size] am i going to out grow SQL standard edtion? my DB is nearly 5GB. i understand that we dont access the entire DB at any 1 time. concurrent users = 50ish++. the SQL process uses around 1.8 to 2GB RAM.
any users had experience here? what should i be looking for? users to complain its slow?? they already do! am i currently being limited?? im not sure