Re: sizing and capacity planning

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 06/03/04 

Date: Thu, 3 Jun 2004 11:25:32 -0400

In Perfmon if you capture the data to a log file. you can then run a report
(also in perfmon) and choose a start and end time and the counters you want
on the report, and it will give you min, max, average..etc..

so you do not have to do this manually 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Dan" <ddonahue@archermalmo.com> wrote in message
news:uiIHu5XSEHA.3812@TK2MSFTNGP11.phx.gbl...
> SqlServer 2000 - I've been reading about ways to plan for how much disk
> space and how many disk drives are needed. One thing I've read about is
> figuring out how many physical I/Os are performed in a certain amount of
> time so that I can get a calculation for I/Os per second. Then using that
> figure, I look at how many I/Os per second a disk is rated for to figure
out
> how many disks are needed. And then calculate how much raw space is needed
> based on what we're using now and what our growth is. My question is how
can
> I get a figure for how many physical I/Os are performed in a certain
length
> of time?
>
> If I use system monitor is there a way to get a figure for a six hour time
> span. Or do I send the data to a log file and then am I able to add up the
> I/Os?
>
> Thanks,
>
> Dan
>
>

Relevant Pages

  • Re: Volume shadowing stalls...
    ... The disk giving the issue had a pagefile on it... ... Shadowing was designed to throttle back merge I/Os ...
    (comp.os.vms)
  • Re: 306GB drives!
    ... If possible, use MSCP controllers, which have ... Volume Shadowing Assists, including the Write History Logging which ... Avoid disk I/Os. ...
    (comp.os.vms)
  • Disk I/O and memory/swapping
    ... I'm running an AIX 5.1 system with TSM. ... The memory always seems to be ... I/Os to disk crawl. ... If I cancel the "dd" then I notice that the I/Os ...
    (comp.unix.aix)