Prev: Sql Server 2000 restore to different db name?
Next: Large log file
From: LAM on 10 Aug 2010 16:43
HI
Under SQLServer2005 Advanced Properties - Parallelism, I need to set Locks
to zero (0) because I suspect that 5000 locks that it shows actualy, have
triggered the following error: "the instance of the sql Server Database
Engine cannot obtain a LOKC resource at this time. Rerun your statement when
there are fewer users...."

I appreciate all your wise suggestions.

LAM




From: Erland Sommarskog on 11 Aug 2010 03:49
LAM (luism0@(arroba)yahoo.es) writes:
> Under SQLServer2005 Advanced Properties - Parallelism, I need to set
> Locks to zero (0) because I suspect that 5000 locks that it shows
> actualy, have triggered the following error: "the instance of the sql
> Server Database Engine cannot obtain a LOKC resource at this time. Rerun
> your statement when there are fewer users...."

EXEC sp_configure 'locks', 0; RECONFIGURE

But I think you are looking in the wrong column; when I run sp_configure
(without parameters), I see 5000 in the locks column.

Then again, that would mean that you have a bigger problem...


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
From: LAM on 11 Aug 2010 12:16
Thanks a lot, after execute this sp and restart the server, all processes
worked fine !

LAM

"Erland Sommarskog" <esquel(a)sommarskog.se> escribi� en el mensaje
news:Xns9DD163DB55D2CYazorman(a)127.0.0.1...
> LAM (luism0@(arroba)yahoo.es) writes:
>> Under SQLServer2005 Advanced Properties - Parallelism, I need to set
>> Locks to zero (0) because I suspect that 5000 locks that it shows
>> actualy, have triggered the following error: "the instance of the sql
>> Server Database Engine cannot obtain a LOKC resource at this time. Rerun
>> your statement when there are fewer users...."
>
> EXEC sp_configure 'locks', 0; RECONFIGURE
>
> But I think you are looking in the wrong column; when I run sp_configure
> (without parameters), I see 5000 in the locks column.
>
> Then again, that would mean that you have a bigger problem...
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


 | 
Pages: 1
Prev: Sql Server 2000 restore to different db name?
Next: Large log file