+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, Using activity monitor to locate user running reports in SIMS in Technical; I have been using activity monitor in the SQL admin studio on our SIMS server to find the most expensive ...
  1. #1

    Join Date
    May 2013
    Location
    Bristol
    Posts
    29
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Using activity monitor to locate user running reports in SIMS

    I have been using activity monitor in the SQL admin studio on our SIMS server to find the most expensive queries.
    There has been virtually 100% cpu on the SIMS server, with 10 times the CPU resources going to this insert command being performed.
    My mate tells me I can run a trace to find out the process code but it is all above me.
    Is there a way of determining which user is causing high cpu load on our server....
    Cheers,
    Darren

  2. #2

    Join Date
    May 2013
    Location
    Bristol
    Posts
    29
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Any ideas on how to locate users who are running large reports?

  3. #3

    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
    purportedly if you say this name 3 times and click your heels magic sometimes happens @jinnantonnixx

  4. #4

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,968
    Thank Post
    112
    Thanked 489 Times in 335 Posts
    Blog Entries
    2
    Rep Power
    283
    Four times, Vik. Four times. My rate has gone up.

    I'm snowed under today, but this thread covers a lot of topics, including Activity Monitor.
    Speeding up SIMS
    Last edited by jinnantonnixx; 11th November 2013 at 11:47 AM.

  5. #5

    Join Date
    May 2013
    Location
    Bristol
    Posts
    29
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Thanks for that, I am getting to grips with SQL manager - slowly. That is a good resource. We keep getting a recent expensive query - and insert into command consuming significant amounts of CPU and users are reporting issues accessing and performing simple tasks in SIMS. I had to restart the SIMS server at lunchtime today and the problem has seemed to disappear. Is anyone aware of this issue.

  6. #6

    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
    It is common for big routines and updates to slow the system down. A lot of the processes for starting the new academic year, promotion, even validating membership can take their toll on the system. As well as bulk updates.
    Are there lots of people changing data? Possibly even the same data? Maybe a lot of report writing. These could be slowing down the system, or creating locks while they wait for other processes to finish.
    Do you have a lot of people with high level permissions?
    If you can track down the procedure that is being run, it might help you find the user / type of user that would run it and work out what is going wrong.
    Are you on the latest version of SIMS, spring had some issues with CPU usage, which could easily be fixed with a patch, or updating, also, the homepage graphs take up a lot of resource and maintain open connections to the SQL server.

  7. #7

    Join Date
    May 2013
    Location
    Bristol
    Posts
    29
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    If you can track down the procedure that is being run...... I have been trying to do this but as we have had 101 things to do it is difficult to follow. When I sort the processes by task state no one individual keeps popping up.. I have restarted the server and am not seeing large CPU requests (but that may not mean anything)

  8. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    If you keep closing and open SIMS and rebooting the server you'll be having to keep rebuild the cache so it'll be doing more harm then good.

    Have you looked at the disc queue length within performance monitor? Could be you can't write to the disc fast enough so the CPU is locked waiting. Be worth logging with Capita and getting your moneys worth.

  9. #9

    Join Date
    May 2013
    Location
    Bristol
    Posts
    29
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    I will have a look in the morning, makes sense I am getting tunnel vision!!
    We are having meltdown and the boss is away and muggings is the only one onsite knows about SIMS. I have been adding the timeout line to clients as they are getting kicked out of SIMS with the database timeout error - and we have 100 users.
    We are managed by the local council and have no capita report..
    To resolve the users being kicked out of sims as it is slow I was adviced to detach and reattach the database. I tried disabling the tcpip pipes in sims and restarting the sql in services for the connections to take effect. however I got error messages, the sql would not start with the tcp ip pipes disabled...
    So in trying to detach the database and reattach the database using dbattach would not work unless the sql was online.
    We do have a script to stop access to the database however this is used when upgrading the sims but this method causes issues.
    How can I kick people off the database - we have connect.ini installed locally in c:\program files\SIMS\SIMS .net\connect.ini
    My disclaimer is the setup is not my work.........
    So if I detach and reattach the database this would "clean up" the sql - according to our support. I was also advised to limit the sql to 4gb as it is capitas recommendation - we have the full SQLSERVER version....

SHARE:
+ Post New Thread

Similar Threads

  1. HELP! Every GPO is being applied to a user, not even in the OU?
    By EarlGrey in forum Windows Server 2008 R2
    Replies: 1
    Last Post: 26th January 2012, 03:26 PM
  2. Replies: 4
    Last Post: 6th July 2010, 10:04 AM
  3. Using Active Directory to Login to a website
    By uraknai in forum Windows Server 2000/2003
    Replies: 6
    Last Post: 4th February 2009, 04:04 PM
  4. How would I use meta tagging to create a search system in Frog?
    By Martin84 in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 12th March 2008, 02:19 PM
  5. Replies: 3
    Last Post: 10th March 2006, 01:54 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
  •