Hash Bucket setting for Server with 1 Gig of RAM ?

[Machina]

[Patrick]

Yes, you could modify the hash bucket value.
In front of performance trouble, you could start more basically than this value. Hash bucket is not a panacee.
What is the current average chain ?
Patrick


------------
machina at 8/6/01 5:33:22 PM

I am having serious performance problems with a SQL Server 6.5 on a NT 4 box (service pack 6). Is there a standard recommendation for Hash Bucket setting on a box with 1 gig of RAM ?

Thanks!


------------
Machina at 8/6/01 5:29:58 PM

[Patrick]

------------
machina at 8/6/01 5:33:22 PM

I am having serious performance problems with a SQL Server 6.5 on a NT 4 box (service pack 6). Is there a standard recommendation for Hash Bucket setting on a box with 1 gig of RAM ?

Thanks!


------------
Machina at 8/6/01 5:29:58 PM

[Patrick]

Sorry for the empty message.
So, about your performance Pb. could give some global informations.
What kind of trouble, symptoms,..
when this appens,
what kind of processes, OLTP or DataWareHousing,
What kind of investigations have you already done...
Patrick


------------
Machina at 8/6/01 5:29:58 PM