MSSQL Max Procs?

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.
LVL 1
maundedAsked:
Who is Participating?
 
maUruConnect With a Mentor Commented:
mysql_pconnect might also help, rather than use mysql_connect
0
 
maUruCommented:
show variables like 'max_connections';

what does that show?

if its really low then try:

set GLOBAL max_connections=200;
0
 
maundedAuthor Commented:
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.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
maUruCommented:
SHOW PROCESSLIST;
0
 
maUruCommented:
and here is a site i found that you might find interesting:
https://www.webmasterpro.de/~ddanier/serverstats/demo/detail.php?graph=9
0
 
maUruCommented:
ps ax | grep mysql | wc -l

should also work on a nix system, (not tested it)
0
 
maundedAuthor Commented:
Excellent, definitely going in the right direction...but Im using MSSQL, so is there a similar command for FreeTDS?....googling :)
0
 
maUruCommented:
oh, i thought it was mysql, sorry i dont know much about freetds
0
 
maundedAuthor Commented:
Thanks, using mssql_pconnect soved the problem, it seems it was a combination of Apache/FreeTDS and PHP.ini limits.
0
 
maundedAuthor Commented:
Oh, and also, you can see how many mssql connections are active using phpinfo()
;)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.