Message-ID: <42F0DDC3.9080707@arbash-meinel.com>
Date: Wed, 03 Aug 2005 10:07:47 -0500
From: John A Meinel <john@arbash-meinel.com>
User-Agent: Mozilla Thunderbird 1.0.6 (Macintosh/20050716)
MIME-Version: 1.0
To: Lane Van Ingen <lvaningen@esncc.com>,
	Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Is There A Windows Version of Performance Tuning Documents?
References: <EKEMKEFLOMKDDLIALABICEEPCAAA.lvaningen@esncc.com>
In-Reply-To: <EKEMKEFLOMKDDLIALABICEEPCAAA.lvaningen@esncc.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enig6F8271126F508DC29657ACEF"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig6F8271126F508DC29657ACEF
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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
=:->


--------------enig6F8271126F508DC29657ACEF
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (Darwin)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFC8N3DJdeBCYSNAAMRAiVuAJ47FwYtwDCfkfVPiqkUf7YLH56zLwCePHMz
HYvS+fdAtzmqNRkCSjMtx4U=
=ffBB
-----END PGP SIGNATURE-----

--------------enig6F8271126F508DC29657ACEF--