Solved

MSSQL Max Procs?

Posted on 2006-07-09
10
608 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 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
Don't Cry: How Liquid Web is Ensuring Security

WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.

 
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

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!

Question has a verified solution.

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

Developers of all skill levels should learn to use current best practices when developing websites. However many developers, new and old, fall into the trap of using deprecated features because this is what so many tutorials and books tell them to u…
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
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…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

724 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