| John Bell 2006-10-25, 6:00 am |
| Hi
This looks like
http://connect.microsoft.com/SQLSer...edbackID=126192
which says it will be fixed in SP2. If you want to see if a workaround is
available from PSS you may want to call them
http://support.microsoft.com/defaul...S;offerprophone
John
"Jerome" wrote:
> Hi,
>
> we have installed a new server to replace an existing one.
> the old server suffer an issue, sometimes the server "loose" its memory.
> for example, I'm loading the database using SSIS, SQL Server consume near
> all memory available (16Gb)
> and withtout any reason, the memory used by SQL (and all other applications)
> is dropped to few Kb.
> and then the server start reading the memory from the swap file (which is a
> slow and long process)
>
> we think that there is a physical memory problem.
>
> we have changed the server...
> but the new one suffer the same issue!!!!
>
> do you know what's appends???
>
> I'm using x64 version (both windows and sql)
>
> thanks.
>
> Jerome.
>
>
|