I desperately require assistance please!🤞
I'm trying to find a needle in a haystack...
Customer reports the following:
"Our 25+ users keeps losing connection to the SQL Express (not simultaneously), causing a loss of intelligence in our AutoCAD Plant 3D file." "When we restore a previous version of the XML file we manage to recover intelligence."
"When we employed 15 more P3D users, the issue got worse."
"It has happened before where the server will just shot down, but only once in a while (I'm guessing once every two weeks)."
"We don't have a Master DB containing all our specs. We create spec for each project."
What I gather:
Since all the users are experiencing the issue, I'm eliminating their workstations being the issue. So I'm definitely looking at the Server being the issue.
The MS Server Standard has no CALS.
Because of SQL Express's limitations I'm assuming ("putting my money on it") that its too many SQL connections from clients that'll "kick the users" from the connection (but I cant confirm that 100%, and hoping someone here can confirm).
I have checked the client XML file, and all seems good (not that I am a XML expert, but I can read 😂 ). It is pointing to the correct mapped drive and IP.
More details:
They are using SQL Express (as mentioned).
They have about 50+ projects in this one SQL instance.
25+ users working on P3D, but don't lose connection simultaneously.
Has someone here experienced the same before?
Any other advice that can be taken in consideration?
THANKS IN ADVANCE everyone!
