From: John A Meinel <john@arbash-meinel.com>
To: Lane Van Ingen <lvaningen@esncc.com>
To: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Is There A Windows Version of Performance Tuning Documents?
Date: Wed, 03 Aug 2005 10:07:47 -0500
Message-ID: <42F0DDC3.9080707@arbash-meinel.com> (raw)
In-Reply-To: <EKEMKEFLOMKDDLIALABICEEPCAAA.lvaningen@esncc.com>
References: <EKEMKEFLOMKDDLIALABICEEPCAAA.lvaningen@esncc.com>
Lane Van Ingen wrote:
> I have in my possession some performance tuning documents authored by Bruce
> Momjian, Josh Berkus, and others. They give good information on utilities to
> use (like ipcs, sar, vmstat, etc) to evaluate disk, memory, etc. performance
> on Unix-based systems.
>
> Problem is, I have applications running on Windows 2003, and have worked
> mostly on Unix before. Was wondering if anyone knows where there might be a
> Windows performance document that tells what to use / where to look in
> Windows for some of this data. I am thinking that I may not seeing what I
> need
> in perfmon or the Windows task manager.
>
> Want to answer questions like:
> How much memory is being used for disk buffer cache?
> How to I lock shared memory for PostgreSQL (if possible at all)?
> How to determine if SWAP (esp. page-in) activity is hurting me?
> Does Windows use a 'unified buffer cache' or not?
> How do I determine how much space is required to do most of my sorts in
> RAM?
>
I don't know of any specific documentation. I would mention the
TaskManager as the first place I would look (Ctrl+Shift+Esc, or right
click on the task bar).
You can customize the columns that it shows in the process view, so you
can get an idea if something is paging, how much I/O it is using, etc.
I'm sure there are other better tools, but this one is pretty easy to
get to, and shows quite a bit.
John
=:->
Attachments:
signature.asc (application/pgp-signature, 252B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: john@arbash-meinel.com, lvaningen@esncc.com
Subject: Re: Is There A Windows Version of Performance Tuning Documents?
In-Reply-To: <42F0DDC3.9080707@arbash-meinel.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox