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.
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.VNew 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 |
|
|
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?/Versiondid 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 |
|
|
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. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-28 : 00:04:27
|
Better to run apps on separate server. |
|
|
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?/Versiondid 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 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-29 : 08:11:00
|
nageshwor, Did you look what we said? |
|
|
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 OVERRIDESp_configureANDSELECT 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 |
|
|
|
|
|
|
|