Solved

MSSQL Max Procs?

Posted on 2006-07-09
10
601 Views
Last Modified: 2007-12-19
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
Comment
Question by:maunded
  • 6
  • 4
10 Comments
 
LVL 7

Expert Comment

by:maUru
ID: 17069799
show variables like 'max_connections';

what does that show?

if its really low then try:

set GLOBAL max_connections=200;
0
 
LVL 7

Accepted Solution

by:
maUru earned 500 total points
ID: 17069804
mysql_pconnect might also help, rather than use mysql_connect
0
 
LVL 1

Author Comment

by:maunded
ID: 17069805
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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
LVL 7

Expert Comment

by:maUru
ID: 17069810
SHOW PROCESSLIST;
0
 
LVL 7

Expert Comment

by:maUru
ID: 17069817
and here is a site i found that you might find interesting:
https://www.webmasterpro.de/~ddanier/serverstats/demo/detail.php?graph=9
0
 
LVL 7

Expert Comment

by:maUru
ID: 17069826
ps ax | grep mysql | wc -l

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

Author Comment

by:maunded
ID: 17070016
Excellent, definitely going in the right direction...but Im using MSSQL, so is there a similar command for FreeTDS?....googling :)
0
 
LVL 7

Expert Comment

by:maUru
ID: 17071225
oh, i thought it was mysql, sorry i dont know much about freetds
0
 
LVL 1

Author Comment

by:maunded
ID: 17150284
Thanks, using mssql_pconnect soved the problem, it seems it was a combination of Apache/FreeTDS and PHP.ini limits.
0
 
LVL 1

Author Comment

by:maunded
ID: 17150294
Oh, and also, you can see how many mssql connections are active using phpinfo()
;)
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
is this a cms? 8 60
PHP populating an array. 4 23
PHP Parse error: syntax error, unexpected '[' 1 23
how to use 2 SELECT statements with prepared statements 19 28
Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question