Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Average Latch wait time

Status
Not open for further replies.
Kydreom

Kydreom

IS-IT--Management
Oct 25, 2000
16
0
0
GB
Does anyone have any experience of the following situation:

We run SQL Server 2000 on Windows 2000 with SP3. We run the latest service packs on the SQL server. We are not experiencing any locks on any of the tables, yet for some reason the Average latch wait time seems to be very high. This is despite the fact that the other two latch counters (Latch Waits/sec and Total Latch Wait Time (ms)) are running as expected. Even when these are at around 0 the latch wait time on our server is over 400.

As a consequence of this performance is suffering, I wonder whether anyone else has had a similar experience.

Thanks
 
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
207
Chris Miller
Chris Miller
Bhashi
  • Locked
  • Question
Related to Average 1
Replies
1
Views
40
Andrzejek
Andrzejek
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
120
Andrzejek
Andrzejek
niall5098
  • Locked
  • Question
Create plan guide with date time parameters
Replies
3
Views
67
Chris Miller
Chris Miller
tn_sudheer
  • Locked
  • Question
Accessing data from database between given time stamps
Replies
11
Views
105
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top