capacity planning

Hi all
how can we know how much IO/sec server is using..
second wot is allocated cache memory or how can we configure cache memory of sqlserver..or cache area.
i've to do capacity planning of sqlserver..can anyone help me out in this regard.
Regards"sanjay" <anonymous@.discussions.microsoft.com> wrote in message
news:02D6A931-8D1F-4A59-B0FD-8E5C1D0C540A@.microsoft.com...
> Hi all
> how can we know how much IO/sec server is using..
perfmon will give you IO/Sec
> second wot is allocated cache memory or how can we configure cache memory
of sqlserver..or cache area.
Perfmon again has counters for the memory used by SQL server. If you mean
buffer cache then pretty much the only thing you can do configuration wise
is limit the size to a fixed range - the default is to keep consuming memory
until all RAM is utilized by SQL Server.
> i've to do capacity planning of sqlserver..can anyone help me out in this
regard.
> Regards
>
Niall Litchfield
Oracle DBA
Audit Commission UK