I have a small database in ASA9, and like to load all database in memory, for more faster response. How i can do this?
asked 15 Aug '13, 13:50
Hi Douglas, you can't load database in memory with ASA9. The only things you can do are:
Be careful, I talk about cache. If you need in-memory option you should use newer versions ( it's available from 11.x ). Bye
answered 16 Aug '13, 05:06
While putting more of your database data in RAM is always the first thing to try, it does not guarantee faster response time. For example, you may have runaway queries that consume vast amounts of CPU time, and/or use vast amounts of temporary space which may go to disk even though you have lots of RAM cache. You can query various PROPERTY(), DB_PROPERTY() and CONNECTION_PROPERTY() statistics to determine what's going on.
Or, you can save a lot of time and effort and run Foxhound which works on V9 databases.