Skip to Content
author's profile photo Former Member
Former Member

SQL Server parameter maintenance

Dear all,

How can I maintain the SQL server parameter, lighweight pooling, to speed up the communication with the SQL Server?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Aug 19, 2011 at 02:09 PM

    please use that very interesting link:

    http://lmgtfy.com/?q=SQLserverparameter%2Clighweightpooling

    Add a comment
    10|10000 characters needed characters exceeded

    • > 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

  • Posted on Aug 22, 2011 at 01:05 PM

    Hi,

    Check this.

    http://support.microsoft.com/kb/822219/en-us

    regards,

    John Feely

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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?

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.