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 ...

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, ...

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 ...

Or should perfmon be limited to a Dev/QA server with load tests that simulate production activity?
I'd like to run perfmon for two days (like Sql Server master Brent Ozar suggests) to get an overall ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

I'm looking for a succinct list of common pitfalls and optimizations for tuning a MySQL server as used for mid-size websites.
In general, the type of advice I'm looking for here is information that ...

I am currently running a web app that sees several (~15) users logging in once each day, and then leaving the web app open where it automatically refreshes with new content every 5 minutes. Each user ...

I want to determine if using Apache's .htaccess mod rewrite is a faster way to redirect to a PHP file, compared to redirecting from one PHP file to another, using the header redirect core function of ...

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 ...

I'm running MySQL (5.0 but I don't think it matters for anything after 4.1) and I've seen advice about using the innodb_file_per_table configuration option for InnoDB tables. This is usually done so ...

It is possible move a specific file to the beginning of the disk? I want to move my virtual machine disk files (virtual disk) to the beginning of the disk to improve disk access performance. I believe ...