InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 18:19:53 GMT20http://www.sqlservercentral.com/Forums/Topic1397343-146-1.aspxOk, So Memory/pages\secThat's the count of hard page faults (page faults/sec are soft page faults). That's to do with pages that are in virtual memory but not physical memory (ie are in the page file)SQL shouldn't be using the page file at all, unless it's getting paged to disk by the OS, so those will be from apps other than SQL on the box.Tue, 18 Dec 2012 04:28:28 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1397343-146-1.aspxGail if i was a little unclear.Both the paging counters were selected from the 'memory' performance object.Tue, 18 Dec 2012 04:11:15 GMTmjwlufchttp://www.sqlservercentral.com/Forums/Topic1397343-146-1.aspx[quote][b]mjwlufc (12/18/2012)[/b][hr]The memory objects i'm lookin at are pages /sec and page faults/sec[/quote]Which pages/sec? Under which section? There are multiple pages/sec counters in different sections and they mean different things.Since you're using 32 bit SQL, having AWE on is required to access more than 2 GB of memory.Tue, 18 Dec 2012 03:38:51 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1397343-146-1.aspxIt's this version Microsoft SQL Server 2005 - 9.00.5057.00 (Intel X86) Mar 25 2011 13:50:04 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) The VM has 6Gb or RAM with SQL capped at 4GBThe memory objects i'm lookin at are pages /sec and page faults/secpage faults/sec is spiking up to 15000 - seems very high.And advise on improving the situation is much appreciated :-)Tue, 18 Dec 2012 03:33:21 GMTmjwlufchttp://www.sqlservercentral.com/Forums/Topic1397343-146-1.aspx[quote][b]mjwlufc (12/18/2012)[/b][hr]The instance has AWE enabled, is the view this is better to have on than off ?[/quote]32 bit or 64 bit SQL?[quote]Whilst i was in perform i noticed the pages/sec was quite spiky with peaks of around 1500/sec.[/quote]Which pages/sec counter? (there's more than one of them and they mean very, very different things)Tue, 18 Dec 2012 03:21:01 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1397343-146-1.aspxWhilst i was in perform i noticed the pages/sec was quite spiky with peaks of around 1500/sec.Is this on the high side or normal server performance ?Tue, 18 Dec 2012 03:12:57 GMTmjwlufchttp://www.sqlservercentral.com/Forums/Topic1397343-146-1.aspxThanks Gail - it's showing as 4194304 (ie 4Gb) in perfmonThe instance has AWE enabled, is the view this is better to have on than off ?Tue, 18 Dec 2012 02:55:46 GMTmjwlufchttp://www.sqlservercentral.com/Forums/Topic1397343-146-1.aspxPerformance Monitor. Total Server memory counter (it's a SQL counter)Mon, 17 Dec 2012 11:26:39 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1397343-146-1.aspxThanks Gail - what's the recommended way ?Mon, 17 Dec 2012 11:25:32 GMTmjwlufchttp://www.sqlservercentral.com/Forums/Topic1397343-146-1.aspxDon't use Task Manager to check SQL's memory usage. It doesn't report correctly.Mon, 17 Dec 2012 11:23:22 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1397343-146-1.aspxHi,We have a SQL 2005 instance that's the back end DB for our company helpdesk system. Performance of late has been sluggish and upon investigation i've noticed the sqlservr.exe process is only using 125Mb of memory.The server has 6GB and sql is configured to use up to 4GB of that so i'm at a loss why it's not growing past 125Mb ?The process is however clocking a lot of CPU at 50-90%Any ideas ?TIA,MMon, 17 Dec 2012 10:25:57 GMTmjwlufc