995 error reported in the SQL Server event log
to track memtoleave...
FIRST, create the following table:
CREATE TABLE [dbo].[MemToLeave](
[CONTIGUOUSSIZE] [int] NULL,
[RecordId] [int] IDENTITY(1,1) NOT NULL,
[RecordDate] [datetime] NOT NULL CONSTRAINT [DF_MemToLeave_RecordDate] DEFAULT (getdate())
) ON [PRIMARY]
THEN, create a job with the following:
declare @tmp_select char(500)
set @tmp_select = 'execute master.dbo.xp_memory_size'
INSERT INTO MemToLeave (CONTIGUOUSSIZE)
exec(@tmp_select)
This should assist in seeing what parameters (-g switch for example) might work best in your setup.
