Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 637
  • Last Modified:

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.
0
maunded
Asked:
maunded
  • 6
  • 4
1 Solution
 
maUruCommented:
show variables like 'max_connections';

what does that show?

if its really low then try:

set GLOBAL max_connections=200;
0
 
maUruCommented:
mysql_pconnect might also help, rather than use mysql_connect
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now