<div>
show variables like 'max_connections';<br />
<br />
what does that show?<br />
<br />
if its really low then try:<br />
<br />
set GLOBAL max_connections=200;
</div>


show variables like 'max_connections';

what does that show?

if its really low then try:

set GLOBAL max_connections=200;

<div>
I need to know how many are active at one time, not what the variable is set to.<br />
Id like to be able to graph this, so I can see how often we max out our connections.
</div>


I need to know how many are active at one time, not what the variable is set to.
Id like to be able to graph this, so I can see how often we max out our connections.

<div>
and here is a site i found that you might find interesting:<br />
<a href="https://www.webmasterpro.de/~ddanier/serverstats/demo/detail.php?graph=9" rel="ugc">https://www.webmasterpro.de/~ddanier/serverstats/demo/detail.php?graph=9</a>
</div>


and here is a site i found that you might find interesting:
https://www.webmasterpro.de/~ddanier/serverstats/demo/detail.php?graph=9 [https://www.webmasterpro.de/~ddanier/serverstats/demo/detail.php?graph=9]

<div>
ps ax | grep mysql | wc -l<br />
<br />
should also work on a nix system, (not tested it)
</div>


ps ax | grep mysql | wc -l

should also work on a nix system, (not tested it)

<div>
Excellent, definitely going in the right direction...but Im using MSSQL, so is there a similar command for FreeTDS?....googling :)
</div>


Excellent, definitely going in the right direction...but Im using MSSQL, so is there a similar command for FreeTDS?....googling :)

<div>
oh, i thought it was mysql, sorry i dont know much about freetds
</div>


oh, i thought it was mysql, sorry i dont know much about freetds

<div>
Thanks, using mssql_pconnect soved the problem, it seems it was a combination of Apache/FreeTDS and PHP.ini limits.
</div>


Thanks, using mssql_pconnect soved the problem, it seems it was a combination of Apache/FreeTDS and PHP.ini limits.

<div>
Oh, and also, you can see how many mssql connections are active using phpinfo()<br />
;)
</div>


Oh, and also, you can see how many mssql connections are active using phpinfo()
;)

<div>
<div class="content wysiwyg-content">
Hi,<br />
Does anyone know how I can tell the number of mssql processes active at any time on a Apache/PHP server?<br />
Im trying to figure out if the connect errors I am getting are because I dont have the mssql.max_procs set high enough.<br />
Thanks!<br />
D.<br />

</div>
</div>


Hi,
Does anyone know how I can tell the number of mssql processes active at any time on a Apache/PHP server?
Im trying to figure out if the connect errors I am getting are because I dont have the mssql.max_procs set high enough.
Thanks!
D.


MSSQL Max Procs?

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.