[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Why this server so slow

Posted on 1997-08-14
9
Medium Priority
?
242 Views
Last Modified: 2013-12-23
Now We have a solaris 2.5.1 server which run sendmail,pop3,
http,informix database. but since it worked, it runs sometime slow sometime quick, the web is slow till time out sometime, so does sendmail,pop3. I really don't why and how to deal with it.
0
Comment
Question by:gaofei
[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
9 Comments
 
LVL 5

Expert Comment

by:n0thing
ID: 1582270
Hi,

   Well .. it's really hard to solve your problem without
knowing the hardware you're running on, the memory. First,
you seems to be running too much stuff on it ... If the
average load on your server is more than 5 ...then I think you
will need to split the load on another server. When it's slow .. try to check how many processes are running ... same for the it's fast. Check which one is taking the most CPU & memory.
   The command "ps" will show you the process, "w" will show you
the current users & load, "netstat" will show you current network
connections.
   
    Performance tunning is a large issue ... of which I cannot
go into details. The commands above will help you understand
which process is taking a huge chunk of your CPU time, and what
make your network slow.
   
Good luck,
Minh Lai

0
 

Author Comment

by:gaofei
ID: 1582271
I have use 'vmstat' to see the cpu and memory resource,but I
think system resource is enough,I also use 'ps' to see the
processes,but the processes are alse not more than that system
can deal with.
because all users are database users not unix users,so there
not so much users.So I don't know why this server so slow much
more,Please give me another answer.
0
 

Expert Comment

by:jbo
ID: 1582272
I'm just guessing here, but you say the users of the database are not unix users, so I guess you are using ODBC to access the system.  In my own experience I've seen that once you get more or less two thirds of the users to just log in to the database it slows the whole system down.

What happens is that informix sees the connection and accepts is once the user enters the password (in the case of odbc this is done automatically) and then claims a percentage of the unix kernel resources just in case that user decides to do some work.  What I would suggest is to try something: Get all the users to log out (or do this a night)...bounce the machine and see what happens, what the performance looks like.  And then again get ALL (or most) of the users to just log in to the database, then look at the memory and CPU usage (possibly swap file as well).  If I correct you may see a huge decrease in kernel resources.  Should this be the case I suggest going back to your supplier of Informix and see whether there are any patches available to solve this.

Cheers
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
LVL 1

Expert Comment

by:cmarquis
ID: 1582273
I too run an Informix DB among the many apps on Sol2.5.1 for a large company with a huge load with without any performance  problems. The easiest way to find out stats is pull up a performance meter and set it to log and follow it for any trends. The other thing is if the actual system is fine is that it could be the network. Howe many people log into this and how much are they pulling and through what kind of network device (TBase10, etc). The other thing is that it might be as stupid as that the database needs to be set up for performance. Do you use raw partitions, RAID (and if so what kinds?), or a standard UFS? What is the size of the database? It may need some archiving, compression, or purging... And you might want to take a look at swaping for the DB itself. Another thing is to take a look for a variable (which I can't remember off the top of my head) that is something like MAXTCP. You might be running out the maximum number of network transactions at a time the system can handle per cycle. Take a look at Adrian Cockroft's book on Solaris System Performance Tuning or O' Reilly's book on System Performance Tuning.
0
 

Accepted Solution

by:
MalicEInd earned 600 total points
ID: 1582274
From experience running an ODBC database on a Solaris 2.5.1 Sparcstation-5 (64MB RAM), I also had a similar problem prior to installing all recommended patched (up to 1/7/97 at the time the problem arose).  I found informix was subject to the Solaris kernel mutex_enter bug, which caused significant memory leakage (when the initial authentication connection to the database was made)
You can probably test if this is the same situation by hitting the Informix database with rapid authentication requests.

Whilst doing this, watch the system load at frequent intervals (with sar - probably 2 seconds would show a good indication of load).  The processor load should hit 100% reasonably quickly, and stay there even after authentication is complete.  Also monitor swap/memory access, you should find that memory usage jumps rapidly, then appears to drop down quite rapidly.  (Though not all of the memory threads are correctly released).

0
 

Expert Comment

by:MalicEInd
ID: 1582275
its so annoying when people dont grade questions :)

0
 

Expert Comment

by:MalicEInd
ID: 1582276
its so annoying when people dont grade answers :(

0
 

Author Comment

by:gaofei
ID: 1582277
but I really don't understang you all, how can I repair this
mutex_enter bug?

0
 

Author Comment

by:gaofei
ID: 1582278
but I really don't understand you all, how can I repair this
mutex_enter bug?

0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
During and after that shift to cloud, one area that still poses a struggle for many organizations is what to do with their department file shares.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Suggested Courses

649 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