SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to tuning sql server 2005 memory usage
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

nageswar
Starting Member

India
5 Posts

Posted - 06/27/2008 :  02:28:31  Show Profile  Send nageswar a Yahoo! Message  Reply with Quote
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

India
52317 Posts

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

maninder
Posting Yak Master

USA
100 Posts

Posted - 06/27/2008 :  16:30:32  Show Profile  Send maninder a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 06/27/2008 :  16:35:40  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 06/28/2008 :  00:04:27  Show Profile  Reply with Quote
Better to run apps on separate server.
Go to Top of Page

nageswar
Starting Member

India
5 Posts

Posted - 06/28/2008 :  03:07:00  Show Profile  Send nageswar a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 06/29/2008 :  08:11:00  Show Profile  Reply with Quote
nageshwor,

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

maninder
Posting Yak Master

USA
100 Posts

Posted - 06/29/2008 :  12:29:43  Show Profile  Send maninder a Yahoo! Message  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000