Hi,
How does this "minimum memory per query" option work in SQL Server 2005?
Does it have any influence on performance? When it is put higher than the
standard value, does this mean that more memory will be reserved for each
query, and he will have a hard time to run multiple queries at the same
time?
thanks a lot and kind regards,
PieterYou can use sp_configure to set this a desired value. Check SQL Server Books
Online for the exact syntax.
For light weight databases, it may be a good option to try. However, if you
have a large database with long running transactions on massive datasets or
large number of concurrent connections, using min memory settings is not
recommended. In most cases, it is better to leave it to default since the
query processor usually can figure out the optimal memory allocation for
simple queries.
--
Anith
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment