Mike
Moderator
what is high water mark how we check in aspect of performance issue?
Database version number: 1174
Database state: Open (1)
Database damaged flags: None (0)
Integrity flags: Executing with -r (0)
Database block size (bytes): 1024
Total number of database blocks: 1417
Database blocks high water mark: 1375
Free blocks below high water mark: 116
Record blocks with free space: 3
Before image block size (bytes): 8192
Before-image cluster size (kb): 512
After image block size (bytes): 8192
Last transaction number: 169
Highest file number defined: 0
Database create (multi-volume): 03/25/04 16:05
Most recent database open: 06/04/04 14:19
Previous database open: 06/04/04 14:19
Local Schema cache time stamp: 03/24/04 20:47
Most recent .bi file open: 06/04/04 14:20
RETURN - show remaining, U - continue uninterrupted, Q - quit:
Previous .bi file open: - -
Time since last truncate bi: 0 (seconds)
Most recent full backup: 05/26/04 15:06
Database changed since backup: Yes
Most recent incremental backup: - -
Sequence of last incremental: 0
RETURN - repeat, U - continue uninterrupted, Q - quit
how we check performance ? High water mark here?? how please give me description of all fileds?
please help
regards Shane
Database version number: 1174
Database state: Open (1)
Database damaged flags: None (0)
Integrity flags: Executing with -r (0)
Database block size (bytes): 1024
Total number of database blocks: 1417
Database blocks high water mark: 1375
Free blocks below high water mark: 116
Record blocks with free space: 3
Before image block size (bytes): 8192
Before-image cluster size (kb): 512
After image block size (bytes): 8192
Last transaction number: 169
Highest file number defined: 0
Database create (multi-volume): 03/25/04 16:05
Most recent database open: 06/04/04 14:19
Previous database open: 06/04/04 14:19
Local Schema cache time stamp: 03/24/04 20:47
Most recent .bi file open: 06/04/04 14:20
RETURN - show remaining, U - continue uninterrupted, Q - quit:
Previous .bi file open: - -
Time since last truncate bi: 0 (seconds)
Most recent full backup: 05/26/04 15:06
Database changed since backup: Yes
Most recent incremental backup: - -
Sequence of last incremental: 0
RETURN - repeat, U - continue uninterrupted, Q - quit
how we check performance ? High water mark here?? how please give me description of all fileds?
please help
regards Shane