 | |
#41
 
| |||
| |||
|
Re: High disk read activity on sql server -
11-06-2008
, 07:36 AM
|
memory and processor utilization is very normal. this is a new server only 2 months old and we are facing these iossue only recently "Andrew J. Kelly" wrote: Well there are probably multiple issues but it sounds like you are accessing disk way too much. But why we can not say from so little info. I would guess your queries are scanning tables instead of using proper indexes. You don't have a lot of memory so the constant disk access is evident in these numbers showing very poor disk utilization. Why are you using Enterprise edition if you only have 4GB of memory? I would opt for more memory and tune your worst performing queries to reduce the IO. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:8E0CABF2-4010-4C19-B192-90329CAFE94B (AT) microsoft (DOT) com... mY SQL SERVER 2005 is very slow especially for seelct queries and i checked the perfmon counters the values rea as follows %disk time =4000 buffer cache hit ratio =90 avg disk sec/transfer .25avg disk secs\read =0.1 current disk que lenth =140 mem pages/sec =very low disk is raid 1o with 6 disks memory 4 gb sql 2205 enterprise sp2 HP DL 380 G5 Pls advise |
#42
| |||
| |||
|
|
Processors utilization will always be low when you have disk bottlenecks since it is always waiting on the disk before it can do much. And there is no way memory utilization is normal with figures like that. That may be normal for your app but certainly not normal for a well tuned app. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:2D8153B6-4494-4174-B654-6A83FE637DC7 (AT) microsoft (DOT) com... memory and processor utilization is very normal. this is a new server only 2 months old and we are facing these iossue only recently "Andrew J. Kelly" wrote: Well there are probably multiple issues but it sounds like you are accessing disk way too much. But why we can not say from so little info. I would guess your queries are scanning tables instead of using proper indexes. You don't have a lot of memory so the constant disk access is evident in these numbers showing very poor disk utilization. Why are you using Enterprise edition if you only have 4GB of memory? I would opt for more memory and tune your worst performing queries to reduce the IO. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:8E0CABF2-4010-4C19-B192-90329CAFE94B (AT) microsoft (DOT) com... mY SQL SERVER 2005 is very slow especially for seelct queries and i checked the perfmon counters the values rea as follows %disk time =4000 buffer cache hit ratio =90 avg disk sec/transfer .25avg disk secs\read =0.1 current disk que lenth =140 mem pages/sec =very low disk is raid 1o with 6 disks memory 4 gb sql 2205 enterprise sp2 HP DL 380 G5 Pls advise |
#43
| |||
| |||
|
|
Processors utilization will always be low when you have disk bottlenecks since it is always waiting on the disk before it can do much. And there is no way memory utilization is normal with figures like that. That may be normal for your app but certainly not normal for a well tuned app. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:2D8153B6-4494-4174-B654-6A83FE637DC7 (AT) microsoft (DOT) com... memory and processor utilization is very normal. this is a new server only 2 months old and we are facing these iossue only recently "Andrew J. Kelly" wrote: Well there are probably multiple issues but it sounds like you are accessing disk way too much. But why we can not say from so little info. I would guess your queries are scanning tables instead of using proper indexes. You don't have a lot of memory so the constant disk access is evident in these numbers showing very poor disk utilization. Why are you using Enterprise edition if you only have 4GB of memory? I would opt for more memory and tune your worst performing queries to reduce the IO. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:8E0CABF2-4010-4C19-B192-90329CAFE94B (AT) microsoft (DOT) com... mY SQL SERVER 2005 is very slow especially for seelct queries and i checked the perfmon counters the values rea as follows %disk time =4000 buffer cache hit ratio =90 avg disk sec/transfer .25avg disk secs\read =0.1 current disk que lenth =140 mem pages/sec =very low disk is raid 1o with 6 disks memory 4 gb sql 2205 enterprise sp2 HP DL 380 G5 Pls advise |
#44
| |||
| |||
|
|
Processors utilization will always be low when you have disk bottlenecks since it is always waiting on the disk before it can do much. And there is no way memory utilization is normal with figures like that. That may be normal for your app but certainly not normal for a well tuned app. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:2D8153B6-4494-4174-B654-6A83FE637DC7 (AT) microsoft (DOT) com... memory and processor utilization is very normal. this is a new server only 2 months old and we are facing these iossue only recently "Andrew J. Kelly" wrote: Well there are probably multiple issues but it sounds like you are accessing disk way too much. But why we can not say from so little info. I would guess your queries are scanning tables instead of using proper indexes. You don't have a lot of memory so the constant disk access is evident in these numbers showing very poor disk utilization. Why are you using Enterprise edition if you only have 4GB of memory? I would opt for more memory and tune your worst performing queries to reduce the IO. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:8E0CABF2-4010-4C19-B192-90329CAFE94B (AT) microsoft (DOT) com... mY SQL SERVER 2005 is very slow especially for seelct queries and i checked the perfmon counters the values rea as follows %disk time =4000 buffer cache hit ratio =90 avg disk sec/transfer .25avg disk secs\read =0.1 current disk que lenth =140 mem pages/sec =very low disk is raid 1o with 6 disks memory 4 gb sql 2205 enterprise sp2 HP DL 380 G5 Pls advise |
#45
| |||
| |||
|
|
Processors utilization will always be low when you have disk bottlenecks since it is always waiting on the disk before it can do much. And there is no way memory utilization is normal with figures like that. That may be normal for your app but certainly not normal for a well tuned app. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:2D8153B6-4494-4174-B654-6A83FE637DC7 (AT) microsoft (DOT) com... memory and processor utilization is very normal. this is a new server only 2 months old and we are facing these iossue only recently "Andrew J. Kelly" wrote: Well there are probably multiple issues but it sounds like you are accessing disk way too much. But why we can not say from so little info. I would guess your queries are scanning tables instead of using proper indexes. You don't have a lot of memory so the constant disk access is evident in these numbers showing very poor disk utilization. Why are you using Enterprise edition if you only have 4GB of memory? I would opt for more memory and tune your worst performing queries to reduce the IO. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:8E0CABF2-4010-4C19-B192-90329CAFE94B (AT) microsoft (DOT) com... mY SQL SERVER 2005 is very slow especially for seelct queries and i checked the perfmon counters the values rea as follows %disk time =4000 buffer cache hit ratio =90 avg disk sec/transfer .25avg disk secs\read =0.1 current disk que lenth =140 mem pages/sec =very low disk is raid 1o with 6 disks memory 4 gb sql 2205 enterprise sp2 HP DL 380 G5 Pls advise |
#46
| |||
| |||
|
|
Processors utilization will always be low when you have disk bottlenecks since it is always waiting on the disk before it can do much. And there is no way memory utilization is normal with figures like that. That may be normal for your app but certainly not normal for a well tuned app. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:2D8153B6-4494-4174-B654-6A83FE637DC7 (AT) microsoft (DOT) com... memory and processor utilization is very normal. this is a new server only 2 months old and we are facing these iossue only recently "Andrew J. Kelly" wrote: Well there are probably multiple issues but it sounds like you are accessing disk way too much. But why we can not say from so little info. I would guess your queries are scanning tables instead of using proper indexes. You don't have a lot of memory so the constant disk access is evident in these numbers showing very poor disk utilization. Why are you using Enterprise edition if you only have 4GB of memory? I would opt for more memory and tune your worst performing queries to reduce the IO. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:8E0CABF2-4010-4C19-B192-90329CAFE94B (AT) microsoft (DOT) com... mY SQL SERVER 2005 is very slow especially for seelct queries and i checked the perfmon counters the values rea as follows %disk time =4000 buffer cache hit ratio =90 avg disk sec/transfer .25avg disk secs\read =0.1 current disk que lenth =140 mem pages/sec =very low disk is raid 1o with 6 disks memory 4 gb sql 2205 enterprise sp2 HP DL 380 G5 Pls advise |
#47
| |||
| |||
|
|
Processors utilization will always be low when you have disk bottlenecks since it is always waiting on the disk before it can do much. And there is no way memory utilization is normal with figures like that. That may be normal for your app but certainly not normal for a well tuned app. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:2D8153B6-4494-4174-B654-6A83FE637DC7 (AT) microsoft (DOT) com... memory and processor utilization is very normal. this is a new server only 2 months old and we are facing these iossue only recently "Andrew J. Kelly" wrote: Well there are probably multiple issues but it sounds like you are accessing disk way too much. But why we can not say from so little info. I would guess your queries are scanning tables instead of using proper indexes. You don't have a lot of memory so the constant disk access is evident in these numbers showing very poor disk utilization. Why are you using Enterprise edition if you only have 4GB of memory? I would opt for more memory and tune your worst performing queries to reduce the IO. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:8E0CABF2-4010-4C19-B192-90329CAFE94B (AT) microsoft (DOT) com... mY SQL SERVER 2005 is very slow especially for seelct queries and i checked the perfmon counters the values rea as follows %disk time =4000 buffer cache hit ratio =90 avg disk sec/transfer .25avg disk secs\read =0.1 current disk que lenth =140 mem pages/sec =very low disk is raid 1o with 6 disks memory 4 gb sql 2205 enterprise sp2 HP DL 380 G5 Pls advise |
#48
| |||
| |||
|
|
Processors utilization will always be low when you have disk bottlenecks since it is always waiting on the disk before it can do much. And there is no way memory utilization is normal with figures like that. That may be normal for your app but certainly not normal for a well tuned app. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:2D8153B6-4494-4174-B654-6A83FE637DC7 (AT) microsoft (DOT) com... memory and processor utilization is very normal. this is a new server only 2 months old and we are facing these iossue only recently "Andrew J. Kelly" wrote: Well there are probably multiple issues but it sounds like you are accessing disk way too much. But why we can not say from so little info. I would guess your queries are scanning tables instead of using proper indexes. You don't have a lot of memory so the constant disk access is evident in these numbers showing very poor disk utilization. Why are you using Enterprise edition if you only have 4GB of memory? I would opt for more memory and tune your worst performing queries to reduce the IO. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:8E0CABF2-4010-4C19-B192-90329CAFE94B (AT) microsoft (DOT) com... mY SQL SERVER 2005 is very slow especially for seelct queries and i checked the perfmon counters the values rea as follows %disk time =4000 buffer cache hit ratio =90 avg disk sec/transfer .25avg disk secs\read =0.1 current disk que lenth =140 mem pages/sec =very low disk is raid 1o with 6 disks memory 4 gb sql 2205 enterprise sp2 HP DL 380 G5 Pls advise |
#49
| |||
| |||
|
|
Processors utilization will always be low when you have disk bottlenecks since it is always waiting on the disk before it can do much. And there is no way memory utilization is normal with figures like that. That may be normal for your app but certainly not normal for a well tuned app. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:2D8153B6-4494-4174-B654-6A83FE637DC7 (AT) microsoft (DOT) com... memory and processor utilization is very normal. this is a new server only 2 months old and we are facing these iossue only recently "Andrew J. Kelly" wrote: Well there are probably multiple issues but it sounds like you are accessing disk way too much. But why we can not say from so little info. I would guess your queries are scanning tables instead of using proper indexes. You don't have a lot of memory so the constant disk access is evident in these numbers showing very poor disk utilization. Why are you using Enterprise edition if you only have 4GB of memory? I would opt for more memory and tune your worst performing queries to reduce the IO. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:8E0CABF2-4010-4C19-B192-90329CAFE94B (AT) microsoft (DOT) com... mY SQL SERVER 2005 is very slow especially for seelct queries and i checked the perfmon counters the values rea as follows %disk time =4000 buffer cache hit ratio =90 avg disk sec/transfer .25avg disk secs\read =0.1 current disk que lenth =140 mem pages/sec =very low disk is raid 1o with 6 disks memory 4 gb sql 2205 enterprise sp2 HP DL 380 G5 Pls advise |
#50
| |||
| |||
|
|
Processors utilization will always be low when you have disk bottlenecks since it is always waiting on the disk before it can do much. And there is no way memory utilization is normal with figures like that. That may be normal for your app but certainly not normal for a well tuned app. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:2D8153B6-4494-4174-B654-6A83FE637DC7 (AT) microsoft (DOT) com... memory and processor utilization is very normal. this is a new server only 2 months old and we are facing these iossue only recently "Andrew J. Kelly" wrote: Well there are probably multiple issues but it sounds like you are accessing disk way too much. But why we can not say from so little info. I would guess your queries are scanning tables instead of using proper indexes. You don't have a lot of memory so the constant disk access is evident in these numbers showing very poor disk utilization. Why are you using Enterprise edition if you only have 4GB of memory? I would opt for more memory and tune your worst performing queries to reduce the IO. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "bijupg (AT) hotmail (DOT) com" <bijupghotmailcom (AT) discussions (DOT) microsoft.com> wrote in message news:8E0CABF2-4010-4C19-B192-90329CAFE94B (AT) microsoft (DOT) com... mY SQL SERVER 2005 is very slow especially for seelct queries and i checked the perfmon counters the values rea as follows %disk time =4000 buffer cache hit ratio =90 avg disk sec/transfer .25avg disk secs\read =0.1 current disk que lenth =140 mem pages/sec =very low disk is raid 1o with 6 disks memory 4 gb sql 2205 enterprise sp2 HP DL 380 G5 Pls advise |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.