You can check cache statistics for a database by using the query database MaxL statement with the performance statistics grammar. See Monitoring Performance.