[sims] SIMS FMS Issues.

[craig2562]

Hope someone can help?

 

I'm not an SQL (or SIMS) expert in any way, only a basic understanding but I've got a SIMS/FMS problem at a school and the SQL 'Expert' is off sick.

 

We have tried CAPITA but I believe they said it's an SQL problem and so not part of their support.

 

When a User tries to log on to SIMs or FMS they get a timeout query and they can't log in. once the time is increased they can then log in.

 

However, once they're in, for no apparent reason they get logged out and then can't log back in again.

 

If we restart the server and restart the services, everything is fine again for about an hour and then the same things happen again.

 

Hope that makes sense?

 

Any pointers anyone can give are gratefully accepted.

 

Thanks

[Steve21]

Main thing I'd check first is the RAM usage on the SQL server (or if you've got it locally on SIMS box how much memory is assigned to it)

 

That could be a number of things though tbh, but memory is where I'd start

 

Steve

[round2it]

yes sql eats everything you defiantly need to define the max amount of ram it can use

[dapaulio]

How much ram does your box have installed?

 

Have you any other programs other than sims and fms installed and running on the same server that could be consuming ram

 

As others have mentioned sql will naturally consume as much as it can leaving the server with the bare minimum just enough to operate.

[mukz]

Have you asked if anyone is running off big reports? We ran into this issue recently, turns out it was a spike in ram being used up, changed sql to have a max amount allowed + a timeout syntax in the connect.ini

[Mistert89]

You can limit the amount of RAM allowed to SQL, so that system is left with sufficient. Our MIS server has 24GB, of which 8GB is reserved for system, by allocating max of 16GB to Sql.

[dapaulio]

What version of sql are you running?

If 2014 have you put it into compatibility mode as this addresses a number of performance issues that sims has with sql 2014

[IWDave]

How do you set the limit it can use?

[dapaulio]

How do you set the limit it can use?

 

https://technet.microsoft.com/en-us/library/ms191144(v=sql.105).aspx

[IWDave]

Yay. Cheers.

[superfletch]

Check the PC's network card isn't going to sleep when the machine is left idle for a while, that can confuse FMS - although that said I'm pretty sure anything can confuse FMS.

[splattthecat]

Also worth checking the FMSConnect.ini file (in the same folder as the Finance.exe) is pointing to the correct server and database.