+ Post New Thread
Results 1 to 6 of 6
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 ...
  1. #1
    DrCheese's Avatar
    Join Date
    Apr 2008
    Posts
    1,050
    Thank Post
    98
    Thanked 162 Times in 111 Posts
    Rep Power
    60

    SIMS Report performance

    Hi,

    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 >.<

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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

  3. #3
    DrCheese's Avatar
    Join Date
    Apr 2008
    Posts
    1,050
    Thank Post
    98
    Thanked 162 Times in 111 Posts
    Rep Power
    60
    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.

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    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.

  5. #5

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,289
    Thank Post
    406
    Thanked 418 Times in 338 Posts
    Blog Entries
    8
    Rep Power
    191
    Quote Originally Posted by matt40k View Post
    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.
    See, I don't even need to monitor this site anymore... everyone knows my reactions already!!!

  6. #6
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,305
    Thank Post
    488
    Thanked 190 Times in 184 Posts
    Blog Entries
    3
    Rep Power
    67
    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.



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Reporting on Email Address contents
    By pete in forum MIS Systems
    Replies: 8
    Last Post: 15th July 2011, 01:10 PM
  2. [SIMS] Parameters in SIMS reports
    By iceman in forum MIS Systems
    Replies: 2
    Last Post: 22nd April 2011, 01:04 PM
  3. [SIMS] SIMS Report Writing
    By Progeniga in forum MIS Systems
    Replies: 4
    Last Post: 11th February 2011, 05:02 PM
  4. [SIMS] SIMS report to output students who have a birthday today
    By cjohnsonuk in forum MIS Systems
    Replies: 9
    Last Post: 6th January 2011, 02:37 AM
  5. [SIMS] Sims report ignoring my filters? [SOLVED]
    By localzuk in forum MIS Systems
    Replies: 4
    Last Post: 15th November 2010, 02:00 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •