Count

  • Target Server Memory (KB) = 10485760

    Total Server Memory (KB) = 10485760

    both are same is there memory pressure

  • 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?

  • john do i required more ram.....

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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.

    http://msdn.microsoft.com/en-us/library/ms176018.aspx

  • john 14 GB ram

  • 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?

  • 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.

  • John

    CPU utilization goes upto 85 to 90 % as there are 50 + users accessing the database ....

  • It sounds like you need to carry out a generic performance tuning exercise on your platform.

    Take a look at the Brent Ozar's site for an overview of the steps to follow.

    http://www.brentozar.com/sql-server-performance-tuning/[/url]

  • 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.

  • 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.

  • john

    there are 1000 procedure and there are 50+ users and there is a blocking .....

    wat shud do now ....

  • 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.

    http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

  • 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