MIS Systems Thread, SIMS Report performance in Technical; Hi,
When a member of staff runs off a big report, it makes SIMS unusable for anyone else at the ...
9th October 2013, 10:57 AM #1
SIMS Report performance
When a member of staff runs off a big report, it makes SIMS unusable for anyone else at the time. SQLServ.exe CPU usage gets pegged to 50% (Dual core, so it's only using one)
Is there anything I can do to stop this from happening? or at least find out who's running the big report and slap them. It's really. REALLY annoying >.<
IDG Tech News
9th October 2013, 01:18 PM #2
There's a tool in SQL that lets you see what is going on. It was mentioned very recently in a similar thread. Identify users running large reports
9th October 2013, 01:27 PM #3
Thanks - I'll take a look. is there no way to stop users from doing this full stop tho? I have no issue with them running said reports, but I think it's insane from a design point of view that a single user is able to hog all the CPU resources.
9th October 2013, 01:53 PM #4
Capita's response will be throw more resources at it. Microsoft will tell you (or rather Capita) to build a data warehouse, or get a MIS with proper reporting. I'm sure I know what @GREED will say.
I would say setup a spare server as a backup then get them to use that, but the best guide I've seen about setting that up was from Bob Carswell and I doubt he'll be updating that. Also users can get confused and end up working in the copy that's going to get overwritten later that day. Guess the best option would be to educate them in scheduling reports.
10th October 2013, 03:15 PM #5
See, I don't even need to monitor this site anymore... everyone knows my reactions already!!!
Originally Posted by matt40k
10th October 2013, 07:11 PM #6
We've had issues with reports recently too, more noticeable since the Summer upgrade.
Two things I'd suggest, 1 try editing the report and saving again, sometimes has made a difference to use for whatever reason, whether it just refreshes some details. 2. Capita sent us the reindexing patch through to run again which has helped again generally, so might be worth getting hold of that too.
By pete in forum MIS Systems
Last Post: 15th July 2011, 01:10 PM
By iceman in forum MIS Systems
Last Post: 22nd April 2011, 01:04 PM
By Progeniga in forum MIS Systems
Last Post: 11th February 2011, 05:02 PM
By cjohnsonuk in forum MIS Systems
Last Post: 6th January 2011, 02:37 AM
By localzuk in forum MIS Systems
Last Post: 15th November 2010, 02:00 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)