SIMS Server query
Just want to check that my opinion on something is right.
Our current server spec for SIMS is a Xeon E5420 with 8GB RAM running Server and SQL 2008 x64.
While idling at this current point in time (so no users except me), the Processor usage is 1%/2% and RAM usage is approx 6GB.
SQL Database Size is 1.2GB, log file 4MB.
The reason I'm asking is that when running an export using groupcall we currently have one report which is failing, while the report is running processor usage ranges between 10% and 35% and memory usage remains about 6.5GB.
Would this suggest that the report is taxing the server in anyway or not? IMHO it's not, but just checking (only because of something fairly recently I'm starting to doubt myself)
Doesn't sound taxing. But perhaps when you run it in a live environment with other users, the usage may ramp up a bit. Does it still fail with no-one else on the system?
Does it give any errors? It could just be the report needs reimporting.
Is this the latest version of groupcall exporter? With the older version i had real problems with it running reports and using all the ram that it could and then crashing (was pulling students photos in groups).
also do you use the attendance graphs on the homepage for staff? and also when they display student information? as these are really badly written and as they auto refresh they tend to cause high load on the server and mean other things tend to crash while its happening.
The report was still failing even with me just logged onto the server (not even into SIMS) and after I'd disabled BackupExec and Sophos services to check they wern't causing problems.
35 staff have just logged into SIMS now to do registers and what not, RAM usage still about 6.5GB, processor usage hasn't gone above 30% while I've been monitoring it, tends to hover about 10%.
Groupcall said we are running the latest version of the exporter (was working fine before it updated and stopped immediately after the update now that I've looked through the log files)
I'll fire the call back to groupcall and they can do more investigating then.
It does have various SQL Strings and SIMS rept.def files all associated with it, although atm I've sent the call back across to Groupcall so a little reluctant to mess. Might move everything across to my test system and see if it works on there.
As a quick update, last night I copied the database and DMS to my test virtual machine which I admit won't be upto any usable spec other then my individual testing, but the groupcall export failed with the exact same error which suggests to me that it is either something in our data or something wrong with the groupcall report (or am I jumping to far ahead?)
No that's reasonable. It's most likely to do with their update, so let them deal with it for now.
Sometimes for slow reports there is a patch from Capita (re-indexing) that can sometimes help, but i'd reckon if all other reports are okay, and this happened recently post upgrade then it's their issue.
Is it a mission critical report? Can you replicate the report yourself in SIMS, make your own similar one and see if that works any better..?
From what I understand, it's one that is supposed to pull the Linked Documents of a certain type out of SIMS and upload them for Parental Reporting so don't know of anyway of replicating the report (as I don't really understand how it's doing it).
I'll maybe try Capita for the re-indexing patch Monday anyway so that I've ruled everything out my end. (although since they are stored in the DMS can't really see that making much difference either :/)