Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MSSQL Max Procs?

Posted on 2006-07-09
10
Medium Priority
?
620 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

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.

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.
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.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
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.
Suggested Courses

618 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