pagelatch question

We are running sql server 2000 on Data center. There has been performance
issues and I have noticed from sysprocesses table there is always wait on
Pagelatch_ex, Pagelatch_sh, Pageiolatch. When I look at Perfmon counter I
see Avg latch wait time 420 seconds, Latch wait/sec 200 and Pagesplit/sec 5.
I feel like most of the time has been spent on latch wait of some sort,
following are my questin
1. Is Avg latch wait time 420 is normal?
2. Why so many (200/sec) latch wait? Is it because of high page split
(5/sec, or is it really high).
3. What Can we do about those latches?
I would really appreciate if someone can give more information about the
latches and may be send a link to good web site/article about it.
thanks,> We are running sql server 2000 on Data center. There has been performance
> issues and I have noticed from sysprocesses table there is always wait on
> Pagelatch_ex, Pagelatch_sh, Pageiolatch. When I look at Perfmon counter I
> see Avg latch wait time 420 seconds, Latch wait/sec 200 and Pagesplit/sec
5.
(...)
> I would really appreciate if someone can give more information about the
> latches and may be send a link to good web site/article about it.
See
http://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp
on latches
Also check KB for latches
http://support.microsoft.com/search/default.aspx?InCC_hdn=true&QuerySource=gASr_Query&Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=msall&Queryc=latch&Query=latch&KeywordType=ALL&maxResults=25&Titles=false&numDays=&InCC=on
Andrew posts some good sources for performance tuning:
http://groups.google.pl/groups?q=%22avg+latch+wait%22&hl=pl&lr=&ie=UTF-8&oe=UTF-8&selm=OgM0fZSRCHA.4040%40tkmsftngp09&rnum=1
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.