S
steve pittman
Guest
Please note that there are a couple of significant sql connection (thread) resource allocations. These are controllable by startup parameters, and depend of course on the user workload characteristics (query needs, i.e.). These are just the 2 that occur to me without checking any details of sql operation. Buffer allocated for sorting, grouping, and other internal temp table uses – 1M memory by default. Configured by startup parameter -SQLTempBuff. See our doc for more info. Sql statement cache – for efficient statement exec and re-exec and re-use. Set as 100 statement by defaults. 100 statements, esp. complex statements, can consume a lot of memory. 100 statements, with a 50/50 mix of complex and simpte, statements, might use 30-50M . If re-use does not matter, can be set to a much smaller value. Going below 20 would probably not be good. Hope this helps, ….steve pittman [OE sql software architect…..]
Continue reading...
Continue reading...