+ 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,028
    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,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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,028
    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,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    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,033
    Thank Post
    374
    Thanked 367 Times in 299 Posts
    Blog Entries
    8
    Rep Power
    176
    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,214
    Thank Post
    454
    Thanked 176 Times in 173 Posts
    Blog Entries
    3
    Rep Power
    64
    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
  •