Re: Massive Page File

From: AnthonyThomas (Anthony.Thomas_at_CommerceBank.com)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 08:04:33 -0600

Are you just looking at the page file counters? How do you know it is the SQL Server that is using it?

I'd like to use the Process counters, then select the individual process I'm interested in, sqlservr in this case. I'd look at some others to see which process is responsible for the paging operations.

If your SQL Server Buffer Pool Cache Hit Ratio is high, you might be having some contention with the Proc Cache Hit Ratio. This could be a memory issue or your applications are not properly reusing T-SQL, i.e., all ad hoc queries, few stored procedures, missed auto-parameterization queries...Cache Hit misses.

Sincerely,


Anthony Thomas


--
 
  "Gary" <admin@wolverely.worcs.sch.uk> wrote in message news:8DA840A1-221B-40B2-A0A0-6F6B572CD6EC@microsoft.com...
  Thanks for your reply...
  Yes the Buffer Cache is at 100%
  What can I do??



  "Mark Allison" wrote:

> Gary,
>
> SQL Server doesn't use the page file. Also, the latest version of SQL
> Server is 2000. SQL Server 2005 will be released in 2005 (surprise!). It
> sounds like you may have a memory contention problem on your server.
> What other things do you have running? How much memory do you have, is
> SQL server's buffer cache hit ratio at or near 100%?
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> Gary wrote:
> > I have a 8Meg data base but SQL2003 is hitting the paging file alot.
> > According to my Performance monitor the PF usage is up tp 1.9 Gig!! is this
> > correct. When I restart the server the PF also resets but then the PF goes up
> > again.......??
> >
> > Is all this normal or have I missed something??
> >
>

Relevant Pages

  • Re: jobs for a linked server in a different domain?
    ... Agent uses, then run the query. ... Mark Allison, SQL Server MVP ... Looking for a SQL Server replication book? ... Chieko Kuroda wrote: ...
    (microsoft.public.sqlserver.server)
  • Re: Very simple problem (does not exist in the class or namespace)
    ... Thanks Glenn and Morten! ... Mark Allison, SQL Server MVP ... Looking for a SQL Server replication book? ... > Put 'string connectionString = string.Empty;' prior to the if statement. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Table error
    ... Can you run DBCC CHECKDB regularly as part of routine maintenance? ... Mark Allison, SQL Server MVP ... Looking for a SQL Server replication book? ... Morgan wrote: ...
    (microsoft.public.sqlserver.server)
  • Re: sqlagentcmdexec
    ... > presume you have a brute force cracker? ... your tool will crack any ... > Mark Allison, SQL Server MVP ... > Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.security)
  • Re: SQL and RAID - best way to set it all up?
    ... Columnist, SQL Server Professional ... I have only ever seen two disks die in the same RAID ... array only once in the last eight years or so. ... Mark Allison, SQL Server MVP ...
    (microsoft.public.sqlserver.server)