May 14, 2009 at 3:02 am
Target Server Memory (KB) = 10485760
Total Server Memory (KB) = 10485760
both are same is there memory pressure
May 14, 2009 at 3:05 am
No, SQL Server is behaving exactly as it has been asked to.
The Target Server memory is the amount of memory that SQL Server has been asked to operate to.
The Total Server Memory is the amount of memory which SQL Server is currently utilising.
Make sense?
May 14, 2009 at 4:46 am
john do i required more ram.....
May 14, 2009 at 5:03 am
No way to tell from that information.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 14, 2009 at 5:05 am
samsql (5/14/2009)
john do i required more ram.....
This cannot be determined from the information you have provided alone.
SQL Server is currently using 10GB based on the information provided.
How much memory is there in the server in total?
I reccommend that you consult the following Books Online reference with regard to Monitoring memory usage in SQL Server.
May 14, 2009 at 5:07 am
john 14 GB ram
May 14, 2009 at 5:14 am
samsql (5/14/2009)
john 14 GB ram
What are the max and min memory settings for this instance of SQL Server?
I assume the max has been set to 10GB?
Keep in mind that just because SQL Server is utilising all available memory that it has been allocated, does not indicate that more memory is required.
For example, if you have a relatively large database, it is very likely that all available SQL Server memory will be utilised because the database data pages are being cached in the Buffer Pool, which is of course the intended behaviour.
How big are your databases, roughly in total, on the server?
Why do you think you are experiencing memory pressure? Are you having performance issues?
May 14, 2009 at 5:30 am
max memory set to 10 GB
were as i hav some processes which are slowing down as it utilize all the 10GB.
40 GB database size.
May 14, 2009 at 5:53 am
John
CPU utilization goes upto 85 to 90 % as there are 50 + users accessing the database ....
May 14, 2009 at 11:13 pm
John site says this do this mean i hav to add a memory....
If the Total Server Memory (KB) counter is consistently high compared to the amount of physical memory in the computer, it may indicate that more memory is required.
May 15, 2009 at 12:24 am
samsql (5/14/2009)
John site says this do this mean i hav to add a memory....If the Total Server Memory (KB) counter is consistently high compared to the amount of physical memory in the computer, it may indicate that more memory is required.
Given the size of your databases and current CPU utilisation I am initially inclined to think no. The key word in the sentance above is "may", i.e. this is only one of many possible indicators.
I would concentrate on identifying the specific queries that are consuming the most CPU and then optimising them accordingly. I have seen countless servers with high CPU usage as the result of queries that had not been optimised. A combination of re-writing code and index additions/modifications can have a very significant positive impact.
First steps, identify what is responsible for the CPU utilisation.
May 15, 2009 at 2:51 am
john
there are 1000 procedure and there are 50+ users and there is a blocking .....
wat shud do now ....
May 15, 2009 at 3:04 am
You need to qualify what is consuming the CPU.
If it is indeed SQL Server queries then you need to investigate further in order to identify which specific queries are responsible.
Here is an example of how to use SQL Server Profiler in order to identify slow running queries.
http://www.simple-talk.com/sql/performance/how-to-identify-slow-running-queries-with-sql-profiler/[/url]
You may also wish to consider using the freely available Microsoft Performance Dashboard Reports for SQL Server in order to troubleshoot your server.
May 18, 2009 at 11:16 pm
Like some comment from gail..... and others
there are many cursors and queries and triggers which are running some of them cannot be changed
Memory\Available Bytes
1st - 11080822784
when all the process completes---2811342848 with 16 GB ram what shud i do now...
Viewing 15 posts - 1 through 15 (of 21 total)
You must be logged in to reply to this topic. Login to reply