Re: High Paging

From: Todd J Heron (todd_heron_no_spam_at_hotmail.com)
Date: 11/20/04 

Date: Fri, 19 Nov 2004 20:30:19 -0500

You've done a lot with this system, upgrading the SQL database and the OS
and you've given very little information. In short, who can know what going
on? Open up System Monitor and start doing some performance logging. The
Task Manager values are going to change dynamically and not give you an
accurate picture when you try to manually add them up. I suggest you read
up on the SQL Server 2000 and SAP R/3 installation and Help documentation
and search google on issues of upgrading from previous versions of those
softwares, especially to the sections concomitant with OS upgrade. 

-- 
Todd J Heron, MCSE
Windows Server 2003/2000/NT
"Justin Emlay" <JEmlay@NoSpam.com> wrote in message 
news:eHlj74ozEHA.1292@TK2MSFTNGP10.phx.gbl...
> Nope, none.
>
> Also I don't understand why in my task manager it says I have 1.2GB of 
> memory free from 3.8GB and when I add all the processes memory usage up I 
> get way over 5GB of memory used.  Are they including swap space?
>
>
> "Todd J Heron" <todd_heron_no_spam@hotmail.com> wrote in message 
> news:u1CDc0ozEHA.4004@tk2msftngp13.phx.gbl...
>> Is there an active virus scan or some sort of system backup running at 
>> the time of high paging?
>>
>> -- 
>> Todd J Heron, MCSE
>> Windows Server 2003/2000/NT
>>
>> "Justin Emlay" <JEmlay@NoSpam.com> wrote in message 
>> news:eX%23zgbozEHA.2196@TK2MSFTNGP14.phx.gbl...
>>> Windows 2003 Server
>>>
>>> This server is running SQL 2000 and SAP R/3
>>>
>>> I had no problem when the server was SQL 7 and Windows 2000.  However 
>>> after upgrading to SQL 2000 and Windows 2003 the machine has a high rate 
>>> of paging.
>>>
>>> This is of course causing SQL to run very slow.  I'm not quit sure 
>>> what's going on.  The machine has 1GB of free memory yet the processes 
>>> keep paging. The machine has a total of 4GB of memory and just over 14GB 
>>> of virtual.
>>>
>>> Can anyone point me in the right direction?
>>>
>>> Thanks,
>>> Justin
>>>
>>
>>
>
>

Relevant Pages

  • Re: Performance problems -- need guidance on scaling
    ... Thanks for the update on the FT Catalog corruption, ... will use, up to a max of 512Mb, if this memory is available. ... a server with 512 MB of RAM and a resource_usage value of 5 ... the data, you could, detach your SQL 2000 mdf & ldf files ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Memory Issues
    ... Exchange and SQL Server. ... you identified memory problems and large amounts of paging. ...
    (microsoft.public.sqlserver.setup)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 Clust
    ... The Paging File usage is due to how the large memory allocation APIs work. ... Swap files for SQL do not need to be more than about 2-4 GB regardless of physical memory on the box. ... If you use Performance Monitor to track actual paging activity, you will see very little on a properly tuned SQL Server. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... Manager nusance has been around, and yet they somehow could never find time ... counter Total Server Mmeory shows 18GB. ... due to how the large memory allocation APIs work. ... Swap files for SQL do not need to be more than about 2-4 GB ...
    (microsoft.public.sqlserver.clustering)
  • Re: Allocating more memory to sql server
    ... Are you sure you have Windows 2000 Advanced Server and not just Server? ... SQL Server. ... memory used by SQL Server that will give a better idea of the actual usage. ... You also need to restart SQL Server after enabling AWE for it to take ...
    (microsoft.public.sqlserver.setup)
Loading