Understanding database server performance warnings

Database server performance warnings appear in the database server message log. These warnings are reported when a database or database server reaches a state where its performance may be affected.


Performance warning: Server cache size is too small for database %1
Performance warning: Database %3 has a page size of %1 that does not match maximum of %2 set for server, causing inefficient use of cache"
Performance warning: No unique index or primary key for table %1 in database %2
Performance warning: Page size too small for database %1
Performance warning: Database file %1 consists of %2 disk fragments
Performance warning: In database %3, table %1 autoincrement column %2 is not indexed"
Performance warning: View %1 in database %2 was invalidated due to DDL operations on one of its referenced objects