Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2010-02-19 : 11:42:10
|
| Team,My Maintenanceplan contains database integrity task,update statistics task.The integrity had run successfully but for the update statistics task the plan was executing continuosly saying in the error log as SQL Server has encountered 225 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [G:\SQLData\MSSQL.1\MSSQL\DATA\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x000000000000072C. The offset of the latest long I/O is: 0x00000291dd0000 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2010-02-19 : 13:41:20
|
| you have a slow disk that can't handle so much activity. get a faster IO subsystem.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.7 out! |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
|
|
|
|
|
OS 0x000000000000072C