+ Post New Thread
Page 2 of 5 FirstFirst 12345 LastLast
Results 16 to 30 of 64
MIS Systems Thread, SQL2008 VERY SLOW FOR ALL USERS in Technical; Hi, When running a report in PARS it seems to throw up lots of SPID's being blocked. I managed to ...
  1. #16
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    9
    Hi,

    When running a report in PARS it seems to throw up lots of SPID's being blocked. I managed to capture one. The biggest problem seems to be if more than 1 person is running a report at the same time....which happens quite often in our school


  2. #17
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    9
    They did seem to flash up quite quick. I'll wait untill someone says its locked out completely again and then run the report.

    Cheers

  3. #18

    Join Date
    Mar 2010
    Posts
    39
    Thank Post
    24
    Thanked 9 Times in 6 Posts
    Rep Power
    10
    I'm also having major problems with our SQL 2008 SIMS server being very slow, in our case the SQLSERVR.EXE process is almost always running at 100% CPU usage.

    I've followed this thread with interest and performed the tests and blocking reports as already discussed and cannot find any reason.

    Running SQL 10.0.1600.22 Standard with SIMS and FMS databases.

    Any advice?

  4. #19

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,174
    Thank Post
    284
    Thanked 773 Times in 583 Posts
    Rep Power
    335
    Quote Originally Posted by DarrenShan View Post
    I'm also having major problems with our SQL 2008 SIMS server being very slow, in our case the SQLSERVR.EXE process is almost always running at 100% CPU usage.

    I've followed this thread with interest and performed the tests and blocking reports as already discussed and cannot find any reason.

    Running SQL 10.0.1600.22 Standard with SIMS and FMS databases.

    Any advice?
    Either the server isn't up to spec for running the required loading, or your database needs reindexing/checking (see my post about patch 6635 earlier in thread).

  5. #20

    Join Date
    Mar 2010
    Posts
    39
    Thank Post
    24
    Thanked 9 Times in 6 Posts
    Rep Power
    10
    teejay - I will see if I can hold of the 6635 patch and let you know what I find.

  6. #21

    Join Date
    Mar 2010
    Posts
    39
    Thank Post
    24
    Thanked 9 Times in 6 Posts
    Rep Power
    10
    jinnantonnix, I've ran the Activity Monitor and it is showing the following:

    Processor: 98%
    Waiting Tasks: 5 (max 22)
    Database I/O: 0.1 MB/sec (max 2.0)
    Batch Req: 5 (Max30)

    Looking at the processes it shows me the processes but how can I tell which one(s) are hammering it?

    BTW Thanks to everyone's swift replies

  7. #22
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    9
    Hi,

    It happened again just now and it just so happens i was looking at the management studio activity monitor and the processes screen filled up with blocking errors. After about 5mins they cleared and users could access SIMs again.

    Here is a report, again only 1 entry for some reason even though there were about 10 different SPID's blocking each other.


  8. #23
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    9
    Quote Originally Posted by jinnantonnix View Post
    The routine that's causing the blocking is sta_pix_save_historical_membership_block.
    Thanks for finding out. I'll give this information to our local council and see if they know what could be causing it.

  9. #24
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    9
    they have now sent us a patch, Patch_14265 which apparently does the same as the other patches people have suggested on here. Will let you know how it goes once we have applied it.

  10. #25
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    9
    Hi,

    Just to let you all know we applied the patch this morning and the problems still persist. Taking a register in PARs and setting merits / sanctions seems to be ok but when running any kind of report in SIMS or PARS crashes the system for all users logged on at the time.

  11. #26

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,800
    Thank Post
    272
    Thanked 1,135 Times in 1,031 Posts
    Rep Power
    349
    We have just moved our sims to a new server with 10gb ram so the whole database can sit in the ram - seems to have made it quicker but still not as much as it should

  12. #27

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,800
    Thank Post
    272
    Thanked 1,135 Times in 1,031 Posts
    Rep Power
    349
    Quote Originally Posted by jinnantonnix View Post
    An SQL server must have good disk performance - disk is crucial to its operation. Every logged operation is written to the log file then the data file, regardless or how much memory you give it so you should never overlook the disk system.
    We havn't its still got the same disks hence why i didn't mention it as it wouldn't have made a difference - the drives sit on the san with a fibre connection to them

  13. #28

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,800
    Thank Post
    272
    Thanked 1,135 Times in 1,031 Posts
    Rep Power
    349
    Its the same as that but we don't use VMware as use KVM which runs in the linux kernel - which in my opinion seems to be quicker then ESX/Vmware server.

    The second and third disks for data and logs all are image files which run on the San.

  14. #29

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,859
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    182
    Quote Originally Posted by glennda View Post
    Its the same as that but we don't use VMware as use KVM which runs in the linux kernel - which in my opinion seems to be quicker then ESX/Vmware server.
    This is fact, not opinion KVM exists for very good reasons.

  15. #30

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,800
    Thank Post
    272
    Thanked 1,135 Times in 1,031 Posts
    Rep Power
    349
    Quote Originally Posted by powdarrmonkey View Post
    This is fact, not opinion KVM exists for very good reasons.
    I was trying not to start the KVM vs ESX argument!!

SHARE:
+ Post New Thread
Page 2 of 5 FirstFirst 12345 LastLast

Similar Threads

  1. SQL2008 Express Reboot Rule Fails
    By Rawns in forum Windows
    Replies: 0
    Last Post: 11th August 2010, 11:33 AM
  2. SIMS - SQL2005 > SQL2008 Migration Problem
    By RobFuller in forum MIS Systems
    Replies: 26
    Last Post: 24th March 2010, 10:39 PM
  3. sims slow to save data for some users
    By maark in forum MIS Systems
    Replies: 12
    Last Post: 2nd February 2010, 08:59 AM
  4. Help Please june Update + sql2008
    By woodham in forum MIS Systems
    Replies: 7
    Last Post: 6th July 2009, 03:26 PM
  5. Moodle - Slow when more than a few users are logged in
    By wesleyw in forum Virtual Learning Platforms
    Replies: 18
    Last Post: 21st September 2007, 02:34 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
  •