Categories

Main
Database
Java
Microsoft.NET
Adabas
DB2
Informix
Microsoft SQL Server
MySQL
Oracle
Pervasive.SQL
PostgreSQL
Sybase
Other
ASP
ColdFusion
Crystal Reports
Delphi, C etc
JAVA
Microsoft.NET
Perl and the DBI
PHP
ANSI SQL
Unix Shell Scripts
Visual Basic
XML & XSLT
Corel Paradox
FileMaker
Microsoft Access
Microsoft Excel
Other PC Databases
Applications & Tools
Database Concepts & Design
EJB programming & troubleshooting
EJB design
General J2EE
XML & Web services
Web tier: servlets, JSP, Web frameworks
Performance and scalability
Industry news
TSS feedback
Mobicents Contributors
Mobicents Users
JSLEE Resource Adaptor Types
Planning JavaOne 2008
Sun Tech Days
Other Java conferences
Binary Web Services and XML
Metro and JAXB
GlassFish
GlassFish Plugins
Project jMaki
GlassFish WebTier
Mural
Java Development Tools
Java WS & XML Community News
JAXP
Java SE
6uN Early Access
Java Quick Starter
Java SE Snapshots: Project Feedback
JCK Forum
Feedback and Suggestions
JDK Distros
JDK Open Source
General JSR Discussion
JCP 2.6
JXTA Community Forum
ME Interest
ME Cool Apps
ME General Help
ME Feedback & Suggestions
ME Application Developer Interest
Blu-ray Disc Java
ME Developer Days
Squawk
Mobile Developer Alliance
OpenCable
LWUIT
JavaFX Script Language Discussion
OpenJFX General Discussion
Scene Graph
General Performance Discussion
Your Java Career
NetBeans 6.0
Servlets
JSP
JSF
Portals and Portlets
EJB and Other Java EE Technologies
Distributed Java
Object Relational Mapping
JDBC
Web Services
Swing / AWT / SWT / JFace
JNLP and Web Start
Java Micro Edition
Sockets and Internet Protocols
Threads and Synchronization
Performance
Applets
I/O and Streams
Other Java APIs
Game Development
Java in General (beginner)
Java in General (intermediate)
Java in General (advanced)
Programmer Certification (SCJP)
Developer Certification (SCJD)
Associate Certification (SCJA)
Web Component Certification (SCWCD)
EJB Certification (SCBCD)
Mobile Application Certification (SCMAD)
Architect Certification (SCEA)
Web Services Certification (SCDJWS)
XML Certification
Product and Other Certifications
Mock Exam Errata
Sun Certification Results
Authors' Corral
Book Reviews
Events
Bunkhouse Porch
Teachers' Lounge
Testing
OO, Patterns, UML and Refactoring
IDEs, Version Control and other tools
Ant, Maven and Other Build Tools
Linux / UNIX
Mac OS
HTML and JavaScript
XML and Related Technologies
Agile and Other Processes
General Computing
Security
Groovy
Scala
Other Languages
Struts
Application Frameworks
Other Open Source Projects
BEA/Weblogic
IBM/Websphere
Oracle/OAS
Apache/Tomcat
JBoss
Other Java Products and Servers
JavaRanch
Cattle Drive (java college)
Moderators Only
Trash Can
Jobs Offered
Jobs Wanted
Jobs Discussion
Meaningless Drivel
Programming Diversions
Blatant Advertising
Java Announcements
New To Java
Advanced Java
Java Applets
Networking
Threads and Synchronization
Java 2D
AWT / Swing
SWT / JFace
CLDC and MIDP
CDC and Personal Profile
Sun Java Wireless Toolkit
Enterprise JavaBeans
JavaServer Pages (JSP) and JSTL
Java Servlet
JavaServer Faces
Web Frameworks
Database
XML
Lucene
NetBeans
Eclipse
IntelliJ IDEA
JCreator
Other IDEs
Java Tutorials
Java Tips
Jobs Discussion
Jobs Offered
Jobs Wanted
Professional Certification
Forum Lobby
Java Blogs
Introductions
Reviews / Advertising
Suggestions & Feedback

Resources

Java Database
Linux
Coding
Mobile
Hardware
Software Development
Software Development
iOS,OS X
iOS,OS X
ORACLE
IBM DEVELOPER
IBM DEVELOPER
MSDN
MSDN


Tags

Microsoft SQL Server

SQL Server is Microsoft's entry to the database server market. SQL Server is very easy to manage and comes with a built in OLAP engine. It has good support for web enabled applications and other Microsft products. SQL Server only runs on the Windows platform.

c0000005 EXCEPTION_ACCESS_VIOLATION


We have SQL Server 2000 with SP3 installed on Windows 2000 Advance Server. Server has 8 GB RAM and 4 CPU. Few days back we have installed multiple named instance on this server .Now we have assign each CPU to individual instance and min server memory to 1024 and max server memory is kept open.

After this we are facing an issue with default instance for exception_access_violation as below ... 
Memory                    
MemoryLoad = 83%          
Total Physical = 7679 MB   
Available Physical = 1252 MB                        
Total Page File = 15480 MB 
Available Page File = 7756 MB                       
Total Virtual = 2047 MB    
Available Virtual = 344 MB                          
                           
*Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDu
mp0022.txt                                                                     
* **************************************************  ***************************
**                                                                             
*                                                                              
* BEGIN STACK DUMP:                                                            
*   07/24/07 00:46:02 spid 16                                                  
*                                                                              
*   Exception Address = 008405D8 (DeadlockMonitor::ResolveDeadlock + 00000025 L
ine 0+00000000)                                                                
*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION                    
*   Access Violation occurred reading address 00000000                         
*                                                                              
*                                                                              
*  MODULE                          BASE      END       SIZE                    
* sqlservr                       00400000  00B2CFFF  0072d000                  
* ntdll                          77F80000  77FFCFFF  0007d000                  
* KERNEL32                       7C570000  7C627FFF  000b8000                  
* ADVAPI32                       7C2D0000  7C331FFF  00062000                  
* RPCRT4                         77D30000  77D9EFFF  0006f000                  
* USER32                         77E10000  77E74FFF  00065000                  
* GDI32                          77F40000  77F7DFFF  0003e000                  
* OPENDS60                       41060000  41065FFF  00006000                  
* MSVCRT                         78000000  78044FFF  00045000                  
* UMS                            41070000  4107CFFF  0000d000                  
* SQLSORT                        42AE0000  42B6FFFF  00090000                  
* MSVCIRT                        780A0000  780B1FFF  00012000                  
* sqlevn70                       41080000  41086FFF  00007000                  
* NETAPI32                       028D0000  0291FFFF  00050000                  
* Secur32                        02920000  0292EFFF  0000f000                  
* NTDSAPI                        02930000  02940FFF  00011000                  
* DNSAPI                         02950000  02973FFF  00024000                  
* WSOCK32                        02980000  02987FFF  00008000                  
* WS2_32                         02990000  029A3FFF  00014000                  
* WS2HELP                        029B0000  029B7FFF  00008000                  
* WLDAP32                        029C0000  029E9FFF  0002a000                  
* NETRAP                         029F0000  029F5FFF  00006000                  
* SAMLIB                         02A00000  02A0EFFF  0000f000                  
* ole32                          02D70000  02E5EFFF  000ef000                  
* XOLEHLP                        02E60000  02E67FFF  00008000                  
* MSDTCPRX                       02E70000  02F2AFFF  000bb000                  
* MTXCLU                         02F30000  02F3FFFF  00010000                  
* VERSION                        02F40000  02F46FFF  00007000                  
* LZ32                           02F50000  02F55FFF  00006000                  
* CLUSAPI                        02F60000  02F6FFFF  00010000                  
* RESUTILS                       02F70000  02F7CFFF  0000d000                  
* USERENV                        02F80000  02FE0FFF  00061000                  
* rnr20                          02FF0000  02FFBFFF  0000c000                  
* iphlpapi                       03040000  03052FFF  00013000                  
* ICMP                           03060000  03064FFF  00005000                  
* MPRAPI                         03070000  03086FFF  00017000                  
* OLEAUT32                       03090000  0312AFFF  0009b000                  
* ACTIVEDS                       03130000  0315EFFF  0002f000                  
* ADSLDPC                        03160000  03182FFF  00023000                  
* RTUTILS                        03190000  0319DFFF  0000e000                  
* SETUPAPI                       031A0000  0322DFFF  0008e000                  
* RASAPI32                       03230000  03262FFF  00033000                  
* RASMAN                         03270000  03280FFF  00011000                  
* TAPI32                         03290000  032B1FFF  00022000                  
* COMCTL32                       032C0000  03343FFF  00084000                  
* SHLWAPI                        03350000  033B5FFF  00066000                  
* DHCPCSVC                       033C0000  033D8FFF  00019000                  
* winrnr                         03880000  03887FFF  00008000                  
* rasadhlp                       03890000  03894FFF  00005000                  
* SSNETLIB                       04040000  04054FFF  00015000                  
* SSNMPN70                       04090000  04095FFF  00006000                  
* security                       043B0000  043B3FFF  00004000                  
* msafd                          04850000  0486DFFF  0001e000                  
* wshtcpip                       048B0000  048B6FFF  00007000                  
* SSmsLPCn                       04940000  04946FFF  00007000                  
* mswsock                        049D0000  049E1FFF  00012000                  
* msv1_0                         04A30000  04A50FFF  00021000                  
* CRYPT32                        04A60000  04AE6FFF  00087000                  
* MSASN1                         04B10000  04B1FFFF  00010000                  
* rsabase                        04F40000  04F62FFF  00023000                  
* CLBCATQ                        05280000  0530EFFF  0008f000                  
* SQLOLEDB                       05310000  05382FFF  00073000                  
* MSDART                         05390000  053AEFFF  0001f000                  
* comdlg32                       053B0000  053EDFFF  0003e000                  
* SHELL32                        053F0000  05635FFF  00246000                  
* MSDATL3                        05640000  05654FFF  00015000                  
* oledb32                        05CE0000  05D45FFF  00066000                  
* OLEDB32R                       05D50000  05D5FFFF  00010000                  
* xpstar                         05DE0000  05E26FFF  00047000                  
* SQLRESLD                       05E30000  05E36FFF  00007000                  
* SQLSVC                         05E40000  05E56FFF  00017000                  
* ODBC32                         05E60000  05E91FFF  00032000                  
* odbcbcp                        05EA0000  05EA5FFF  00006000                  
* W95SCM                         05EB0000  05EBBFFF  0000c000                  
* SQLUNIRL                       10000000  1002CFFF  0002d000                  
* WINSPOOL                       05EC0000  05EDDFFF  0001e000                  
* MPR                            05EE0000  05EEFFFF  00010000                  
* SHFOLDER                       05EF0000  05EF7FFF  00008000                  
* odbcint                        061C0000  061D5FFF  00016000                  
* NDDEAPI                        061E0000  061E6FFF  00007000                  
* SQLSVC                         061F0000  061F5FFF  00006000                  
* xpstar                         06200000  06208FFF  00009000                  
* xplog70                        06AA0000  06AB1FFF  00012000                  
* xplog70                        06AC0000  06AC3FFF  00004000                  
* xpsqlbot                       06AD0000  06AD5FFF  00006000                  
* SQLFTQRY                       09200000  09231FFF  00032000                  
* impprov                        094E0000  094F8FFF  00019000                  
* DBNETLIB                       09A80000  09A8EFFF  0000f000                  
* SQLOLEDB                       09BD0000  09BDEFFF  0000f000                  
* sqlvdi                         09C20000  09C2BFFF  0000c000                  
* dbghelp                        07BE0000  07C94FFF  000b5000                  
*                                                                              
                                                                 
Any idea ?

Can you install SP4?  this KB seems to indicate this is fixed in SP4: http://support.microsoft.com/kb/8217...=2852&sid=1070

What's in the SQL Server log file just before the dump?

Is there any workaround other than upgrading to SP4. as SQL Server crashing daily twise and SP4 upgrade testing will take atleast a week time.

I don't have a workaround for you, sorry.  Maybe PSS could suggest one if you call them.

As suggested only MS PSS can give more idea why the stack dump is created. It is better to proceed that way to resolve this issue and also SP3 for SQL2000 is no more supported, you have to test and upgrade to SP4 for SQL.


Related Links

Table Variables
Nested Set Model: Excluding Branches...
Getting a variable to display result in querry analyzer
SQL2000 - Suspect database
Error while installing SQL2k sp3 (on Win2k Server) - First Post
Encryption at the database field level
MSDE Install Failure - Unable to Configure Server
How can I get the ProcessID of a give stored procedure call?
Encryption at the database Field Level
VB script & Xml help
Simple SQL Query??
MSDE Install Fails On Windows XP Home
Problem with Excel 2000 and OLAP
Expand disk for cluster
Setting "Importance" for email using xp_sendmail?
please help -- 512 error when generating replication script