Fatal exception while executing detail dm view query: sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')

Fatal exception while executing detail dm view query: sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')

Post by Vima » Fri, 02 Jun 2006 23:44:42


hen I am executing query

SELECT OBJECT_NAME(object_ID), * FROM
sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')

WHERE index_ID IN (0,1)

I am getting error below. Anyone knows why I am getting this fatal exception
(it terminates connection)



Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any, should
be discarded.

Msg 0, Level 20, State 0, Line 0

A severe error occurred on the current command. The results, if any, should
be discarded.


2006-06-01 10:39:45.77 Server Error: 17310, Severity: 20, State: 1.
2006-06-01 10:39:45.77 Server A user request from the session with SPID
67 generated a fatal exception. SQL Server is terminating this session.
Contact Product Support Services with the dump produced in the log
directory.
2006-06-01 10:42:31.27 spid72 Using 'dbghelp.dll' version '4.0.5'
2006-06-01 10:42:31.29 spid72 ***Stack Dump being sent to D:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0014.txt
2006-06-01 10:42:31.29 spid72 SqlDumpExceptionHandler: Process 72
generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
2006-06-01 10:42:31.29 spid72 *
*******************************************************************************
2006-06-01 10:42:31.29 spid72 *
2006-06-01 10:42:31.29 spid72 * BEGIN STACK DUMP:
2006-06-01 10:42:31.29 spid72 * 06/01/06 10:42:31 spid 72
2006-06-01 10:42:31.29 spid72 *
2006-06-01 10:42:31.29 spid72 *
2006-06-01 10:42:31.29 spid72 * Exception Address = 0000000001764343
Module(sqlservr+0000000000764343)
2006-06-01 10:42:31.29 spid72 * Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
2006-06-01 10:42:31.29 spid72 * Access Violation occurred reading
address 0000000000000017
2006-06-01 10:42:31.29 spid72 * Input Buffer 288 bytes -
2006-06-01 10:42:31.29 spid72 * SELECT
OBJECT_NAME(object_ID), * FROM sys.dm_db_index_physica
2006-06-01 10:42:31.29 spid72 * l_stats(DB_ID(), NULL, NULL, NULL,
'DETAILED') WHERE index_ID IN (0,1)
2006-06-01 10:42:31.29 spid72 *
2006-06-01 10:42:31.29 spid72 *
2006-06-01 10:42:31.29 spid72 * MODULE BASE
END SIZE
2006-06-01 10:42:31.29 spid72 * sqlservr
0000000001000000 00000000035FBFFF 025fc000
2006-06-01 10:42:31.29 spid72 * ntdll
0000000078EC0000 0000000078FF8FFF 00139000
2006-06-01 10:42:31.29 spid72 * kernel32
0000000078D40000 0000000078EB1FFF 00172000
2006-06-01 10:42:31.29 spid72 * MSVCR80
0000000078130000 00000000781FEFFF 000cf000
2006-06-01 10:42:31.29 spid72 * msvcrt
000007FF7FC00000 000007FF7FC85FFF 00086000
2006-06-01 10:42:31.29 spid72 * MSVCP80
000000007C420000 000000007C530FFF 00111000
2006-06-01 10:42:31.29 spid72 * ADVAPI32
000007FF7FEE0000 000007FF7FFE4FFF 00105000
2006-06-01 10:42:31.29 spid72 * RPCRT4
000007FF7FD30000 000007FF7FED8FFF 001a9000
2006-06-01 10:42:31.29 spid72 * USER32
0000000078C30000 0000000078D3BFFF 0010c000
2006-06-01 10:42:31.29 spid72 * GDI32
000007FF7FC90000 000007FF7FD28FFF 00099000
2006-06-01 10:42:31.29 spid72 * CRYPT32
000007FF7D180000 000007FF7D2DEFFF 0015f000
2006-06-01 10:42:31.29 spid72 * MSASN1
000007FF7D150000 000007FF7D179FFF 0002a000
2006-06-01 10:42:31
 
 
 

Fatal exception while executing detail dm view query: sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')

Post by weil » Sat, 03 Jun 2006 11:55:29

Hi Vimas,

Thank you for your post.

I would like to know some additional information of your Server.

1. What's you SQL Server 2005 Edition? Have you apply the SP1?

2. Does this issue appear when you do other operations?

3. What's your server Operation System?

Please let me know the result so that I can provide further assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 
 
 

Fatal exception while executing detail dm view query: sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')

Post by Vima » Sat, 03 Jun 2006 22:21:16

SQL Server 2005 Enterprise Edition 64bit with SP1
Issue appears when there is no other activity on the server
OS: Windows 2003 EE

I restarted SQL Service and issue went away for now.
 
 
 

Fatal exception while executing detail dm view query: sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')

Post by weil » Tue, 06 Jun 2006 17:28:31

Hi Vimas,

Thank you for the update.

If you still get the error or if you have any questions or concerns, please
feel free to let me know.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.