SQL server performance

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » SQL server performance

SQL server performance

Rate Topic

Display Mode

Topic Options

Author

Message

ramaprasad.rao

Posted Monday, February 09, 2009 9:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 09, 2009 9:34 AM
Points: 1, Visits: 1

In MOSS 2007 server, SQL server exe takes 7.5 GB out of 8 GB, if wee the performance of the computer in Windows task manager => Performance => PF usage, even if there are no web requests to the MOSS server.

Any idea what could be the reason

Post #652917

CrazyMan

Posted Monday, February 09, 2009 9:40 AM

Right there with Babe

Group: General Forum Members
Last Login: Tuesday, September 18, 2012 3:00 PM
Points: 770, Visits: 1,593

What's SQL version is installed on the machine, is there a max memory been set on SQL ???

Post #652948

Steve Jones - SSC Editor

Posted Monday, February 09, 2009 9:46 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:32 AM
Points: 31,433, Visits: 13,747

Once SQL Server has grabbed the memory, which it will do for caching, it tends to hold onto it unless it's needed by other applications. And then it grudgingly lets go.

Is this 32 or 64 bit server? Is it affecting performance? If not, this is normal, and leave it alone.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #652960

Sriram-288748

Posted Monday, February 09, 2009 9:47 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 29, 2013 12:19 AM
Points: 219, Visits: 326

You can get the above details by running the below

USE master
Go
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
Go
EXEC sp_configure 'max server memory (MB)'
GO

Sriram

Post #652964

« Prev Topic | Next Topic »

Permissions