Friday, February 24, 2012

64 bit 60 gb db with RAID 10 4 VOLUME

I am working with SQL 2005 64 bit sp1 , i am facing problem continues in
error log file mentioned below, can you please help me
SQL Server has encountered 1 occurrence(s) of I/O requests taking longer
than 15 seconds to complete on file
[E:\ITS247DBFiles\ItSupport247DB1.mdf:MSSQL_DBCC11] in database
[ItSupport247DB] (11). The OS file handle is 0x0000000000007F5C. The offset
of the latest long I/O is: 0x0000032dac0000
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp."Jay" <Jay@.discussions.microsoft.com> wrote in message
news:926CD051-B1BF-481A-AA4D-BA06AB7DBA72@.microsoft.com...
>I am working with SQL 2005 64 bit sp1 , i am facing problem continues in
> error log file mentioned below, can you please help me
> SQL Server has encountered 1 occurrence(s) of I/O requests taking longer
> than 15 seconds to complete on file
> [E:\ITS247DBFiles\ItSupport247DB1.mdf:MSSQL_DBCC11] in database
> [ItSupport247DB] (11). The OS file handle is 0x0000000000007F5C. The
> offset
> of the latest long I/O is: 0x0000032dac0000
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
I'd look at the disk array first, make sure you have the latest drivers,
that there's no hardware issues, etc.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||Generally indicates a HW problem.
Had this recently, first line of defense is to power-cycle the server,
second is to refresh RAID controller microcode and power-cycle. Doing
this seems to have "fixed" two of our servers where we were getting
this message - except at much, much higher volumes!
J.
On Tue, 27 Feb 2007 19:59:05 -0800, Jay
<Jay@.discussions.microsoft.com> wrote:
>I am working with SQL 2005 64 bit sp1 , i am facing problem continues in
>error log file mentioned below, can you please help me
>SQL Server has encountered 1 occurrence(s) of I/O requests taking longer
>than 15 seconds to complete on file
>[E:\ITS247DBFiles\ItSupport247DB1.mdf:MSSQL_DBCC11] in database
>[ItSupport247DB] (11). The OS file handle is 0x0000000000007F5C. The offset
>of the latest long I/O is: 0x0000032dac0000
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.|||very very Thanks to Greg and JXStern,
can you provide some links related this issues, so that i can show to my
boss.it will be more helpfull to me.
waiting for you alls reply.
regards
Jay
"JXStern" wrote:
> Generally indicates a HW problem.
> Had this recently, first line of defense is to power-cycle the server,
> second is to refresh RAID controller microcode and power-cycle. Doing
> this seems to have "fixed" two of our servers where we were getting
> this message - except at much, much higher volumes!
> J.
>
> On Tue, 27 Feb 2007 19:59:05 -0800, Jay
> <Jay@.discussions.microsoft.com> wrote:
> >I am working with SQL 2005 64 bit sp1 , i am facing problem continues in
> >error log file mentioned below, can you please help me
> >
> >SQL Server has encountered 1 occurrence(s) of I/O requests taking longer
> >than 15 seconds to complete on file
> >[E:\ITS247DBFiles\ItSupport247DB1.mdf:MSSQL_DBCC11] in database
> >[ItSupport247DB] (11). The OS file handle is 0x0000000000007F5C. The offset
> >of the latest long I/O is: 0x0000032dac0000
> >
> >For more information, see Help and Support Center at
> >http://go.microsoft.com/fwlink/events.asp.
>|||Me, I don't have anything, just called the sysadmin guys (emailed,
actually), and they told me this story, then did it, and it worked!
Twice!
These are only fairly current HP servers, so the problem is probably
very, very, very common.
J.
On Wed, 28 Feb 2007 06:55:52 -0800, Jay
<Jay@.discussions.microsoft.com> wrote:
>very very Thanks to Greg and JXStern,
>can you provide some links related this issues, so that i can show to my
>boss.it will be more helpfull to me.
>waiting for you alls reply.
>regards
>Jay
>
>"JXStern" wrote:
>> Generally indicates a HW problem.
>> Had this recently, first line of defense is to power-cycle the server,
>> second is to refresh RAID controller microcode and power-cycle. Doing
>> this seems to have "fixed" two of our servers where we were getting
>> this message - except at much, much higher volumes!
>> J.
>>
>> On Tue, 27 Feb 2007 19:59:05 -0800, Jay
>> <Jay@.discussions.microsoft.com> wrote:
>> >I am working with SQL 2005 64 bit sp1 , i am facing problem continues in
>> >error log file mentioned below, can you please help me
>> >
>> >SQL Server has encountered 1 occurrence(s) of I/O requests taking longer
>> >than 15 seconds to complete on file
>> >[E:\ITS247DBFiles\ItSupport247DB1.mdf:MSSQL_DBCC11] in database
>> >[ItSupport247DB] (11). The OS file handle is 0x0000000000007F5C. The offset
>> >of the latest long I/O is: 0x0000032dac0000
>> >
>> >For more information, see Help and Support Center at
>> >http://go.microsoft.com/fwlink/events.asp.
>>|||thanks JXStern,
i am trying for a link to this issues, so that i can tell to my BOSS
thanks thanks very much
jay
"JXStern" wrote:
> Me, I don't have anything, just called the sysadmin guys (emailed,
> actually), and they told me this story, then did it, and it worked!
> Twice!
> These are only fairly current HP servers, so the problem is probably
> very, very, very common.
> J.
>
> On Wed, 28 Feb 2007 06:55:52 -0800, Jay
> <Jay@.discussions.microsoft.com> wrote:
> >very very Thanks to Greg and JXStern,
> >
> >can you provide some links related this issues, so that i can show to my
> >boss.it will be more helpfull to me.
> >
> >waiting for you alls reply.
> >
> >regards
> >
> >Jay
> >
> >
> >
> >"JXStern" wrote:
> >
> >> Generally indicates a HW problem.
> >>
> >> Had this recently, first line of defense is to power-cycle the server,
> >> second is to refresh RAID controller microcode and power-cycle. Doing
> >> this seems to have "fixed" two of our servers where we were getting
> >> this message - except at much, much higher volumes!
> >>
> >> J.
> >>
> >>
> >> On Tue, 27 Feb 2007 19:59:05 -0800, Jay
> >> <Jay@.discussions.microsoft.com> wrote:
> >>
> >> >I am working with SQL 2005 64 bit sp1 , i am facing problem continues in
> >> >error log file mentioned below, can you please help me
> >> >
> >> >SQL Server has encountered 1 occurrence(s) of I/O requests taking longer
> >> >than 15 seconds to complete on file
> >> >[E:\ITS247DBFiles\ItSupport247DB1.mdf:MSSQL_DBCC11] in database
> >> >[ItSupport247DB] (11). The OS file handle is 0x0000000000007F5C. The offset
> >> >of the latest long I/O is: 0x0000032dac0000
> >> >
> >> >For more information, see Help and Support Center at
> >> >http://go.microsoft.com/fwlink/events.asp.
> >>
> >>
>

No comments:

Post a Comment