Information générale
Titre:
Server Configuration
While reviewing a SQL book, it made note that to help with performance, you could direct the "TEMPDB" to work from RAM. I made a change to the SQL configuration to allow some memory to be used for the TEMPDB in RAM. Changes would not be in affect until SQL restarted.
When I restarted (tried), it wouldn't load. When checking the error log report, it said not enough memory to load IN_RAM. Now, I can't get back to remove the IN_RAM setting. Is there some sort of back-door or config file that I can get my hands on to change this or am I completely hosed... (only beta data but would still be a PITA to reload)..
Any Ideas?
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement