Solved

MSSQL Max Procs?

Posted on 2006-07-09
10
590 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
 
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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This article will explain how to display the first page of your Microsoft Word documents (e.g. .doc, .docx, etc...) as images in a web page programatically. I have scoured the web on a way to do this unsuccessfully. The goal is to produce something …
Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
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.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

706 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now