| Latch Contention [message #58148] |
Mon, 04 August 2003 22:28  |
Devashish Rughwani
Messages: 6
Registered: November 2002
|
Junior Member |
|
|
Dear all
How to know the default values for the following initialization parameters
1.log_small_entry_max_size
2.log_simultaneous_copies
on Win 2000 Sp3
I want to tune the above parameters to avoid latch contention
Thanks
Devashish
|
|
|
|
| Re: Latch Contention [message #58175 is a reply to message #58148] |
Tue, 05 August 2003 09:45  |
shad
Messages: 50
Registered: October 2000
|
Member |
|
|
But do you have latch contention currently?
Remeber, why fix it if it ain't broken.
Also remember to follow the corect sequence in tuning, that is, application --> Memory --> I/O--> Contention --> OS.
What I am trying to emphasize is it makes no point in tryinig to focus your tuning efforts on latch contention, freelist contention, etc if your have not sized up your memory properly.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
