?
Solved

MSSQL Max Procs?

Posted on 2006-07-09
10
Medium Priority
?
612 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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.
Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Suggested Courses

777 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