Post reply

MEMORY utilization fior sqlserver 2008 r2

  • February 23, 2011 at 3:59 am

    #231572

    I have a windows server 2008 R2 64 bit platform with 8 Gb Ram, I installed Sql server 2008 R2 DEv Edition .

    for samll application running from front end SQl server is taking >6GB due to this Deadlocks are happening its production server.

    So how to Allocate the proper memory for sql server 2008 R2

    please suggest.

  • February 23, 2011 at 4:58 am

    #1290300

    What makes you think the deadlocks are due to the amount of memory being used by SQL Server?

    I think you need to look elsewhere (i.e. the SQL being run by your application) for the cause of your deadlocks.

  • February 23, 2011 at 9:50 am

    #1290504

    It is NOT a SQL Server or RAM issue it is a application code or SQL code issue. You will need to research the cause of the deadlocks (i.e., the transactional code that is causing the locking). Also, a review of the wait states will help determine if there are any issues (i.e., memory pressure, CPU, Disk I/O, etc.).

  • February 23, 2011 at 10:07 am

    #1290516

    There are a number of causes of deadlocks, one been poor code...

    Do you have the min/max memory set on sql server?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply