RE: Memory issues with Linked Servers
From: Eric Cárdenas [MSFT] (ecardena_at_online.microsoft.com)
Date: 11/29/04
- Next message: Dejan Sarka: "Re: T-sql to restore log files similar to Log shipping"
- Previous message: Uri Dimant: "Re: Bad Directory- DTS - Global Variables"
- In reply to: Mark: "Memory issues with Linked Servers"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Nov 2004 07:31:15 GMT
>
> Hello,
> We are having issues with MSSQL Linked Servers (MS OLE DB Provider for
> Oracle and MS Jet 4.0 OLE DB Provider). The linked servers will just
stop
> working, so we looked at memory issues and tried setting the linked
server to
> Out of Process. That worked for the reading part of the linked server
but
> the writing part still failed. By starting and stopping the Agent
and/or
> the MSDT service, we are able to fix the linked servers.
>
> So we are trying to monitor the MemToLeave (as this is were MSSQL server
> gets memory for its OLE DB providers) to see if it is indeed getting
maxed
> out. We cannot find any monitoring options… is there a way to monitor
just
> the MemToLeave space?
>
>
> We are having connection time outs also. Could this be related to the
> MemToLeave space being exhausted? And because of that MSSQL server
cannot
> create another worker thread for a new connection?
>
> I would like to determine If in fact the MemToLeave space is getting
> exhausted, before I try to fix it with say setting the startup parameter
> –g384 or adding memory (somewhere…).
>
> Any help is much appreciated.
>
> Thank you,
> Mark
--------------------
Checkout this article:
INF: Using DBCC MEMORYSTATUS to Monitor SQL Server Memory Usage
http://support.microsoft.com/?id=271624
Hope this helps,
-- Eric Cárdenas Senior support professional This posting is provided "AS IS" with no warranties, and confers no rights.
- Next message: Dejan Sarka: "Re: T-sql to restore log files similar to Log shipping"
- Previous message: Uri Dimant: "Re: Bad Directory- DTS - Global Variables"
- In reply to: Mark: "Memory issues with Linked Servers"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
