+ 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,023
    Thank Post
    97
    Thanked 158 Times in 107 Posts
    Rep Power
    58

    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,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    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,023
    Thank Post
    97
    Thanked 158 Times in 107 Posts
    Rep Power
    58
    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,337
    Thank Post
    367
    Thanked 619 Times in 506 Posts
    Rep Power
    155
    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
    2,938
    Thank Post
    359
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    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,186
    Thank Post
    446
    Thanked 168 Times in 165 Posts
    Blog Entries
    3
    Rep Power
    63
    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, 12:10 PM
  2. [SIMS] Parameters in SIMS reports
    By iceman in forum MIS Systems
    Replies: 2
    Last Post: 22nd April 2011, 12:04 PM
  3. [SIMS] SIMS Report Writing
    By Progeniga in forum MIS Systems
    Replies: 4
    Last Post: 11th February 2011, 04: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, 01:37 AM
  5. [SIMS] Sims report ignoring my filters? [SOLVED]
    By localzuk in forum MIS Systems
    Replies: 4
    Last Post: 15th November 2010, 01: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
  •