Re: Slower MS SQL server

Jeff Binkley ( jeff.binkley@asacomp.com )
Mon, 08 Dec 1997 14:27:00 -0500

-> > Memory allocated to SQL 40 MB, if more (ex: 60 MB) then slowdown.

-> Whats the actual number you put in the config? if you put
-> 60000, then thats 120mb of memory and definately causing a
-> swap problem. I run 45000 on my 128mb machines dedicated to
-> SQL Server, giving atleast 38mb of memory to NT.

Ok. So the allocation unit for SQL server is still in 2k pages like Sybase 10 &
11. That confirms my suspicion.

Jeff