Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL server performance Expand / Collapse
Author
Message
Posted Monday, February 9, 2009 9:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 9, 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
Posted Monday, February 9, 2009 9:40 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, July 3, 2014 10:20 AM
Points: 770, Visits: 1,596
What's SQL version is installed on the machine, is there a max memory been set on SQL ???
Post #652948
Posted Monday, February 9, 2009 9:46 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:08 PM
Points: 33,099, Visits: 15,206
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
Posted Monday, February 9, 2009 9:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, June 20, 2013 2:04 AM
Points: 222, Visits: 331
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 »

Add to briefcase

Permissions Expand / Collapse