+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Identify users running large reports in Technical; Sometimes SIMS .net usage becomes very high, with CPU spikes on the server. This normally happens when a user is ...
  1. #1

    Join Date
    Sep 2011
    Posts
    162
    Thank Post
    5
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Identify users running large reports

    Sometimes SIMS .net usage becomes very high, with CPU spikes on the server. This normally happens when a user is running a large report. It then sometimes (rarely) causes SIMS .net to slow down or crash for other users. Is there any way to check, in these occasions, which user is running a large report in realtime? Thanks.

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,680
    Thank Post
    516
    Thanked 2,451 Times in 1,897 Posts
    Blog Entries
    24
    Rep Power
    832
    If you have SQL Server Management Studio installed, you can log in as an administrator and use the Activity Monitor in it to watch what's going on. Ongoing transactions show the user doing them.

  3. #3

    Join Date
    Sep 2011
    Posts
    162
    Thank Post
    5
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Thank you!

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 2
    Last Post: 30th June 2011, 02:18 PM
  2. SIMS crashing out when running a report
    By RSoP_Robbers in forum MIS Systems
    Replies: 39
    Last Post: 1st July 2010, 07:52 AM
  3. Block users running a batch file to run command.com?
    By reggiep in forum Windows Server 2008
    Replies: 3
    Last Post: 1st August 2009, 03:44 PM
  4. Running a report against a deleted reg group
    By adamf in forum MIS Systems
    Replies: 1
    Last Post: 30th January 2009, 08:26 PM
  5. sims times out when trying to run various reports
    By projector1 in forum MIS Systems
    Replies: 2
    Last Post: 5th July 2006, 12: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
  •