Hello, I'm having problem changing the locks in my SQL 6.5 Server Configuration. My current config value and running value is now at 50000. When I try to change the config value to 100000, the running value will not change even after restart and/or reboot. I also run RECONFIGURE WITH OVERRIDE after my SP_CONFIGURE command.
I have 9 other servers, performing the same function as this one, and I don't have any problem changing their locks. They all have the same amount of memory, physically and SQL server memory.
What could be the problem? I'm trying to run DBCC DBREINDEX in one table with 34,500,000+ rows but can't do it because of this locks. I also tried to reindex one index at a time of that table but no luck at all.
I really need your help you guys. Any suggestions is very much appreciated!
Andel
andelbarroga@hotmail.com
I have 9 other servers, performing the same function as this one, and I don't have any problem changing their locks. They all have the same amount of memory, physically and SQL server memory.
What could be the problem? I'm trying to run DBCC DBREINDEX in one table with 34,500,000+ rows but can't do it because of this locks. I also tried to reindex one index at a time of that table but no luck at all.
I really need your help you guys. Any suggestions is very much appreciated!
Andel
andelbarroga@hotmail.com