cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server parameter maintenance

Former Member
0 Kudos

Dear all,

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member189546
Active Contributor
0 Kudos

Hi,

Check this.

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

regards,

John Feely

Former Member
0 Kudos

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?

former_member204746
Active Contributor
0 Kudos

please use that very interesting link:

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

Former Member
0 Kudos

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?

markus_doehr2
Active Contributor
0 Kudos

> 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