Dear all,
One of the SQL Server 6.5 (in WinNT platform) in my company do not work properly. Perhaps there is a wrong database server setting:
In order to run a large job (e.g. SELECT or UPDATE statement of over 1 million records), I enlarge the "lock" setting in "Configure" option to its available maximum value, i.e. the maximum value that depends on "memory" setting. After reboot the server, however, no connection can be made to the database server. In other words, the connecting process is pending ... make the Enterprise Manager hang. Besides connecting process, all other activities made on the database server do not work, include configuration checking and restart, etc. I also find that the database server is still running, no sudden stop.
I am afraid that almost all system memory assigned to the database server is occupied by the "lock" setting - not enough resource to run other activities. How can I solve the problem? Can I change the settings manually by script or in file?
Please help me. Thanks a lot.
Regards,
Stephen
One of the SQL Server 6.5 (in WinNT platform) in my company do not work properly. Perhaps there is a wrong database server setting:
In order to run a large job (e.g. SELECT or UPDATE statement of over 1 million records), I enlarge the "lock" setting in "Configure" option to its available maximum value, i.e. the maximum value that depends on "memory" setting. After reboot the server, however, no connection can be made to the database server. In other words, the connecting process is pending ... make the Enterprise Manager hang. Besides connecting process, all other activities made on the database server do not work, include configuration checking and restart, etc. I also find that the database server is still running, no sudden stop.
I am afraid that almost all system memory assigned to the database server is occupied by the "lock" setting - not enough resource to run other activities. How can I solve the problem? Can I change the settings manually by script or in file?
Please help me. Thanks a lot.
Regards,
Stephen