Post reply

URGENT!!!! Locks problem

  • November 18, 2002 at 6:41 am

    #58685

    I´m receivein the following message from an agent:

    Actual state:Critical Prop:"SQL Server Total Locks"

    I must to up the total locks? how can i do that?

  • November 18, 2002 at 7:25 am

    #441615

    I never saw this error before. In general the number of locks in SQLServer is dynamic.

    Here to look at the locks and maybe change it with sp_configure.

    Locks in an advanced option, so first you must set:

    sp_configure 'show advanced options',1

    RECONFIGURE WITH OVERRIDE

    sp_configure 'locks'

    Now you see the number of locks in the column run_value

    If the value is 0, it is dynamic and you should have no problems

    You can change the value with:

    sp_configure 'locks', 0

    RECONFIGURE WITH OVERRIDE

    You have to restart SQLServer after this.

  • November 18, 2002 at 8:09 am

    #441630

    I have come across this kind of problem when I was using the evaluation version,but later when I have switched it to the full version I have not come across that problem.

  • November 18, 2002 at 8:32 am

    #441633

    Thanks for all friends! I can resolve this...

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

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