Re: High Paging

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

Date: Fri, 19 Nov 2004 21:17:18 -0500

Lastly, verify the amount of available disk space. 

-- 
Todd J Heron, MCSE
Windows Server 2003/2000/NT
"Todd J Heron" <todd_heron_no_spam@hotmail.com> wrote in message 
news:ePlDECqzEHA.2624@TK2MSFTNGP11.phx.gbl...
> 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: Clustering Question
    ... SQL Express can't work in cluster, you need at least the Standard edition. ... So if I understand you correctly one computer will need Windows Server ...
    (microsoft.public.windows.server.clustering)
  • Re: Clustering Question
    ... The SQL Cluster would need to be ... SQL will need to Enterprise as well. ... So if I understand you correctly one computer will need Windows Server ...
    (microsoft.public.windows.server.clustering)
  • Re: Moving SQL Server 7.0 database to SQL Server 2000
    ... your application running on SQL 2000 before you do the upgrade. ... For your replication questions the microsoft.public.sqlserver.replication ... "Replication and Upgrading" ... "Replication Between Different Versions of SQL Server" ...
    (microsoft.public.sqlserver.setup)
  • Re: Upgrading SBS 2003 Premium SP1 to R2
    ... upgrading to R2 and not for an explanation on what SQL 2005 Work Group ... Workgroup edition for the new quad CPU server. ... to create the database from the old solution, then mark them as SQL 2000 ...
    (microsoft.public.windows.server.sbs)
  • Re: The server principal "dhtest" is not able to access the database "dhtest2" under the current sec
    ... The server principal "dhtest" is not able to access the database ... (Microsoft SQL Server, ... installed on one server running Windows Server 2008 x64. ...
    (microsoft.public.sqlserver.security)
Loading