SQL Server Performance Forum – Threads Archive

Failed Assertion on 200Gb database with SP3a

We have a Dell 6650 server running SQL 2000 Enterprise patched to SP3a and keep getting SQL dumps on a 200Gb database due to index corruptions: SQL Server Assertion: File: &lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />:sql
tdbmsstorengdrsinclude
ecord.inl>, line=1447 Failed Assertion = ‘m_SizeRec > 0 && m_SizeRec <= MAXDATAROW' We have run (and are still running … slowly!) intensive checks of the Dell hardware and have gone through a large number of firmware updates on the Dell to bring it up-to-date. The next stage is to look at SQL and see whether the problem is there. Dell suggested we disable write-caching on the array controller, but this hasn’t made any difference. The usual fix for this error seems to be to install SP3, but we’ve already done that. Does anybody else have any clues as to where to search next ? Many thanks!

Check my response herehttp://www.sqlmag.com/Forums/messageview.cfm?catid=13&threadid=20697&STARTPAGE=1 _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Include with Satya suggestions, to check for hypotheticals indexs and Checkalloc.
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

I have had this very error, on a similarly service-packed server. I have found no solution, so I would be very interested if you get anywhere. It might be worth checking out the recommendations in this article..
http://support.microsoft.com/default.aspx?scid=kb;en-us;826433&Product=sql2k
Tom Pullen
DBA, Oxfam GB

The next phase of testing is to bring the server up with the RAID50 array changed to "no read cache" ….
God knows what this will do to performance, but hey! I’d prefer slower and works that fast and doesn’t I guess. Cheers,
Steve.

BTW, i forgot to say that I have already run a DBCC CHECKDB on the database, which I think already explicitly includes a DBCC CHECKALLOC ? Cheers,
Steve.

How about hypotheticals indexs ?
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

I have the same error , when i restore a Backup into a new Server from a large MDF (20-40 GB) . The database is working , what is the problem. In the original server the Checkdb works Ok and into the other server show the error m_sizerec > 0 .
wThat can i do? Thansk

What is the servicepack level on SQL & check what other points referred above. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

]]>