SQL Server application error ntdll.dll

Question

SQL Server application error ntdll.dll

Sushant Yadav

SSCrazy

Points: 2780
More actions
October 14, 2015 at 9:16 pm

#312321

Yesterday our live SQL Server 2008 R2 Enterprise Edition (64-bit) instance apparently restarted at 18:35. The SQL Server Error Log does not provide much information, It is only showing the SQL Server service apparently restarting and the databases all starting up.
My Environment: -
Windows Server 2008 R2 (Enterprise ) With 64 GB of RAM
SQL Server 2008 R2 (Enterprise ) with 50 GB max memory assigned
Total DB Size: - 3.3 TB
I am observing following errors in SQL Server error Log.
Could not find database ID 2, name 'tempdb'. The database may be offline. Wait a few minutes and try again.
Windows application error log.
Faulting application name: sqlservr.exe, version: 2009.100.4000.0, time stamp: 0x4fecc5ba
Faulting module name: ntdll.dll, version: 6.1.7601.18229, time stamp: 0x51fb164a
Exception code: 0xc0000374
Fault offset: 0x00000000000c4102
Faulting process id: 0xc943c
Faulting application start time: 0x01d106805d5729f6
Faulting application path: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
Faulting module path: C:\Windows\SYSTEM32tdll.dll
Report Id: dd276500-7273-11e5-ac34-3440b5c6b7ae
Also Observed low page life expectancy at the time of event. PLE value at the time of event was 80.
Any help on this problem is greatly appreciated.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

I'd first start and find out what is going on with the tempdb database. is the disk it is on different than the rest of the databases?

CEWII

Sushant Yadav SSCrazy Points: 2780 More actions · Answer 2

Yes they are on different SAN storage.

Few databases are on EMC SAN storage and TempDB is on NETAPP SAN storage.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

Sushant Yadav (10/15/2015)
Yes they are on different SAN storage.
Few databases are on EMC SAN storage and TempDB is on NETAPP SAN storage.

Since it is reporting problems with the tempdb location I would get your storage engineer involved to make sure that there is not a connection problem or a bad HBA.

CEWII