How to analyze stack dumps
-
Given the following statements
* BEGIN STACK DUMP:
* 10/06/06 09:15:58 spid 82
*
* Exception Address = 00402453 (RecBase::Resize(void) + 00000004 Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
* Input Buffer 68 bytes -
* exec sp_MSdbuseraccess N'db', N'%'
Does it means that the accesss violation was caused because of the instruction on the input buffer? In this case because the spid 82 didn't have the right privileges to run the instruction showed after the input buffer line above?
Is there any to find out which login account/windows account had the spid82 assigned at the time of the dump, after the fact, menaing hours or day(s) later?
Is there any parameter in SQL server to have more detail information of the spid within the dump?
Dumps files have being removed from the server, but will like to be prepared in case this happen again.
-
This was removed by the editor as SPAM
-
An access violation means that SQL Server tried to access an area of memory that it was not allowed to access (hence, "access violation"). This is typically due to a bug in SQL Server's code, unless you're using an extended stored procedure. It has nothing to do with SQL Server permissions.
You see that there was an attempt to read memory address 0 - this is an invalid address, and means there's a bug involved.
-
-- returns 1925
SELECT
[Days Since Previous Post] =
DATEDIFF(DAY, 'October 20, 2006', GETDATE());
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply