Hi everyone, we are a large school with 2000+ students and 20 years of old sims data still on our servers, we are running into some performance issues with sims and wondering if people can steer me in the right direction. As far as I am aware having more RAM in the system than the main database is advisable we have 48GB of RAM and our database is only 30gb however our linked documents server is over 240gb! Is there a feasible way to reduce this without the entire SQL becoming a nonsensical mess because it cant find things anymore. We haven't run the re indexing patch for a while and as far as I am aware we have never run the housekeeping for orphaned documents either or the address tidy and merge routines.
I'm not looking to delete it all mainly archive it so its not part of the actively loaded document server.
Any help or advice is appreciated