Question:
ask hardware vendor about error 1204 - my laptop keeps crashing and i get that message when i reboot? help??
1970-01-01 00:00:00 UTC
ask hardware vendor about error 1204 - my laptop keeps crashing and i get that message when i reboot? help??
Four answers:
nobodyz777
2007-06-26 02:15:03 UTC
You didn't mention whether or not you are using a wireless connection. I think that is important.



The answer to your specific error code can be found here:

http://tinylink.com/?gotJE1bZZu



(Or copy and paste the following address into your address bar in your browser: http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/24742;pt=24673/*)



I also must assume that you have access to the answer to this question regardless of the error 1204 you're getting and therefore you can go to the above link.



If this doesn't answer your question, I suggest you go to

google.com and type in "error 1204" exactly like that, quotation marks and all. You will get about 700 different

links related in some way to that search.



Good luck!
Question
2007-06-26 02:18:20 UTC
Error 1204

Severity



19



Error message text

SQL Server has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS.



Explanation

This error occurs when Adaptive Server runs out of locks . The number of locks available is controlled by the Adaptive Server configuration parameter number of locks.



Following is an example of the output from sp_configure, and a brief description of the output related to locks:



1> sp_configure "number of locks"

2> go

Parameter Name Default Memory Used Config Value Run Value

--------------------- ----------- ----------- ------------ -----------

number of locks 5000 0 5000 5000





The Default column contains the default value for number of locks, 5000.



The Memory Used column indicates the amount of memory used by the configured locks. Each lock requires 72 bytes of memory (11.5.x and earlier) or 120 bytes (11.9.x and later).



The Config Value column contains the value to which the number of locks configuration parameter has been set with sp_configure. If the value has not been explicitly configured, there is a 0 in this column and the default value is used.



The Run Value column contains the value Adaptive Server is using.





Action

Rerun the command when there are fewer active users, or ask the Sybase System Administrator ("sa") to reconfigure Adaptive Server for more locks. Increasing the number of available locks impacts performance and memory requirements.



Warning!



Before making any changes to Adaptive Server, refer to the Performance and Tuning Guide and "Configuring Memory" in the System Administration Guide for information about how Adaptive Server uses memory resources.





To increase the number of locks available, complete the following steps:





Determine the number of locks currently configured for Adaptive Server:



1> use master

2> go

1> sp_configure "number of locks"

2> go



Warning!



If you increase the number of locks available by too many locks, Adaptive Server may run out of memory and be unable to restart. Refer to Chapter 1, "Adaptive Server Does Not Start After Altering Configuration" if you run out of memory and cannot restart Adaptive Server.





Choose the number of locks you want to configure and issue the following command:



1> sp_configure "number of locks", new_value

2> go



Restart Adaptive Server to operate with the new values.
2007-06-26 02:10:41 UTC
lol
The Thinker
2007-06-26 02:11:50 UTC
One of two things usually cause Error 1204 to occur:



If you are connecting to the Internet through a firewall or proxy server and receive this message, it usually means that you need to provide a username and password to authenticate with your proxy server. For more information on configuring Xdrive Desktop to work with your firewall or proxy server, see: Configuring Proxy Server Settings.



There was a problem when Xdrive Desktop was installed. If you continue to receive this error message, please try uninstalling Xdrive Desktop and installing it again.


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...