Tagged Questions

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
4answers
1k views

How to check for bottlenecks in Windows Server 2008 R2

I recently switched out a 10 year old server for a brand new server in a small office and upgraded from Windows Server 2000 to Windows Server 2008 R2. After the switch was complete and some ...
0
votes
3answers
1k views

How to speed up apache

We have a server with 8Cores, 16GB of RAM and RAID 0 SAS 10K drives. Our goal is to use this to serve a fairly simple php application quickly. We have tested all other components and we think we have ...
1
vote
2answers
169 views

SQL performance, how to exactly measure bottlenecks

Yesterday me (programmer) and one of my coworkers from our Hosting department started series of tests to address performance issues with our websites. We are running a server with Windows Server 2008 ...
0
votes
1answer
734 views

IIS6 - Classic ASP - “out of memory”/“out of string space”

We have a classic ASP application that's under significantly more load than usual. We are from time to time been getting "out of memory" and "out of string space" in the httperr. We do not usually ...
0
votes
2answers
829 views

MySQL Memory usage

Our MySQL server seems to be using a lot of memory. I've tried looking for slow queries and queries with no index and have halved the peak CPU usage and Apache memory usage but the MySQL memory stays ...
0
votes
4answers
429 views

Increase application performance on Amazon AWS

I've got a client with an MVC v1 (.NET) application running on a micro instance. On this instance, I've got .NET, IIS 7.5, and MS SQL Server 2008 running to handle the application. The client has ...
2
votes
2answers
143 views

Does deleting unused files such as images, javascript, xml, html, asp etc make your Windows Server faster?

I have an IIS7 Windows 2003 Dedicated server. I just wanted to know if I delete old files such as XML, HTML, ASP, PHP, images, CSS, JavaScript.. etc.. files that are no longer used.. Does this ...
7
votes
1answer
5k views

Interpreting ethtool Coalesce output

Other than tx and rx being the transmit and recieve, can anyone explain what the fields mean in ethtool -c's (Coalescing output) and what effect they have on how coalescing works? Coalesce parameters ...
3
votes
2answers
1k views

How to adjust MySQL performance

I'm facing a real problem with MySQL instance for a service online. We use hibernate and c3p0 pool with these settings: c3p0.max_size=200 c3p0.min_size=5 c3p0.timeout=60000 c3p0.max_statements=20 ...
3
votes
2answers
535 views

PostgreSQL tuning recommendation for large server and dataset

I'm working with a PostgreSQL (8.1) server on a dedicated machine with 64 GB of RAM and a fast RAID disk. The data set itself is pretty huge -- we have several tables around 200 GB, more in the 50-100 ...
1
vote
2answers
139 views

How to connect an Oracle server between two countries and maintain high speeds for read & write

Our company has two branches, one in Malaysia and the other one in India. The problems occur when we try to share one of our Oracle environments to our branch in India; the connection is very slow, ...
1
vote
2answers
450 views

Troubling AB benchmarking result?

I'm a real noob when it comes to sys admin. I'm running an app on an EC2 MicroInstance. Before I launch publicly, I want to make sure that I hit a minimum level of performance. I'm trying out some ...
1
vote
2answers
647 views

Establish a performance baseline for terminal server windows machines

I need to establish a performace basline for our Terminal Server machines. i plan to use perfmon , and will have a SCOM server on the site very soon. The terminals are used as a desktop environment ...
0
votes
4answers
328 views

Trying to scale my dedicated server for high traffic

I have a quad core xeon, 8GB ram, and only 2 x 1TB SATA drives right now. I am trying to figure out how to scale my application to handle as much load and traffic per day as possible. I have an ...
2
votes
1answer
1k views

InnoDB options crashing mysql start AND mysql tuning

I have an innodb on a Ubuntu 10.10 server running on an ESXi platform. I have dedicated 8 CPUs, 32 Gigs of ram, and files stored in a Raid 5 HP SAN of SAS 10k rpm disks. I'm expecting FAST queries! ...
0
votes
1answer
712 views

MySQL hosting: What are the recommended specs and w

I have two specific cases of MySQL hosting. 1) I have a case where I have 2000 plus concurrent users to a single MySQL Database. They are not simple web users, but actual business users who need to ...
0
votes
1answer
253 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 ...
2
votes
5answers
377 views

Figuring out what's causing a server to slow down

I have a potential client that has a php site that performs fine most of the time. However, every week or so, it will experience lag (slow page loading). I am sure there are a myriad of things that ...
0
votes
2answers
102 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
5answers
2k views

Very low performance of raid6

I noticed that writing to raid-6 is very low, but when I make tests with hdparm the speed is reasonable: dd if=/dev/zero of=/store/01/test.tmp bs=1M count=10000 Gives: 50Mb/s or even less. The ...
2
votes
1answer
277 views

Do IIS App Pools using Network Service account share memory?

We're trying to tune our IIS farm, and I'm trying to get my head around how Windows allocates resources in our current setup. We have a pretty standard layout. We host 30+ ASP/ASP.NET sites on our ...
2
votes
5answers
407 views

Does Overclocking Anything Shorten It's Life? [closed]

From a business standpoint... If intel could take a 3.0 GHz CPU, and overclock it to 4.0 GHz - whilst still covering their warranty they would do so. It's absolutely free and makes the chip perceived ...
6
votes
2answers
5k views

Best sysctl.conf configuration for high load - extremely busy content streaming server

What is the best sysctl.conf configuration for a high load, extremely busy content streaming server ? The server fetches the content from remote servers like amazon, s3, etc. then uses php to ...
1
vote
1answer
571 views

COM+/Desktop Heap errors in IIS affecting sites at random?

We have a Win2K3 server that is hosting 30+ sites. Each site is configured to have its own unique application pool -- so that we can manually recycle specific sites if needed and not kill sessions ...
1
vote
3answers
339 views

Config MySQL to maximum speed and memory

I have a server, 8 cores, 12 GB RAM. This server is only used to run MySQL. So, help me config /etc/my.cnf to maximum speed, memory for MySQL.
1
vote
0answers
438 views

server benchmarking with apache benchmark

We are testing one of our production server with ab and what we found is apr_socket_recv: Connection timed out (110) Total of 176 requests completed after some time above output.That means the ...
1
vote
2answers
455 views

Solaris: Increase TCP's Initial Congestion Window to 10 segments (tcp slow-start)

How can the Initial Congestion Window be increased to 10? It seems it can be done with TCP_INIT_CWND, but I don't know how to do that.
1
vote
3answers
1k views

Filesystem/Options for intensive random I/O

I'm planning to (privately) deploy a server that will be hammered with random I/Os in files ranging from 100MB to 50GB. The requests will range from 128 KB to 4MB. The profile will be 50:50 concerning ...
0
votes
1answer
3k views

What is bottleneck of my Apache server?

$netstat -anp | grep :80 | grep TIME_WAIT | wc -l 840 $netstat -anp |grep :80 | grep ESTABLISHED | wc -l 50 memory usage : 850MB / 1000MB apache2.conf contains.. <IfModule ...
3
votes
3answers
1k views

Linux's best filesystem to work with 10000's of files without overloading the system I/O

It is known that certain AMD64 Linuxes are subject of being unresponsive under heavy disk I/O (see Gentoo forums: AMD64 system slow/unresponsive during disk access (Part 2)), unfortunately have such ...
4
votes
7answers
3k views

Linux tool/command to check file system performance

What is the simplest way to check read/write performance to a specific location (e.g. a mounted iSCSI device). I suspect I can't use hdparm because that's lower level. Am I right?
4
votes
1answer
1k views

PostgreSQL - count() performance and how to tweak it?

I've done some reading in google and the only thing I did was get myself confused. Some of the people say that count() is slower with many records, others say you can cache the number or even use ...
1
vote
2answers
794 views

How to tune down the Hyperic built-in postgresql database for a small setup

We are testing out Hyperic 4.5.1 in a quite small environment for now. Currently there are just 1-5 agents and there probably won't be any more than 10-15. When I run ps ax there are 20(!) postgres ...
0
votes
3answers
572 views

Extreme fine tuning MySQL performance wise on a Linux server

I would like to know all of the key points where MySQL can be fine tuned performance wise on a Linux server through my.cnf or through other methods, libraries and tools. Tips and tricks and shady ...
2
votes
2answers
314 views

dedicated apache httpd server configuration and performance tuning

I have the following dedicated box that I only install apache httpd server on, what parameters in httpd.conf should I tune to achieve max performance? cat /proc/cpuinfo shows 8 processors(only ...
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 ...
8
votes
5answers
11k views

Performance Tuning a High-Load Apache Server

I am looking to understand some server performance problems I am seeing with a (for us) heavily loaded web server. The environment is as follows: Debian Lenny (all stable packages + patched to ...
6
votes
4answers
6k views

Windows 7 network performance tuning for LAN

I want to tune Windows 7 TCP stack for speed in a LAN environment. Bit of background info: I've got a Citrix XenServer set up with Windows 2008R2, Windows 7 and Debian Lenny with Citrix kernel, ...
0
votes
2answers
179 views

How do I calculate the amount of tuning needed for my server?

I have a server which is running a few discrete Python, Java application which most of the time imports data into a PostGreSQL database. I would like to know from people out there who have experience ...
1
vote
3answers
659 views

How to measure req/sec by analyzing apache logs

I want to measure the justify stress-test result on production env. How to measure req/sec by analyzing apache logs? apache2.2 LogFormat "%v:%p %h %l %u %t \"%r\" %>s %O \"%{Referer}i\" ...
3
votes
1answer
694 views

How to remove the pause during JBoss 5.1.0 GA boot between ProfileServiceBootstrap and AnnotationCreator?

I've managed to strip down my JBoss profile enough that it boots in 1.5 minutes. I started with the web profile and started pulling out stuff I didn't need. The bulk of my boot time can be seen here: ...
1
vote
1answer
737 views

performance wise htaccess

hese's the my htaccess template, i wonder if anything could be added to increase website performance.. # Defaults AddDefaultCharset UTF-8 DefaultLanguage en-US ServerSignature Off FileETag None ...
8
votes
2answers
768 views

Linux RAID-0 performance doesn't scale up over 1 GB/s

I have trouble getting the max throughput out of my setup. The hardware is as follow : dual Quad-Core AMD Opteron(tm) Processor 2376 16 GB DDR2 ECC RAM dual Adaptec 52245 RAID controllers 48 1 TB ...
1
vote
2answers
5k views

switching to worker mpm for apache 2 on ubuntu

How to switch from prefork mpm to worker mpm on ubuntu server? how to roll back if there is any problem? root@myserver:~# apache2ctl -l Compiled in modules: core.c mod_log_config.c mod_logio.c ...
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 ...
1
vote
2answers
976 views

Good VPS In London? [duplicate]

Possible Duplicate: Who is your favorite VPS Provider? I'm looking to rent a Windows VPS in (or near) London, England. I want to be able to do performance testing of our North American web ...
1
vote
5answers
4k views

VPS hosting is very slow. What's the bottleneck?

I've setup a new VPS hosting, to run a Drupal website but it is extremely slow. It is Ubuntu 10, Apache, php5.2 I've enabled Multi-Processing Module (MPM) module and configured it as follows: ...
1
vote
2answers
649 views

Diagnosing poor performance on IIS / ASP.NET / MSSQL app

I'm trying to diagnose the cause of poor performance from a third-party web application we've deployed; the environment is: ASP.NET on IIS, Windows 2003 Server SQL Server 2008 on a separate Windows ...
5
votes
4answers
10k views

Find out which task is generating a lot of context switches on linux

According to vmstat, my Linux server (2xCore2 Duo 2.5 GHz) is constantly doing around 20k context switches per second. # vmstat 3 procs -----------memory---------- ---swap-- -----io---- -system-- ...
3
votes
1answer
306 views

What are some current and relevant benchmark tools for Linux?

I'm specifically interested in benchmarks that approximate or target real in the wild usage scenarios. My main areas of focus are latency, network performance (incoming data over sockets). ...