Jack

300,000 is perfectly normal. Ours all run at over 1,000,000.

The number of handles is proportional to your database bufferpool size.
There's an IBM article about it (try
http://www-1.ibm.com/support/docview.wss?uid=swg21112140). To summarise,
each 4kb buffer pool page requires the creation of four 'conditions', and
each 'condition' requires the creation of a minimum of two Windows
'events'. Each 'event' in turn requires a handle so, doing the maths, 128Mb
of buffer pool requires a minimum of 262144 handles.

I could live with this, if it weren't for one horrendous side effect. Each
event/handle requires 64 bytes of non-paged pool memory. This is hidden in
the kernel-mode usage, rather than being visible in the non-paged pool
memory of the user-mode DSMSVC.EXE process. (For anyone familiar with
POOLMON.EXE, try enable pool tagging and monitoring the usage against the
Even pool tag as you increase the BUFPOOLSIZE parameter in TSM.)

Again doing the maths, 128Mb of buffer pool immediateley requires 16Mb of
non-paged pool memory. Now non-paged pool memory is a pretty scarce
resource in 32-bit Windows and 16Mb represents an awfully large chunk.

We first encountered this problem when configuring a two-node cluster with
each cluster node running a TSM instance using a 1Gb buffer pool. When
testing the configuration in a failover scenario with both instances
running on the same box, the system was trying to satisfy requests for
256Mb of non-paged pool memory. Windows 2000 simply can't handle this,
regardless of the physical memory configuration. This makes TSM on Windows
considerably less scalable than any other platform.

I opened a PMR, but IBM claim this is a Windows architectural limit, and
not a TSM issue. I still maintain that the problem is in the TSM design as
the likes of Microsoft (eg SQL Server) and SAP design their buffering
differently to avoid the large non-paged memory requirements. In the end,
the PMR was closed and a DCR opened instead.

My opinions only, for what they're worth.

Regards
Neil Schofield
Yorkshire Water Services Ltd.




Download walks around Yorkshire Water's reservoirs at
http://www.yorkshirewater.com/yourenjoyment/main_walk.html
The information in this e-mail is confidential and may also be legally
privileged. The contents are intended for recipient only and are subject
to the legal notice available at http://www.keldagroup.com/email.htm
Yorkshire Water Services Limited
Registered Office Western House Halifax Road Bradford BD6 2SZ
Registered in England and Wales No 2366682