Cache Hit Rate, Bufpoolsize Size and NT
2002-02-11 04:21:52
Another week another problem... Hi Guys!!
I have a DB (shown Below) which I am having trouble with. The Cache Hit %
was static for months at 98%+, but since the database was rebuilt by a
friendly consultant (nice bloke!) I have been unable to achieve consistant
results above the mid 90's.
The Bufpoolsize parameter has been raised in stages to its current high of
327680 .. this does not appear to be having the desired effect.
Server: Dual Xeon 700Mhz (Dell 8450) running NT 4.0 SP6a
TSM V4.1.1.0
Selftune bufpoolsize is OFF
DB is spread over 5 files of 1GB on a Fast Raid 5 (R/WB
Cache enabled)
I have two questions for our assembled throng.
1) What do YOU think is a reasonable figure for Bufferpoolsize on NT for a
2.5b DB??
(I regard 327680 as quite high)
2) What else could be wrong?
Any help will be high appreciated
Many Thanks
Tony Morgan
Available Space (MB): 5,120
Assigned Capacity (MB): 5,120
Maximum Extension (MB): 0
Maximum Reduction (MB): 2,080
Page Size (bytes): 4,096
Total Usable Pages: 1,310,720
Used Pages: 676,424
Pct Util: 51.6
Max. Pct Util: 51.8
Physical Volumes: 10
Buffer Pool Pages: 81,920
Total Buffer Requests: 29,893,741
Cache Hit Pct.: 93.42
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 0.09
Percentage Changed: 0.00
Last Complete Backup Date/Time: 02/11/2002 08:00:16
============================================================
This e-mail and any files transmitted with it, are confidential and
This e-mail and any files transmitted with it, are confidential and
intended solely for the use of the addressee. The content of this
e-mail may have been changed without the consent of the originator.
The information supplied must be viewed in this context. If you have
received this e-mail in error please notify our Helpdesk by
telephone on +44 (0) 20-7444-8444. Any use, dissemination,
forwarding, printing, or copying of this e-mail or its attachments is
strictly prohibited.
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Cache Hit Rate, Bufpoolsize Size and NT,
MORGAN TONY <=
|
|
|