Can anyone provide help regarding recbase.cpp , record.inl assertion error
New cluster system, W2K3 Datacenter, SQL2000+SP3a, IBM x445 Two-way SMP (16CPU,64GB), EMC Symmetrix DMX800
Two instances of SQL Server...
Keep getting assertion error on named instance wich uses MSDTC(msdtc working correctly), no matter on which node is running and no matter how much memory or processor number assigned
SQLDump contains INSERT , UPDATE and SELECT statements that caused this error, everytime different....????
DBCC CHECKDB sometime reports errors sometimes not...?????
Databases are on phisically same disks/hypers....anyone who knows DMX will understan

Rgds

Open a case with PSS.

--

Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

We had same problem on same configuration (on name instance
It is not SQL proble
Problem is probably in IBM memor

If you have two instance of sql server, one of them can use maximum 30GB (our opinion)
Just in case , we decreased amount of memory that name instance use (from 30 to 16Gb , 8CPU - for test
Memory size we increased when we got a little bit stability (after DBCC CHECKDB)
Allocation database files isn't important for this problem but it's VERY important for performance
Regard