asked on

Issue with my SQL Server 2005...

I am currently having issues with my SQL Server 2005. I am runnning a Moss 2007 single web server with the databases stored on a seperate server running SQL Server 2005 with SP2. Attached to this question will be the error log files on my server. At first I was recieving this error message 3 days ago and I updated the server with SP2 and the error logs fixed and I had no problems for almost 3 days and then they started coming back. Last time I recieved this error the server crashed ubruptly as time passed. I maybe have 2 days top before the SQL server crashes again, please help!
SQLDUMPER-ERRORLOG.log

ThorSG1

Does the Windows application log have any errors during this time period?

michaelvegamv

ASKER

Yes sir, the windows application log has the error every second the same error log I attached to this question. This has been occuring for the past day and a half. I can not attach all the logs because it si equivalent to about 15 gb of the same log repeatedly every second.

Jim P.

All this is really saying is "Dump is associated with file C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump10000.txt"

Can you pull a chunk of that and post it?

And can you post just one of the error messages in the Event viewer?

Also you may want to add the Blackbox Trace to your SQL as well.

http://technet.microsoft.com/en-us/library/cc293615.aspx

USE master 
GO
CREATE PROCEDURE StartBlackBoxTrace 
AS
/** ref: http://technet.microsoft.com/en-us/library/cc293615.aspx **/
BEGIN
DECLARE @TraceId int
DECLARE @maxfilesize bigint 
SET @maxfilesize = 25 
EXEC sp_trace_create
@TraceId OUTPUT, 
@options = 8, 
@tracefile = NULL,
@maxfilesize = @maxfilesize 
EXEC sp_trace_setstatus @TraceId, 1
END 
GO
---------------------------
EXEC sp_procoption
'StartBlackBoxTrace', 'STARTUP', 'ON'

Open in new window

nmcdermaid

Can you monitor the memory usage of the SQL Server? It is normal for it to climb over time but its not normal for it to crash. You may need to set the max memory configuration of the SQL Server to stop it using loads of memory, especially if your SQL Server has 2G or less RAM (on a 32 bit box)

michaelvegamv

ASKER

SIr, I have here attached to logs from my Moss 2007 Server and the SQL 2005 Server. Each document has them labeled by server so there is no confusion. I was looking over that website that was reffered to me 2 posts uo from this one and I understand the conecpt of a ackbox trace howver I was curious where on the SQL server I would have to go in order to apply the codes to enable the blackbox trace feature, that would be very helpful if possible,k thank you very much for all your help and guidance.
Moss-2007-Server-Event-Viewer-Lo.doc

ASKER CERTIFIED SOLUTION

Jim P.

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial