Performance Monitoring
From: Jasmine (anonymous_at_discussions.microsoft.com)
Date: 06/02/04
- Next message: Andrew J. Kelly: "Re: Fast Way To "Insert Into" a million records?"
- Previous message: Andrew J. Kelly: "Re: Maintenance PLan recommendation"
- In reply to: Julie: "Performance Monitoring"
- Next in thread: Julie: "Performance Monitoring"
- Reply: Julie: "Performance Monitoring"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 2 Jun 2004 10:24:34 -0700
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
>>
>>.
>>
>.
>
- Next message: Andrew J. Kelly: "Re: Fast Way To "Insert Into" a million records?"
- Previous message: Andrew J. Kelly: "Re: Maintenance PLan recommendation"
- In reply to: Julie: "Performance Monitoring"
- Next in thread: Julie: "Performance Monitoring"
- Reply: Julie: "Performance Monitoring"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
