I ran performance monitoring on one of my server that is
performing slow in order to determine if there is a memory
or hardware bottleneck and came up with the following
statistics. Please help diagnose this and let me know if
we need to increase memory or configure something in sql
server. This is an average of statistics collected
during peak periods 19 times. Thanks for your help. I
already suggested that ram needs to be added to the
server, but I need more assured technical justification
as I am new to this. Thx.
PROCESSOR TIME
max 36.42%
Average 9.53%
System
Processor Queue Length (max) 1
MEMORY
Pages/sec 121
Available Mbytes 156
Page Faults/sec 735
total physical memory 1986302
total sql server memory - mb 1589485
Processes page fault - Sql Server 73
Maximum workspace memory 1081725
DISK
Disk Reads per second 244
Disk Writes per second 99
Average Disk Queue length 4
SQL SERVER GENERAL STATISTICS
# connections 15
SQL Server Buffer Manager cache hit ratio 94
Hardware Info
Hard drive :
C' drive total hd space = 33.9G space
available = 20.2 G
D' drive total hd space = 273G space
available = 272G
E' drive total hd space = 273G space
available = 172 G
F' drive total hd space = 273G space
available = 127 G
F' drive total hd space = 819G space
available = 431 G
CPU = 2.80 GHz
RAM = 2.09G
Operating System = Windows 2000 SP4
Sql Server 2000 sp3aUnfortunatly its a bit hard to determine whether your
server is running slow or not, because there is no point
of reference. Probably the best way would be to run it
once on a weekly basis and get the average.
You may want to monitor network trafic, read writes and
memory (can anyone think of more ?), personally though
7/10 its the network thats slow and not SQL.
Be that as it may there are some options that may speed
you SQL Server up, if you feel its underperforming.
Firstly have a look at the DBCC SHOWCONTIG command. This
will show how dragmented your indexes are, if they are
defragmented then run DBCC DBREINDEX.
Secondly set up a profile trace for performance
enhancement. Allow it to run for at least a couple of days
then run the Index Tuning wizard. This will put in some
indexes for you based upon the queries your users have
been making.
Finally mark you store procedures for re-compulation in
case the execution plan is out of date.
If you would like any further help my email in reverse
order is moc.liamtoh@.em_yrewolf_elttil
J
>--Original Message--
>I ran performance monitoring on one of my server that is
>performing slow in order to determine if there is a
memory
>or hardware bottleneck and came up with the following
>statistics. Please help diagnose this and let me know if
>we need to increase memory or configure something in sql
>server. This is an average of statistics collected
>during peak periods 19 times. Thanks for your help. I
>already suggested that ram needs to be added to the
>server, but I need more assured technical justification
>as I am new to this. Thx.
>PROCESSOR TIME
>max 36.42%
>Average 9.53%
>System
>Processor Queue Length (max) 1
>MEMORY
>Pages/sec 121
>Available Mbytes 156
>Page Faults/sec 735
>total physical memory 1986302
>total sql server memory - mb 1589485
>Processes page fault - Sql Server 73
>Maximum workspace memory 1081725
>DISK
>Disk Reads per second 244
>Disk Writes per second 99
>Average Disk Queue length 4
>SQL SERVER GENERAL STATISTICS
># connections 15
>SQL Server Buffer Manager cache hit ratio 94
>Hardware Info
>Hard drive :
>C' drive total hd space = 33.9G space
>available = 20.2 G
>D' drive total hd space = 273G space
>available = 272G
>E' drive total hd space = 273G space
>available = 172 G
>F' drive total hd space = 273G space
>available = 127 G
>F' drive total hd space = 819G space
>available = 431 G
>CPU = 2.80 GHz
>RAM = 2.09G
>Operating System = Windows 2000 SP4
>Sql Server 2000 sp3a
>.
>|||Julie,
Thank you so much for response you gave to my performance
problems.
The statistics I sent in the Microsoft newsgroup is an
average of every thing I log for 9 days now. Would you
rather I send you what I collected today? The network may
notbe the issue because I have an identical server with
more memory that returns stuff quicker. I will try the
trace profiler also. I reindex the indexes weekly - but I
will still run dbcc showcontig. Finally, how do you
recompile stored procedures? Thank you.
Jasmine
>--Original Message--
>Unfortunatly its a bit hard to determine whether your
>server is running slow or not, because there is no point
>of reference. Probably the best way would be to run it
>once on a weekly basis and get the average.
>You may want to monitor network trafic, read writes and
>memory (can anyone think of more ?), personally though
>7/10 its the network thats slow and not SQL.
>Be that as it may there are some options that may speed
>you SQL Server up, if you feel its underperforming.
>Firstly have a look at the DBCC SHOWCONTIG command. This
>will show how dragmented your indexes are, if they are
>defragmented then run DBCC DBREINDEX.
>Secondly set up a profile trace for performance
>enhancement. Allow it to run for at least a couple of
days
>then run the Index Tuning wizard. This will put in some
>indexes for you based upon the queries your users have
>been making.
>Finally mark you store procedures for re-compulation in
>case the execution plan is out of date.
>If you would like any further help my email in reverse
>order is moc.liamtoh@.em_yrewolf_elttil
>J
>>--Original Message--
>>I ran performance monitoring on one of my server that is
>>performing slow in order to determine if there is a
>memory
>>or hardware bottleneck and came up with the following
>>statistics. Please help diagnose this and let me know
if
>>we need to increase memory or configure something in sql
>>server. This is an average of statistics collected
>>during peak periods 19 times. Thanks for your help. I
>>already suggested that ram needs to be added to the
>>server, but I need more assured technical justification
>>as I am new to this. Thx.
>>PROCESSOR TIME
>>max 36.42%
>>Average 9.53%
>>System
>>Processor Queue Length (max) 1
>>MEMORY
>>Pages/sec 121
>>Available Mbytes 156
>>Page Faults/sec 735
>>total physical memory 1986302
>>total sql server memory - mb 1589485
>>Processes page fault - Sql Server 73
>>Maximum workspace memory 1081725
>>DISK
>>Disk Reads per second 244
>>Disk Writes per second 99
>>Average Disk Queue length 4
>>SQL SERVER GENERAL STATISTICS
>># connections 15
>>SQL Server Buffer Manager cache hit ratio 94
>>Hardware Info
>>Hard drive :
>>C' drive total hd space = 33.9G space
>>available = 20.2 G
>>D' drive total hd space = 273G space
>>available = 272G
>>E' drive total hd space = 273G space
>>available = 172 G
>>F' drive total hd space = 273G space
>>available = 127 G
>>F' drive total hd space = 819G space
>>available = 431 G
>>CPU = 2.80 GHz
>>RAM = 2.09G
>>Operating System = Windows 2000 SP4
>>Sql Server 2000 sp3a
>>.
>.
>|||also check out the kb below for a more general overview of how to
troubleshoot performance issues
http://support.microsoft.com/default.aspx?scid=kb;en-us;298475
Andy.
"Jasmine Gwendle" <anonymous@.discussions.microsoft.com> wrote in message
news:173c901c448ab$17949f00$a001280a@.phx.gbl...
> I ran performance monitoring on one of my server that is
> performing slow in order to determine if there is a memory
> or hardware bottleneck and came up with the following
> statistics. Please help diagnose this and let me know if
> we need to increase memory or configure something in sql
> server. This is an average of statistics collected
> during peak periods 19 times. Thanks for your help. I
> already suggested that ram needs to be added to the
> server, but I need more assured technical justification
> as I am new to this. Thx.
> PROCESSOR TIME
> max 36.42%
> Average 9.53%
> System
> Processor Queue Length (max) 1
> MEMORY
> Pages/sec 121
> Available Mbytes 156
> Page Faults/sec 735
> total physical memory 1986302
> total sql server memory - mb 1589485
> Processes page fault - Sql Server 73
> Maximum workspace memory 1081725
> DISK
> Disk Reads per second 244
> Disk Writes per second 99
> Average Disk Queue length 4
> SQL SERVER GENERAL STATISTICS
> # connections 15
> SQL Server Buffer Manager cache hit ratio 94
> Hardware Info
> Hard drive :
> C' drive total hd space = 33.9G space
> available = 20.2 G
> D' drive total hd space = 273G space
> available = 272G
> E' drive total hd space = 273G space
> available = 172 G
> F' drive total hd space = 273G space
> available = 127 G
> F' drive total hd space = 819G space
> available = 431 G
> CPU = 2.80 GHz
> RAM = 2.09G
> Operating System = Windows 2000 SP4
> Sql Server 2000 sp3a
>|||Hi Jasmine
Firstly the store procedures
EXEC sp_recompile <store procedure name>
Personally I create a cursor with
select name from sysobjects where xtype = 'P' and status
> 0
That gets out all the sp for your database, then I add
the EXEC sp_recompile
As for the performance could you give me somthing like
Mondays 9am to 5pm Average, Tuesdays average 9am to 5pm
ect.
You can also configure the performance monitor to sent
you pop-ups when for instance network is at 100%.
Other things.
1 Is there anything else running on your server?
2 Is your memory set up the same
3 Do you have autoclose turned off your dbs
4 Is the problem saving, loading or both
J
>--Original Message--
>Julie,
>Thank you so much for response you gave to my
performance
>problems.
>The statistics I sent in the Microsoft newsgroup is an
>average of every thing I log for 9 days now. Would you
>rather I send you what I collected today? The network
may
>notbe the issue because I have an identical server with
>more memory that returns stuff quicker. I will try the
>trace profiler also. I reindex the indexes weekly - but
I
>will still run dbcc showcontig. Finally, how do you
>recompile stored procedures? Thank you.
>Jasmine
>
>>--Original Message--
>>Unfortunatly its a bit hard to determine whether your
>>server is running slow or not, because there is no
point
>>of reference. Probably the best way would be to run it
>>once on a weekly basis and get the average.
>>You may want to monitor network trafic, read writes and
>>memory (can anyone think of more ?), personally though
>>7/10 its the network thats slow and not SQL.
>>Be that as it may there are some options that may speed
>>you SQL Server up, if you feel its underperforming.
>>Firstly have a look at the DBCC SHOWCONTIG command.
This
>>will show how dragmented your indexes are, if they are
>>defragmented then run DBCC DBREINDEX.
>>Secondly set up a profile trace for performance
>>enhancement. Allow it to run for at least a couple of
>days
>>then run the Index Tuning wizard. This will put in some
>>indexes for you based upon the queries your users have
>>been making.
>>Finally mark you store procedures for re-compulation in
>>case the execution plan is out of date.
>>If you would like any further help my email in reverse
>>order is moc.liamtoh@.em_yrewolf_elttil
>>J
>>--Original Message--
>>I ran performance monitoring on one of my server that
is
>>performing slow in order to determine if there is a
>>memory
>>or hardware bottleneck and came up with the following
>>statistics. Please help diagnose this and let me know
>if
>>we need to increase memory or configure something in
sql
>>server. This is an average of statistics collected
>>during peak periods 19 times. Thanks for your help.
I
>>already suggested that ram needs to be added to the
>>server, but I need more assured technical justification
>>as I am new to this. Thx.
>>PROCESSOR TIME
>>max 36.42%
>>Average 9.53%
>>System
>>Processor Queue Length (max) 1
>>MEMORY
>>Pages/sec 121
>>Available Mbytes 156
>>Page Faults/sec 735
>>total physical memory 1986302
>>total sql server memory - mb 1589485
>>Processes page fault - Sql Server 73
>>Maximum workspace memory 1081725
>>DISK
>>Disk Reads per second 244
>>Disk Writes per second 99
>>Average Disk Queue length 4
>>SQL SERVER GENERAL STATISTICS
>># connections 15
>>SQL Server Buffer Manager cache hit ratio 94
>>Hardware Info
>>Hard drive :
>>C' drive total hd space = 33.9G space
>>available = 20.2 G
>>D' drive total hd space = 273G space
>>available = 272G
>>E' drive total hd space = 273G space
>>available = 172 G
>>F' drive total hd space = 273G space
>>available = 127 G
>>F' drive total hd space = 819G space
>>available = 431 G
>>CPU = 2.80 GHz
>>RAM = 2.09G
>>Operating System = Windows 2000 SP4
>>Sql Server 2000 sp3a
>>.
>>.
>.
>
Showing posts with label determine. Show all posts
Showing posts with label determine. Show all posts
Saturday, February 25, 2012
Monday, February 20, 2012
Performance Monitoring
I ran performance monitoring on one of my server that is
performing slow in order to determine if there is a memory
or hardware bottleneck and came up with the following
statistics. Please help diagnose this and let me know if
we need to increase memory or configure something in sql
server. This is an average of statistics collected
during peak periods 19 times. Thanks for your help. I
already suggested that ram needs to be added to the
server, but I need more assured technical justification
as I am new to this. Thx.
PROCESSOR TIME
max36.42%
Average9.53%
System
Processor Queue Length (max)1
MEMORY
Pages/sec121
Available Mbytes 156
Page Faults/sec735
total physical memory1986302
total sql server memory - mb1589485
Processes page fault - Sql Server 73
Maximum workspace memory 1081725
DISK
Disk Reads per second244
Disk Writes per second99
Average Disk Queue length 4
SQL SERVER GENERAL STATISTICS
# connections 15
SQL Server Buffer Manager cache hit ratio 94
Hardware Info
Hard drive :
C' drive total hd space = 33.9G space
available = 20.2 G
D' drive total hd space = 273G space
available = 272G
E' drive total hd space = 273G space
available = 172 G
F' drive total hd space = 273G space
available = 127 G
F' drive total hd space = 819G space
available = 431 G
CPU = 2.80 GHz
RAM = 2.09G
Operating System = Windows 2000 SP4
Sql Server 2000 sp3a
also check out the kb below for a more general overview of how to
troubleshoot performance issues
http://support.microsoft.com/default...b;en-us;298475
Andy.
"Jasmine Gwendle" <anonymous@.discussions.microsoft.com> wrote in message
news:173c901c448ab$17949f00$a001280a@.phx.gbl...
> I ran performance monitoring on one of my server that is
> performing slow in order to determine if there is a memory
> or hardware bottleneck and came up with the following
> statistics. Please help diagnose this and let me know if
> we need to increase memory or configure something in sql
> server. This is an average of statistics collected
> during peak periods 19 times. Thanks for your help. I
> already suggested that ram needs to be added to the
> server, but I need more assured technical justification
> as I am new to this. Thx.
> PROCESSOR TIME
> max 36.42%
> Average 9.53%
> System
> Processor Queue Length (max) 1
> MEMORY
> Pages/sec 121
> Available Mbytes 156
> Page Faults/sec 735
> total physical memory 1986302
> total sql server memory - mb 1589485
> Processes page fault - Sql Server 73
> Maximum workspace memory 1081725
> DISK
> Disk Reads per second 244
> Disk Writes per second 99
> Average Disk Queue length 4
> SQL SERVER GENERAL STATISTICS
> # connections 15
> SQL Server Buffer Manager cache hit ratio 94
> Hardware Info
> Hard drive :
> C' drive total hd space = 33.9G space
> available = 20.2 G
> D' drive total hd space = 273G space
> available = 272G
> E' drive total hd space = 273G space
> available = 172 G
> F' drive total hd space = 273G space
> available = 127 G
> F' drive total hd space = 819G space
> available = 431 G
> CPU = 2.80 GHz
> RAM = 2.09G
> Operating System = Windows 2000 SP4
> Sql Server 2000 sp3a
>
performing slow in order to determine if there is a memory
or hardware bottleneck and came up with the following
statistics. Please help diagnose this and let me know if
we need to increase memory or configure something in sql
server. This is an average of statistics collected
during peak periods 19 times. Thanks for your help. I
already suggested that ram needs to be added to the
server, but I need more assured technical justification
as I am new to this. Thx.
PROCESSOR TIME
max36.42%
Average9.53%
System
Processor Queue Length (max)1
MEMORY
Pages/sec121
Available Mbytes 156
Page Faults/sec735
total physical memory1986302
total sql server memory - mb1589485
Processes page fault - Sql Server 73
Maximum workspace memory 1081725
DISK
Disk Reads per second244
Disk Writes per second99
Average Disk Queue length 4
SQL SERVER GENERAL STATISTICS
# connections 15
SQL Server Buffer Manager cache hit ratio 94
Hardware Info
Hard drive :
C' drive total hd space = 33.9G space
available = 20.2 G
D' drive total hd space = 273G space
available = 272G
E' drive total hd space = 273G space
available = 172 G
F' drive total hd space = 273G space
available = 127 G
F' drive total hd space = 819G space
available = 431 G
CPU = 2.80 GHz
RAM = 2.09G
Operating System = Windows 2000 SP4
Sql Server 2000 sp3a
also check out the kb below for a more general overview of how to
troubleshoot performance issues
http://support.microsoft.com/default...b;en-us;298475
Andy.
"Jasmine Gwendle" <anonymous@.discussions.microsoft.com> wrote in message
news:173c901c448ab$17949f00$a001280a@.phx.gbl...
> I ran performance monitoring on one of my server that is
> performing slow in order to determine if there is a memory
> or hardware bottleneck and came up with the following
> statistics. Please help diagnose this and let me know if
> we need to increase memory or configure something in sql
> server. This is an average of statistics collected
> during peak periods 19 times. Thanks for your help. I
> already suggested that ram needs to be added to the
> server, but I need more assured technical justification
> as I am new to this. Thx.
> PROCESSOR TIME
> max 36.42%
> Average 9.53%
> System
> Processor Queue Length (max) 1
> MEMORY
> Pages/sec 121
> Available Mbytes 156
> Page Faults/sec 735
> total physical memory 1986302
> total sql server memory - mb 1589485
> Processes page fault - Sql Server 73
> Maximum workspace memory 1081725
> DISK
> Disk Reads per second 244
> Disk Writes per second 99
> Average Disk Queue length 4
> SQL SERVER GENERAL STATISTICS
> # connections 15
> SQL Server Buffer Manager cache hit ratio 94
> Hardware Info
> Hard drive :
> C' drive total hd space = 33.9G space
> available = 20.2 G
> D' drive total hd space = 273G space
> available = 272G
> E' drive total hd space = 273G space
> available = 172 G
> F' drive total hd space = 273G space
> available = 127 G
> F' drive total hd space = 819G space
> available = 431 G
> CPU = 2.80 GHz
> RAM = 2.09G
> Operating System = Windows 2000 SP4
> Sql Server 2000 sp3a
>
Performance Monitoring
I ran performance monitoring on one of my server that is
performing slow in order to determine if there is a memory
or hardware bottleneck and came up with the following
statistics. Please help diagnose this and let me know if
we need to increase memory or configure something in sql
server. This is an average of statistics collected
during peak periods 19 times. Thanks for your help. I
already suggested that ram needs to be added to the
server, but I need more assured technical justification
as I am new to this. Thx.
PROCESSOR TIME
max 36.42%
Average 9.53%
System
Processor Queue Length (max) 1
MEMORY
Pages/sec 121
Available Mbytes 156
Page Faults/sec 735
total physical memory 1986302
total sql server memory - mb 1589485
Processes page fault - Sql Server 73
Maximum workspace memory 1081725
DISK
Disk Reads per second 244
Disk Writes per second 99
Average Disk Queue length 4
SQL SERVER GENERAL STATISTICS
# connections 15
SQL Server Buffer Manager cache hit ratio 94
Hardware Info
Hard drive :
C' drive total hd space = 33.9G space
available = 20.2 G
D' drive total hd space = 273G space
available = 272G
E' drive total hd space = 273G space
available = 172 G
F' drive total hd space = 273G space
available = 127 G
F' drive total hd space = 819G space
available = 431 G
CPU = 2.80 GHz
RAM = 2.09G
Operating System = Windows 2000 SP4
Sql Server 2000 sp3aalso check out the kb below for a more general overview of how to
troubleshoot performance issues
http://support.microsoft.com/defaul...kb;en-us;298475
Andy.
"Jasmine Gwendle" <anonymous@.discussions.microsoft.com> wrote in message
news:173c901c448ab$17949f00$a001280a@.phx
.gbl...
> I ran performance monitoring on one of my server that is
> performing slow in order to determine if there is a memory
> or hardware bottleneck and came up with the following
> statistics. Please help diagnose this and let me know if
> we need to increase memory or configure something in sql
> server. This is an average of statistics collected
> during peak periods 19 times. Thanks for your help. I
> already suggested that ram needs to be added to the
> server, but I need more assured technical justification
> as I am new to this. Thx.
> PROCESSOR TIME
> max 36.42%
> Average 9.53%
> System
> Processor Queue Length (max) 1
> MEMORY
> Pages/sec 121
> Available Mbytes 156
> Page Faults/sec 735
> total physical memory 1986302
> total sql server memory - mb 1589485
> Processes page fault - Sql Server 73
> Maximum workspace memory 1081725
> DISK
> Disk Reads per second 244
> Disk Writes per second 99
> Average Disk Queue length 4
> SQL SERVER GENERAL STATISTICS
> # connections 15
> SQL Server Buffer Manager cache hit ratio 94
> hardware Info
> Hard drive :
> C' drive total hd space = 33.9G space
> available = 20.2 G
> D' drive total hd space = 273G space
> available = 272G
> E' drive total hd space = 273G space
> available = 172 G
> F' drive total hd space = 273G space
> available = 127 G
> F' drive total hd space = 819G space
> available = 431 G
> CPU = 2.80 GHz
> RAM = 2.09G
> Operating System = Windows 2000 SP4
> Sql Server 2000 sp3a
>
performing slow in order to determine if there is a memory
or hardware bottleneck and came up with the following
statistics. Please help diagnose this and let me know if
we need to increase memory or configure something in sql
server. This is an average of statistics collected
during peak periods 19 times. Thanks for your help. I
already suggested that ram needs to be added to the
server, but I need more assured technical justification
as I am new to this. Thx.
PROCESSOR TIME
max 36.42%
Average 9.53%
System
Processor Queue Length (max) 1
MEMORY
Pages/sec 121
Available Mbytes 156
Page Faults/sec 735
total physical memory 1986302
total sql server memory - mb 1589485
Processes page fault - Sql Server 73
Maximum workspace memory 1081725
DISK
Disk Reads per second 244
Disk Writes per second 99
Average Disk Queue length 4
SQL SERVER GENERAL STATISTICS
# connections 15
SQL Server Buffer Manager cache hit ratio 94
Hardware Info
Hard drive :
C' drive total hd space = 33.9G space
available = 20.2 G
D' drive total hd space = 273G space
available = 272G
E' drive total hd space = 273G space
available = 172 G
F' drive total hd space = 273G space
available = 127 G
F' drive total hd space = 819G space
available = 431 G
CPU = 2.80 GHz
RAM = 2.09G
Operating System = Windows 2000 SP4
Sql Server 2000 sp3aalso check out the kb below for a more general overview of how to
troubleshoot performance issues
http://support.microsoft.com/defaul...kb;en-us;298475
Andy.
"Jasmine Gwendle" <anonymous@.discussions.microsoft.com> wrote in message
news:173c901c448ab$17949f00$a001280a@.phx
.gbl...
> I ran performance monitoring on one of my server that is
> performing slow in order to determine if there is a memory
> or hardware bottleneck and came up with the following
> statistics. Please help diagnose this and let me know if
> we need to increase memory or configure something in sql
> server. This is an average of statistics collected
> during peak periods 19 times. Thanks for your help. I
> already suggested that ram needs to be added to the
> server, but I need more assured technical justification
> as I am new to this. Thx.
> PROCESSOR TIME
> max 36.42%
> Average 9.53%
> System
> Processor Queue Length (max) 1
> MEMORY
> Pages/sec 121
> Available Mbytes 156
> Page Faults/sec 735
> total physical memory 1986302
> total sql server memory - mb 1589485
> Processes page fault - Sql Server 73
> Maximum workspace memory 1081725
> DISK
> Disk Reads per second 244
> Disk Writes per second 99
> Average Disk Queue length 4
> SQL SERVER GENERAL STATISTICS
> # connections 15
> SQL Server Buffer Manager cache hit ratio 94
> hardware Info
> Hard drive :
> C' drive total hd space = 33.9G space
> available = 20.2 G
> D' drive total hd space = 273G space
> available = 272G
> E' drive total hd space = 273G space
> available = 172 G
> F' drive total hd space = 273G space
> available = 127 G
> F' drive total hd space = 819G space
> available = 431 G
> CPU = 2.80 GHz
> RAM = 2.09G
> Operating System = Windows 2000 SP4
> Sql Server 2000 sp3a
>
Performance Monitoring
I need to compare the performance of two servers, in
order to determine where to put a new application. Both
of the servers have the same specs, whichever has the
most available resources will of course be selected.
What should performance monitors should I use to make
this comparison report and how long should I monitor the
servers?
Any recommendations?
Thanks,
AdamHi,
During peak hours run the system monitor with below counters on both
servers;
Memory : Available megabytes
Processor : Processor time for all CPUS
Disk : Queue length
Based on the out come of above you can identify which server is relatevely
free.
Just check my article in MSDN to setup system monitor and enable counters.
http://www.microsoft.com/india/msdn/articles/193.aspx?
Thanks
Hari
MCDBA
"Adam" <anonymous@.discussions.microsoft.com> wrote in message
news:18a5401c41b9e$f0a08190$a301280a@.phx
.gbl...
> I need to compare the performance of two servers, in
> order to determine where to put a new application. Both
> of the servers have the same specs, whichever has the
> most available resources will of course be selected.
> What should performance monitors should I use to make
> this comparison report and how long should I monitor the
> servers?
> Any recommendations?
> Thanks,
> Adam|||Thanks Hari!! Will do.
>--Original Message--
>Hi,
>During peak hours run the system monitor with below
counters on both
>servers;
>Memory : Available megabytes
>Processor : Processor time for all CPUS
>Disk : Queue length
>Based on the out come of above you can identify which
server is relatevely
>free.
>Just check my article in MSDN to setup system monitor
and enable counters.
>http://www.microsoft.com/india/msdn/articles/193.aspx?
>Thanks
>Hari
>MCDBA
>
>"Adam" <anonymous@.discussions.microsoft.com> wrote in
message
> news:18a5401c41b9e$f0a08190$a301280a@.phx
.gbl...
the
>
>.
>|||Personally I also put network usage as well.
J
>--Original Message--
>Hi,
>During peak hours run the system monitor with below
counters on both
>servers;
>Memory : Available megabytes
>Processor : Processor time for all CPUS
>Disk : Queue length
>Based on the out come of above you can identify which
server is relatevely
>free.
>Just check my article in MSDN to setup system monitor and
enable counters.
>http://www.microsoft.com/india/msdn/articles/193.aspx?
>Thanks
>Hari
>MCDBA
>
>"Adam" <anonymous@.discussions.microsoft.com> wrote in
message
> news:18a5401c41b9e$f0a08190$a301280a@.phx
.gbl...
>
>.
>
order to determine where to put a new application. Both
of the servers have the same specs, whichever has the
most available resources will of course be selected.
What should performance monitors should I use to make
this comparison report and how long should I monitor the
servers?
Any recommendations?
Thanks,
AdamHi,
During peak hours run the system monitor with below counters on both
servers;
Memory : Available megabytes
Processor : Processor time for all CPUS
Disk : Queue length
Based on the out come of above you can identify which server is relatevely
free.
Just check my article in MSDN to setup system monitor and enable counters.
http://www.microsoft.com/india/msdn/articles/193.aspx?
Thanks
Hari
MCDBA
"Adam" <anonymous@.discussions.microsoft.com> wrote in message
news:18a5401c41b9e$f0a08190$a301280a@.phx
.gbl...
> I need to compare the performance of two servers, in
> order to determine where to put a new application. Both
> of the servers have the same specs, whichever has the
> most available resources will of course be selected.
> What should performance monitors should I use to make
> this comparison report and how long should I monitor the
> servers?
> Any recommendations?
> Thanks,
> Adam|||Thanks Hari!! Will do.
>--Original Message--
>Hi,
>During peak hours run the system monitor with below
counters on both
>servers;
>Memory : Available megabytes
>Processor : Processor time for all CPUS
>Disk : Queue length
>Based on the out come of above you can identify which
server is relatevely
>free.
>Just check my article in MSDN to setup system monitor
and enable counters.
>http://www.microsoft.com/india/msdn/articles/193.aspx?
>Thanks
>Hari
>MCDBA
>
>"Adam" <anonymous@.discussions.microsoft.com> wrote in
message
> news:18a5401c41b9e$f0a08190$a301280a@.phx
.gbl...
the
>
>.
>|||Personally I also put network usage as well.
J
>--Original Message--
>Hi,
>During peak hours run the system monitor with below
counters on both
>servers;
>Memory : Available megabytes
>Processor : Processor time for all CPUS
>Disk : Queue length
>Based on the out come of above you can identify which
server is relatevely
>free.
>Just check my article in MSDN to setup system monitor and
enable counters.
>http://www.microsoft.com/india/msdn/articles/193.aspx?
>Thanks
>Hari
>MCDBA
>
>"Adam" <anonymous@.discussions.microsoft.com> wrote in
message
> news:18a5401c41b9e$f0a08190$a301280a@.phx
.gbl...
>
>.
>
Subscribe to:
Posts (Atom)