May 16, 2007 at 8:49 am
Hi,
Users are complaining for slow system. Viewing performance monitor i captured the following data. I believe that the problems seems to be on Hard Drives. Any suggestion for optimizing server performance and making it health!
Avg Disk Write Que: 50-55%
Avg Disk Read Que:100%
% Disk Time: 100%
% Processor Time: 45-50%
May 16, 2007 at 9:40 am
Since you are in somewhat of an emergency situation
do a sp_who2, and see if there are any "RUNNABLE" Connections where CPU Time or DISKIO is high.
then next do a dbcc inputbuffer(spid) to see if you can see what is going on.
But do this at your own risk. I will not guarantee this helps anything.
If not critical then Kill it.
Otherwise just wait til it dies down.
then you will have to embark on a performance tuning and monitoring project to keep this stuff in check. Tune that query, and all other queryies.
Check Index health and reorganize where necessary.
Good site
http://www.sql-server-performance.com/articles_performance.asp
May 17, 2007 at 4:35 am
What is your buffer cache hit ratio? If this is below 90% then your problem lies at least as much with memory as with disk.
If you cannot fix the problem yourself and the application generates a lot of money for your organisation, then you should be able to get funds to hire a performance tuning consultant.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply