Performance tuning is the process of modifying a system to improve its efficiency. This is also known as optimizing.

learn more… | top users | synonyms

0
votes
1answer
46 views

Why did my newly added index show up as a 'statistic'?

We are attempting to tune our SQL Server 2005 database as we frankly have no indexing on our tables and our CPU usage is starting to max out at 100%. We have ran SQL Server profiler for a 3 hour ...
0
votes
2answers
3k views

How to see actual size of tcp send and receive buffers?

we are on a debian system and are trying to tune the tcp/ip stack to our needs. We all know that you can set the maximum tcp buffer size with some kernel parameters like this: net.ipv4.tcp_wmem = ...
0
votes
2answers
790 views

Webalizer causing high CPU load

We use webalizer to generate reports on our Apache access logs - it is useful in conjunction with Google Analytics. The problem is that webalizer uses ALOT of CPU when running. If I run top I can see ...
0
votes
1answer
1k views

How to use oprofile to find the bottle-neck of our web server?

Updated: ================================================================ I finally found the reason with oprofile. It was because the routing cache of Symfony. We have lots of pages with different ...
0
votes
3answers
3k views

Oracle tuning optimizer index cost adj and optimizer index caching

What is the correct way to set the optimizer index cost adj parameter for Oracle. As a developer I have observed huge performance improvements as this parameter is lowered. Common queries are ...
0
votes
3answers
957 views

What program can I use to benchmark network traffic? [duplicate]

Possible Duplicate: How to test real network throughput between two points? Given two computers connected by some network interface, is there a standard tool used by an academics publishing ...
0
votes
0answers
29 views

Lots of packets pruned from receive queue because of socket buffer overrun - reason to worry?

I know this question has been asked before, but maybe not in this particular context: I have a setup with a couple of MS2008R2 HyperVisor servers running a number of Ubuntu guests. Our webproxy runs ...
0
votes
0answers
27 views

famd/gamin timeout issue with courier-imap

I'm running a mail server for about 200 users with courier-imap on Debian 7. This server is running a linux kernel 2.6.38 inside a Xen guest having 2 cpu cores and 2 GB RAM. The server accept ...
0
votes
0answers
11 views

configuring server for single process using all resources [duplicate]

i'm attempting to configure a server that will be used for data scraping using phantomjs (if you're not familiar it's a headless browser - it's webkit, controllable via javascript, without a gui ...
0
votes
1answer
34 views

how to disable all caches types in mysql server in order to do performance testing for my queries

I'm using Mysql Server 5.6.15 and i have a huge database with many complex queries. it seems that when I run the query the first time it takes X amount of time. when I execute it again it takes ...
0
votes
0answers
69 views

What's the bottle neck of server hit 100K request?

The following are two graph of my digital ocean vps instance handle load test request. 10K/s, The only different is the request file size, first is 10K, the second is 20K. Can any one point out the ...
0
votes
1answer
53 views

PHP Settings [pm.max_children, pm.start_servers, pm.min_spare_servers and pm.max_spare_servers]

In the midst of transferring a website from a GoDaddy shared server to an EC2 instance. Handling the traffic, which during peak times on a typical day is around 300 active visitors, has been ...
0
votes
0answers
59 views

tuning apache for low ram low traffic server

I have a low end VPS server with 512megs of ram to host downloads of files (~10-25megs each). what is a good configuration for the following parameters in apache. I expect no more than 10 human users ...
0
votes
0answers
40 views

OpenSSL performance oddity

I've seen something odd regarding OpenSSL performance. This is the output of 'openssl speed aes-128-cbc' on a physical HP Bl460c Gen8 with dual E5-2680's running RHEL/OEL 6.4x64 and OpenSSL ...
0
votes
0answers
29 views

Ubuntu backup script kills performance

I run a nightly backup, which takes about 1 hour. During that the performance is bad as hell. It looks pretty much like this: # DB dump ionice -c 3 nice -n 20 mysqldump --skip-lock-tables --user=foo ...
0
votes
0answers
22 views

SQL Server : Improve SIMPLE SELECT to retun 2 LAC Rows faster?

We have a stored procedure in which we are creating a temp table which has more than 200,000 rows with 30 columns (2 of DATETIME, 4 of INT, 5 of [numeric](20, 3) and rest of VARCHAR(500) data types. ...
0
votes
1answer
87 views

performance monitor in iis 7 to monitor which website is using most resources (asp.net)

I am using Windows Server 2008 R2 and IIS 7.5, and am hosting multiple websites on the same webserver. Is it possible to use Performance Monitor to know on average which website is using the most ...
0
votes
2answers
139 views

Centos 6.4 Installed in System X3750 M4 IBM Server [duplicate]

We have installed Centos 6.4 in System X3750 M4 IBM Server. But the server is not showing the performance of at-least a normal Desktop Configuration. We haven't done any performance tuning in the ...
0
votes
0answers
153 views

How to avoid Memory “Hard Fault/sec”

i've a problem on my windows 2008 server x64, and i cannot understand how can i solve it. i'm looking to Resource Monitor and see about 100 to 200 hard faults/sec. and generally the machine is slow. ...
0
votes
0answers
99 views

Mysql Server Performance Hit from Triggers

I have 50 databases on a reasonably spec'd Debian MySQL Server v5.1.63 The size of these database vary from about 3MB -> 7GB each. Each database has a history database and most( but not all) tables ...
0
votes
1answer
95 views

epoll timeout configuration in lighttpd

Is there a configuration option to tune epoll timeout in lighttpd? I'm developing an embedded Linux (2.6) device, with lighttpd 1.4.30. And I'm observing the following issue: even when the system is ...
0
votes
1answer
169 views

Why am I getting a Sudden Drop in throughput and sluggishness with no CPU increase

Occasionally, during random parts of the day, I get a 10 minute period of extreme sluggishness where my requests are taking 50-1000 times longer then they normally do. Note: I am on Apache/2.2.16 ...
0
votes
0answers
174 views

RAID10 (4x SSD) system is super slow for 'dd' and 'find' commands

I have configured two servers each with 32 GByte RAM, 2x Xeon 2.4 GHz, 4x 480 GByte Intel SSD on a LSI MegaRAID SAS 9261-8i controller. They should be identical, however one of them has a very poor ...
0
votes
0answers
368 views

Ubuntu 12.04 64bit - What would cause high System CPU %sys during high MySQL loads?

128GB RAM, 32cores Xeon RAID 10 SSD. Mysql version is the latest 5.5 for Ubuntu 12.04 . We have a lot of queries - about 1800+ per second. During high MySQL load - 2700+% load on a 32 CPU system - ...
0
votes
0answers
37 views

Job run-time variations on dual socket computer

I'm running scientific software (WRF-NMM, atmosphere simulation, weather prediction). On all computers I used it, job running times of run cycles were consistent. All those machines were one socket, ...
0
votes
1answer
84 views

MySQL Threads or what is this

http://i.stack.imgur.com/dZFqI.png How can I reduce that number? I have a quad core machine. Do I need to edit thread_pool_size and by reducing them do I get better performance? Should a lot of ...
0
votes
4answers
660 views

Exchange 2010 SP2 OWA performance

How do I increase performance in OWA 2010 SP2? I am running CAS on a seperate installation, which has 8GB RAM and 4 CPU cores - running virtualized in a vmware environment. However, the load times ...
0
votes
0answers
39 views

issues with IEEE authentication

We have an application managing other systems in the network solving thier issues.After some days it became un-responsive (applications became unresponsive and windows freezes) I have confirmed ...
0
votes
1answer
231 views

Windows 2003 IIS webserver (testserver) is slow

I have a test environment for my Asp.Net 4.0 web applications. It runs on a Dedicated Windows 2003 Webserver (IIS 6) But it's slow! The machine never has 100% cpu and the same for memory. When I run ...
0
votes
1answer
509 views

Improving TCP performance over a network with small packet loss

I’m trying to improve my TCP throughput over a “high delay network”, with some packet drops, between Linux machines. I set tcp_mem, tcp_wmem and tcp_rmem to “8192 20530752 20530752”. I set rmem_max, ...
0
votes
0answers
487 views

Cannot enlarge MySQL Innodb_Buffer_Size, causes MySQL to crash

I currently have innodb_buffer_size set to 2GB - yet I have well over 5GB of innodb databases, and another 4 gigs of free ram on the server (Centos 5). I tried to increase the value to 3 gig, but ...
0
votes
1answer
236 views

ionice or chrt for Bonnie benchmark

I am running Bonnie benchmark on an embedded device and I am getting variable results for every run. I am contemplating using ionice and / or chrt to get around it. Can you suggest which option is ...
0
votes
2answers
100 views

what to check for limitations if a linux machine maxes out at a certain connection/s

I have a linux machine with a dummy HTTP server on it. It accepts a certain number of connections/second. Neither the CPU (it is a multicore) nor the memory nor IO are exhausted. What else can be ...
0
votes
0answers
500 views

Nginx Slower than Apache?

I've just setup 2x identical Rackspace Cloud instances and am doing some comparisons and benchmarks to compare Apache and Nginx. I'm testing with a 3.4k png file and initially 512MB server instances ...
0
votes
0answers
124 views

Where to start fixing an IO Bottle neck in SQL Server?

I recently came across an interesting article that went over using IO statistics to identify the causes of performance issues. After examining my statistics i came to the determination that i had a ...
0
votes
1answer
268 views

IIS 7.0 - responses throttled to 500ms blocks?

Scenario: ASP.NET MVC wep app sitting on my local machine (Vista Ultimate, IIS 7.0), nothing going on except one user (me) logged in and viewing an index page. The page includes 9 dynamic images drawn ...
0
votes
1answer
144 views

Need help tuning Mysql and linux server

We have multi-user application (like MailChimp,Constant Contact) . Each of our customers has it's own contact's list (from 5 to 100.000 contacts). Everything is stored in one BIG database (currently ...
0
votes
1answer
490 views

File Control Bytes / Sec in Server 2003 is sometimes VERY high - is this a problem?

We are trying to track down performance problems on our server, and when running SPA or the performance monitor the counter for "File Control Bytes / Sec" sometimes skyrockets, typically about once ...
0
votes
1answer
888 views

apache and ajp performance

I have an apache sitting in front of two tomcat app servers(one on the same physical server, the other on a different one) that does time consuming work(0.5 sec to 10sec per request). The apache http ...
-1
votes
1answer
61 views

IIS - Overuse of memory is normal? [closed]

I have two servers running Asp.net applications. Sometimes applications are too slow and memory usage seems exaggerated. Specifications: SERVER #1 OS: Microsoft Windows 2003 R2 Memory: 4GB ...
-1
votes
1answer
208 views

Linux script to check settings and recommend tuning changes? [closed]

I'm searching for a script to run on our linux server and recommend various tuning changes we might consider making, as well as their suggested values for consideration. Any ideas if something like ...
-1
votes
1answer
114 views

Server optimization for long running script [duplicate]

I have a system running on a remote VPS whose main feature is a long running script (it could run for about 10 hours, depending on the user input). The following are some of its features: Database ...
-1
votes
1answer
435 views

Tuning JavaVM on AWS/EC2

there's some specific tuning JVM configuration for AmazonWS/EC2 building blocks (small, large...)? Somebody have suggestions for tuning JVM running on these machine profiles? Regards, And Past
-1
votes
0answers
67 views

How to improve server performace? [closed]

Scenario After an integration of our product with a site that have a "decent" number of request, development team of that site ask me to prove that our server can handle traffic generated from that ...
-1
votes
1answer
109 views

MySQL settings for MAXIMUM performance / can be specific to particular DB or user? [closed]

We have a dedicated server, a very powerful one, and I don't believe we are getting the most out of MySQL. Even when running ultra-heavy processes that take a very long time to complete, I'm showing ...
-1
votes
1answer
418 views

MySQL runs at >=100% CPU, heavy disk I/O?

Recently my Debian Linux server has been experiencing slow web server response times. I've investigated and it seems that MySQL is the culprit, yet there are no slow queries indicated by the slow ...
-2
votes
1answer
181 views

Which will give more free RAM to linux? [closed]

Trying to avoid some issues so I've been trying to learn vm. in kernel tuning but still a little confused even after googling. The lower background_ratio is the sooner the flushes? the lower ...
-2
votes
1answer
242 views

HP DL360p Gen8 for low latency trading - what to upgrade? [closed]

I'm using HP DL360p Gen8 for low latency trading (but not ultra-low-latency!). It means that i'm working in frame about "10+ microseconds" and i don't care about "1-5 microsecond" or nanoseconds. I ...
-2
votes
1answer
47 views

Ideal number of server, setup and management [closed]

Have read how large scale sites use different servers for different purpose. Here's what I have in mind: Main app - 1 server Database - 1 server Static files - Cloud hosting (e.g. AWS) Backup - 1 ...
-3
votes
2answers
723 views

What are the optimal tuning values for RHEL 5.3 Xen kernel on a Dell 2950? [closed]

How to do Linux Tuning and Performance? any one has done for xen kernel ?