What Is High Water Mark How We Check In Aspect Of Performance Issue

[Mike]

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

 

[Cringer]

A high water mark is the highest level that that metric has been at since the last DB restart. So in the case of database blocks.
Total number of database blocks: 1417
That's how many are available.
Database blocks high water mark: 1375
That's how many were in use at the point of the highest usage.
I would suggest you attend some training or hire a consultant. Your issues are a lot more fundamental than can be covered on this forum.