Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to tuning sql server 2005 memory usage

Author  Topic 

nageswar
Starting Member

5 Posts

Posted - 2008-06-27 : 02:28:31
hi friends,

I am using sql server 2005 database, so i have some problem,My application will be hanging beacause In the memory usage of sql server more than 2 GB , so i want to How to tuning sql server 2005 memory usage....can u help me any one

---
Thanks,
Nageswar.V
New Horizons Cybersoft Ltd
+919848854114 : nageswar@nhclindia.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-27 : 02:37:50
http://support.microsoft.com/kb/907877
Go to Top of Page

maninder
Posting Yak Master

100 Posts

Posted - 2008-06-27 : 16:30:32
did you upgrade the Database from Previous version?
What is you SQL Server Edition?/Version
did you apply all the patches to SQL Server?
how many Processors?
how much memory does the server have?
There can be many reasons for your application Hang..
What kind of Queries is it running against the Database.
did you run the Queries in the Query analyzer and chekc to see if they are slow.
How many Results is the Query supposed to Give ?
What is this Applicaiton?

Maninder
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-27 : 16:35:40
Looks like you have apps running as same server as SQL Server. Put max memory setting for SQL server so other apps can use it.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-28 : 00:04:27
Better to run apps on separate server.
Go to Top of Page

nageswar
Starting Member

5 Posts

Posted - 2008-06-28 : 03:07:00
quote:
Originally posted by maninder

did you upgrade the Database from Previous version?
What is you SQL Server Edition?/Version
did you apply all the patches to SQL Server?
how many Processors?
how much memory does the server have?
There can be many reasons for your application Hang..
What kind of Queries is it running against the Database.
did you run the Queries in the Query analyzer and chekc to see if they are slow.
How many Results is the Query supposed to Give ?
What is this Applicaiton?


hi maninder,

First Thank u for ur reply my query, ok i am using SQL server 2005 SP2 vewrsion, and using SAPB1 2005B Application and only one Processor, 256 GB Hard Disk , 4 GB RAM and in my SAP users are 25 users.






Maninder



---
Thanks,
Nageswar.V
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-29 : 08:11:00
nageshwor,

Did you look what we said?
Go to Top of Page

maninder
Posting Yak Master

100 Posts

Posted - 2008-06-29 : 12:29:43
Can you answer the Question from sodeep and Which edition is this Developer/Standard/Express/Ent.
Also Can you Post the results of the following:
sp_configure 'Show Advanced options','1'
RECONFIGURE WITH OVERRIDE
Sp_configure
AND
SELECT CONVERT(char(20), SERVERPROPERTY('BuildClrVersion')) as BuildClrVersion;
SELECT CONVERT(char(20), SERVERPROPERTY('Collation')) as Collation;
SELECT CONVERT(char(20), SERVERPROPERTY('ComputerNamePhysicalNetBIOS'));
SELECT CONVERT(char(20), SERVERPROPERTY('Edition')) as Edition;
SELECT CONVERT(char(20), SERVERPROPERTY('EngineEdition')) as EngineEdition;
SELECT CONVERT(char(20), SERVERPROPERTY('IsClustered')) as IsClustered;
SELECT CONVERT(char(20), SERVERPROPERTY('IsFullTextInstalled')) as IsFullTextInstalled;
SELECT CONVERT(char(20), SERVERPROPERTY('IsIntegratedSecurityOnly')) as IsIntegratedSecurityOnly;
SELECT CONVERT(char(20), SERVERPROPERTY('IsSingleUser')) as IsSingleUser;
SELECT CONVERT(char(20), SERVERPROPERTY('ProductVersion')) as ProductVersion;
SELECT CONVERT(char(20), SERVERPROPERTY('ProductLevel')) as ProductLevel;

Maninder
Go to Top of Page
   

- Advertisement -