Click to See Complete Forum and Search --> : max_procs question


aCa
11-30-2005, 06:21 AM
Hi. I see in the php.ini that you can override the number of max procs on det mssql server.

; Specify max number of processes. Default = 25
;mssql.max_procs = 25

But what is a process on the mssql server? Do a web application use on process or one process per user or does one application use one process. Not sure how this works.

I saw in the php_mssql.c that the dbsetmaxprocs is used. Seems its this function that use the max_procs to set the value to the datbase. You can see more about it here (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dblibc/dbc_pdc04e_1b8z.asp). In the table at the bottom of the page one of the table headers state: "Maximum number of connections per workstation".

Anyone know more about this how this work.