SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Update Statistics error 1073548784
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

DBA007
Posting Yak Master

India
145 Posts

Posted - 02/03/2010 :  13:17:12  Show Profile  Reply with Quote
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  Show Profile  Visit GilaMonster's Homepage  Reply with Quote

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS


--
Gail Shaw
SQL Server MVP
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 02/03/2010 :  14:03:46  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

DBA007
Posting Yak Master

India
145 Posts

Posted - 02/03/2010 :  15:48:07  Show Profile  Reply with Quote
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
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 02/03/2010 :  16:27:47  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
DBCC FREEPROCCACHE? Why are you running that?

Is there anything in the SQL error log?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

DBA007
Posting Yak Master

India
145 Posts

Posted - 02/03/2010 :  16:39:18  Show Profile  Reply with Quote
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
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 02/04/2010 :  04:28:02  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000