| Author |
 Topic  |
|
|
DBA007
Posting Yak Master
India
141 Posts |
 Posted - 02/03/2010 : 13:17:12
|
Team,
My MaintenancePlan has failed today with stating the error as
Executing the query "UPDATE STATISTICS [dbo].[ItemLogitech]
WITH FULLSCAN" failed with the following error: "A severe error occurred on the current command.
The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded.".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 02/03/2010 : 14:02:34
|
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
--
Gail Shaw
SQL Server MVP |
 |
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 02/03/2010 : 14:03:46
|
Do you have a particularly bad IO subsystem or something? Because nearly every post is a corrupt DB, a backup failure or similar. Personally, I'd be really concerned at this point if those were my systems.
--
Gail Shaw
SQL Server MVP |
|
|
|
DBA007
Posting Yak Master
India
141 Posts |
Posted - 02/03/2010 : 15:48:07
|
| Gail,the Maintenanceplan and the dbcc freeproccache both run at a time,but today only i got this problem and i found there are no error msgs by dbcc checkdb |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 02/03/2010 : 16:27:47
|
DBCC FREEPROCCACHE? Why are you running that?
Is there anything in the SQL error log?
--
Gail Shaw
SQL Server MVP |
|
|
|
DBA007
Posting Yak Master
India
141 Posts |
Posted - 02/03/2010 : 16:39:18
|
except this i found nothing.
SQL Server has encountered 756 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [d:\sqldata\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x000000000000089C. The offset of the latest long I/O is: 0x00000090b80000 |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 02/04/2010 : 04:28:02
|
Speak to the server admins. You've got a very slow IO subsystem (or something else is using a lot of disk bandwidth)
--
Gail Shaw
SQL Server MVP |
|
|
| |
Topic |
|
Update Statistics error 1073548784
