I am troubleshooting errors on SQL Server version 9.00.5000.00
This comes with a number of clues that I'll try to be clear with.
1) Recently sp_SendMail has stopped working as expected. Specifically, it will send an email unless we give it a query to append to the body. The result is a hung session (query) that cannot be cancelled. There also is a minidump occuring about the same time - I'll paste some the text below.
2) Cannot access Error logs in SSMS, both version 2005 and 2008R2 doesn't do anything except an hourglass for a little while.
3) Cannot access SQL DBA Dashboard reports (runs some CLR routines)
Aside from simply rebooting the server this evening, can anyone offer advise on what to look for?
MemoryLoad = 91%
Total Physical = 4094 MB
Available Physical = 335 MB
Total Page File = 5973 MB
Available Page File = 2119 MB
Total Virtual = 2047 MB
Available Virtual = 47 MB
***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0004.txt
SqlDumpExceptionHandler: Process 222 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
* BEGIN STACK DUMP:
* 11/28/11 08:30:36 spid 222
* Exception Address = 7C82C6E6 Module(ntdll+0002C6E6)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000004
* Input Buffer 510 bytes -
* DECLARE @MSG VARCHAR(255) DECLARE @mySubjectLine varChar(200
* ) DECLARE @mySubject varChar(255) DECLARE @myQuery varchar(max) --D
* ECLARE @MAILTO VARCHAR(500) --SET @MAILTO = 'firstname.lastname@example.org;xxx@
* xxx.org;email@example.com' EXEC CLIENT_KS.DBO.sp_Lytec_BadSSN_view IF @@R
* OWCOUNT > 0 BEGIN SET @MSG = 'Below are clients whose social secur
* ity numbers do not match between the Lytec system and CMS as of '
* + CONVERT(VARCHAR(20),GETDATE(),101) + char(13) + char(13) SET @mySu
* bjectLine='xxx BEHAVIORAL HEALTHCARE: Mis-matched SSNs' SET @mySubjec
* t = @mySubjectLine SET @myQuery = 'CLIENT_KS.DBO.sp_Lytec_BadSSN_view
* ' EXEC appSecurity.SafeSend.sp_SendMail_Static @rptSubjectLine =
* @mySubjectLine, @strSubject = @mySubject, @strBody = @MSG,
* @Qry = @myQuery --EXEC msdb.dbo.sp_send_dbmail -- @profile_nam
* e = 'ASDMail', -- @recipients = @MAILTO , -- @copy_recipients = '
* firstname.lastname@example.org;email@example.com', -- @query = 'CLIENT_KS.DBO.s
* p_Lytec_BadSSN_view', -- @subject = 'xxx BEHAVIORAL HEALTHCARE: Mis-m
* atched SSNs', -- @body = @MSG END
* MODULE BASE END SIZE
* sqlservr 01000000 02C26FFF 01c27000
* ntdll 7C800000 7C8C2FFF 000c3000
Thanks in advance,
I would suggest you install the latest Cumulative Update and see if the problem is already resolved.
Problem signature:Problem Event Name: BEXApplication Name: CivilizationV.exeApplication Version: 18.104.22.168Application Timestamp: 4c9b9294Fault Module Name: StackHash_a940Fault Module Version: 0.0.0.0Fault Module Timestamp: 00000000Exception Offset: 00000000Exception Code: c0000005Exception Data: 00000008OS Version: 6.0.6002.2.2.0.768.3Locale ID: 1033Additional Information 1: a940Additional Information 2: dcf2f0e87615fe015374b77f51d2b897Additional Information 3: b9f6Additional Information 4: 07541c74c3b0b7da05ec73a24541e5b3I went threw alot of trouble shooting from some of the member here at 2K that keeps telling me it had to do with out of date drivers for a video card or sound card.These 2 driver would not affect the CPU and make it stake up shut down the program.They keep looking at the Exception Code: c0000005 and was not looking at the BEX. BEX was the key to causing my problem.Often BEX errors are caused by Toolbars such as Google, TrendMicroand others. Are you using any 3rd party toolbars in IE? Cause and fix is same for Vista and Windows 7.What antivirus/antispyware/security product do you have on machine?Include any you have EVER had on this machine including those youuninstalled (they leave remnants behind which causes issues).Start - All Programs - Accessories - System Tools - IE with no Add-onsdoes this work better?IE - Tools - Internet Options - Advanced Tab - click Restore Advanced Settings and then click RESET - APPLY / OKIE - Tools - Internet Options - Security Tab - click Reset all zones -APPLY / OKClose and restart IE and/or IE with no addonsStart - All Programs - Accessories - System Tools - IE with no Addons -does this work better?IE - Tools - Manage Addons (for sure disable SSV2 if it is there, thisis no longer needed but Java still installs it and it causes issues - you ever update Java go back in and disable it again.) Look for other possible problems.Windows Defender - Tools - Software Explorer - look for issues with programs that do not look right. Permitted are usually OK and "not permitted" are not always bad.I think these are some related issue which can cause of this problem.
Sorry I have been so tardy with the reply. Your sugestion has great merit however the our IT dept avoids updates like the plague (let's not argue about it, I've been blue in the face enought about it).
I can't remember what I did to fix otherwise I let you-all know.