on 08-19-2011 11:22 AM
Dear all,
How can I maintain the SQL server parameter, lighweight pooling, to speed up the communication with the SQL Server?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for answers. However I still didn't understand. Sorry.
I want to speed up to communication with the SQL server, by maintain the lighweight pooling parameter.
What should I do? For example, to determine the SQL Server uses fibers or threads to run user commands? or determine size of the thread pool or the fiber pool that the SQL Server system uses to maintain client connections?
please use that very interesting link:
http://lmgtfy.com/?q=SQLserverparameter%2Clighweightpooling
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Eric,
Thank you for your answer. However I didn't mean that.
I want to know which parameter size I have to maintain? For example,
Size of the pool of operating system processes, size of the thread pool, size of the fiber pool that SQL Server uses to maintain client connections etc. or determine that the SQL server uses fibers or threads to run user commands? Which one?
> Size of the pool of operating system processes, size of the thread pool, size of the fiber pool that SQL Server uses to maintain client connections etc. or determine that the SQL server uses fibers or threads to run user commands? Which one?
The "sizes", as with any numbered parameter, is dependent on the usage of the system, number of users, numbers of (different) applications/modules using the database etc.
Markus
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.