I might start looking for a data problem in one of the associated tables involved in the process. Your support provider should be able to advise you of which tables to look at. Perhaps run the File Validation utility on those.
John
AKPolarBear,
You can create a SQL script file and run it in Query Analyzer to track down a lock placed on a specific table.
Try this for your script.
use msllockdb
go
select sessionid, tablename, rowid from maclocks
exec sp_who
HKNinja:
It's not the MDF file that is the issue. That stays relatively static, it's your transaction log file thats is always growing and shrinking. For example our MDF file writes to our RAID 5(72GB) array where as our tranaction log LDF file is stored on the RAID 1(36GB) array. The LDF file...
We have been using a Dell 2650 for about 3 1/2 years, so far no problems.
Dual 2.4 Ghz Xeon
2GB RAM
RAID 1(36GB)/RAID 5(72GB)
30 Users
Version 7.6.300B
This is a dedicated SQL server, Progression is on a different box. My only regret was not making the disk array larger. Our live company DB is...
Donna,
I'm really glad you posted your message as I am/was planning on upgrading from 7.6.200 to 7.6.300b this weekend.
Did you encounter this problem when you installed the 7.6.300 upgrade or when you installed the service pack "B"?
Also Don we are on SQL, are you aware is this an issue in the...
You could use this "put all your eggs in one basket" approach for a site with a small number of users. However if you ever had problems your whole network could be affected. I'm a strong proponent of using dedicated hardware for specific tasks or services. We operate a site similar to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.