December 8, 2008 at 2:04 am
hi,
I got these info msgs in the error log. what actually it means. could you plz explan me.
2008-12-07 02:31:46.44 spid1 SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\abc\efg_NDX\efgNDX2.NDF] in database [abc] (5). The OS file handle is 0x000000B4. The offset of the latest long IO is: 0x0000009537e000
2008-12-07 02:31:51.35 spid1 SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\abc\efg_NDX\efgNDX1.NDF] in database [abc] (5). The OS file handle is 0x000004B4. The offset of the latest long IO is: 0x0000009b63c000
2008-12-07 02:36:19.87 spid1 SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\Program Files\Microsoft SQL Server\MSSQL\data\templog.ldf] in database [tempdb] (2). The OS file handle is 0x0000055C. The offset of the latest long IO is: 0x0000006d631400
2008-12-07 02:36:19.87 spid1 SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf] in database [master] (1). The OS file handle is 0x00000398. The offset of the latest long IO is: 0x00000000489a00
2008-12-07 02:36:19.87 spid1 SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [D:\abc\efg_dat\efgPRI1.MDF] in database [abc] (5). The OS file handle is 0x0000043C. The offset of the latest long IO is: 0x00000205590000
2008-12-07 02:36:46.48 spid6 SQL Server has encountered 2026 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\abc\efg_NDX\efgNDX2.NDF] in database [abc] (5). The OS file handle is 0x000000B4. The offset of the latest long IO is: 0x000000d85a4000
2008-12-07 02:36:51.68 spid57 SQL Server has encountered 1459 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\abc\efg_NDX\efgNDX1.NDF] in database [abc] (5). The OS file handle is 0x000004B4. The offset of the latest long IO is: 0x000000e1562000
2008-12-07 02:52:08.73 spid1 SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\xyz\efg_NDX\efgNDX1.NDF] in database [xyz] (8). The OS file handle is 0x000003F8. The offset of the latest long IO is: 0x0000004d2b8000
2008-12-07 02:52:08.73 spid1 SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\xyz\efg_NDX\efgNDX2.NDF] in database [xyz] (8). The OS file handle is 0x000003F4. The offset of the latest long IO is: 0x0000000ea06000
2008-12-07 02:52:08.73 spid1 SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [D:\xyz\efg_dat\efgPRI1.MDF] in database [xyz] (8). The OS file handle is 0x00000434. The offset of the latest long IO is: 0x000001bb500000
2008-12-07 02:57:08.74 spid57 SQL Server has encountered 1541 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\xyz\efg_NDX\efgNDX1.NDF] in database [xyz] (8). The OS file handle is 0x000003F8. The offset of the latest long IO is: 0x0000004c718000
2008-12-07 02:57:08.74 spid57 SQL Server has encountered 398 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\xyz\efg_NDX\efgNDX2.NDF] in database [xyz] (8). The OS file handle is 0x000003F4. The offset of the latest long IO is: 0x0000000e25e000
2008-12-07 03:19:48.52 spid8 Could not adjust the space allocation for file 'efg1_NDX'
thanks
December 8, 2008 at 2:22 am
My guess is that you have autogrow enabled, one of more files grew and completely overloaded the IO system.
Either set smaller autogrow increments or (preferably) monitor the free space in data files and grow the files manually during a quiet time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 8, 2008 at 3:18 am
Hi,
Iam increasing the data file size manually as below.
Enterprise manager->database->properties->datafiles and increasing the size in space allocated(MB) coulmn.
plz tell me, the way Iam doing is right?
December 8, 2008 at 3:46 am
[font="Verdana"]How to increase size of database (Enterprise Manager)
http://msdn.microsoft.com/en-us/library/aa197143(SQL.80).aspx
HTH :)[/font]
December 8, 2008 at 4:06 am
Yup, that's fine.
Were you trying to grow the data file when those messages appeared?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 8, 2008 at 5:30 am
No, we are decided to do after office hours..
thank you
December 11, 2008 at 8:25 am
2008-12-07 02:57:08.74 spid57 SQL Server has encountered 398 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\xyz\efg_NDX\efgNDX2.NDF] in database [xyz] (8). The OS file handle is 0x000003F4. The offset of the latest long IO is: 0x0000000e25e000
2008-12-07 03:19:48.52 spid8 Could not adjust the space allocation for file 'efg1_NDX'
There is a gap of 22 minutes before the last error appears in the errorlog provided by you. I believe there is also an issue of insufficient memory in your server or to say the least it's been hit heavily as you get the errors with IO requests taking longer than.... What is the RAID configuration you use on this one.
Apart from what I mentioned above you need to have allow the database to grow in suitable size limits as mentioned by Gail...
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply