+ Post New Thread
Page 3 of 3 FirstFirst 123
Results 31 to 42 of 42
MIS Systems Thread, SIMS gradually getting slower and slower... in Technical; Originally Posted by siuko I am wondering if we could get an Ok you can do this from @ PhilNeal ...
  1. #31

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,141
    Thank Post
    353
    Thanked 578 Times in 475 Posts
    Rep Power
    142
    Quote Originally Posted by siuko View Post
    I am wondering if we could get an Ok you can do this from @PhilNeal ?

    The script does sound like it would be helpful - but I really don't want to be doing anything with the sims database without capita oking it first.... (yes I'm a chicken... buck buck)
    He won't. Reindexing is a most basic DBA task, it's not rocket science to do - however it assumes a number of things - like it's done out of hours, that you have a correct backup before you start, that if your system is in a poor state at the start, you have a pragmatic approach to tackling it - ie not doing everything at once. You might find that your log file grows to the point that it fills your disc, so SQL won't start, or if you've been silly enough to put SQL onto your OS drive, stop your computer from booting.

    The safe option is to hire a DBA to do it for you.

    Performance wise it really depends. If it's in a pretty poor state you'll is a absolute massive increase, well worth any risk.

  2. #32
    spr
    spr is offline

    Join Date
    Jan 2014
    Location
    Blackpool
    Posts
    5
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    Hi just to report back, did this on our SIMS db last night and for example on a small report I ran before took around 4 minutes and 1 minutes 30 seconds after reindexing.

    Thankyou!

  3. Thanks to spr from:

    zag (29th January 2014)

  4. #33
    mrbios's Avatar
    Join Date
    Jun 2007
    Location
    Stroud, Gloucestershire
    Posts
    2,335
    Thank Post
    327
    Thanked 237 Times in 195 Posts
    Rep Power
    94
    The reindexing patch also fixed the issue (somewhat) for myself quite a while back. However SIMS Discover is starting to take a very long time to do transfers again....so question is should we be running this patch every 6-12 months or something to keep things fast?

  5. #34
    zag
    zag is online now
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,535
    Thank Post
    815
    Thanked 380 Times in 317 Posts
    Blog Entries
    12
    Rep Power
    80
    Quote Originally Posted by spr View Post
    Hi just to report back, did this on our SIMS db last night and for example on a small report I ran before took around 4 minutes and 1 minutes 30 seconds after reindexing.

    Thankyou!
    Thats good enough for me!

    Will give it a go now.

  6. #35

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,826
    Thank Post
    104
    Thanked 449 Times in 308 Posts
    Blog Entries
    2
    Rep Power
    262
    Quote Originally Posted by spr View Post
    Hi just to report back, did this on our SIMS db last night and for example on a small report I ran before took around 4 minutes and 1 minutes 30 seconds after reindexing.

    Thankyou!
    Did you reindex (with the SIMS patch) or rebuild (with the maintenance plan)?

  7. #36
    spr
    spr is offline

    Join Date
    Jan 2014
    Location
    Blackpool
    Posts
    5
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    Quote Originally Posted by jinnantonnixx View Post
    Did you reindex (with the SIMS patch) or rebuild (with the maintenance plan)?
    Maintenance plan

  8. Thanks to spr from:

    jinnantonnixx (29th January 2014)

  9. #37
    zag
    zag is online now
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,535
    Thank Post
    815
    Thanked 380 Times in 317 Posts
    Blog Entries
    12
    Rep Power
    80
    Quote Originally Posted by jinnantonnixx View Post
    In the 'Define Reuild Index task' window, choose your SIMS database(s) to reindex.
    For 'object', choose 'tables and views'
    On the same window, check the box that says 'sort results in tempdb', keep the box that says 'keep index online...' unchecked.
    I'm using SQL server 2012 and don't have the 'sort results in tempdb' check box or 'keep index online'. Will that make any difference?

    sims-reindex.jpg

  10. #38

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,826
    Thank Post
    104
    Thanked 449 Times in 308 Posts
    Blog Entries
    2
    Rep Power
    262
    You've chosen the 'Reorganise Index' task. Try the 'Rebuild Index' task instead. This will ensure that the query optimiser has the best stats.

  11. #39
    spr
    spr is offline

    Join Date
    Jan 2014
    Location
    Blackpool
    Posts
    5
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    Well my success was short lived, 3 hours in and performance seems to have taken a nose dive when the admin girls are running big reports, they were all running pretty speedily first thing, meh! Server looks to be ticking over not doing alot, anyone have any advice on any tell tale signs it's a server performance issue?

  12. #40

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,826
    Thank Post
    104
    Thanked 449 Times in 308 Posts
    Blog Entries
    2
    Rep Power
    262
    Oh no!

    See if there's anything useful here. Get to know SQL Activity Monitor.

    Speeding up SIMS
    Last edited by jinnantonnixx; 29th January 2014 at 11:20 AM.

  13. #41
    zag
    zag is online now
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,535
    Thank Post
    815
    Thanked 380 Times in 317 Posts
    Blog Entries
    12
    Rep Power
    80
    Quote Originally Posted by jinnantonnixx View Post
    You've chosen the 'Reorganise Index' task. Try the 'Rebuild Index' task instead. This will ensure that the query optimiser has the best stats.
    Thanks, I've set it up properly now

  14. #42
    Olliesaurus's Avatar
    Join Date
    Sep 2012
    Posts
    93
    Thank Post
    6
    Thanked 5 Times in 5 Posts
    Rep Power
    4
    My SIMS manager had a huge great big go at Capita regarding a load of cases that werent being followed up, one of them being the speed issue.

    They have connected through and have setup a trace report through SQL profiler and have said that they will send it off to the developers to see if there are any issues, I dont know if its worth anyone else pushing for one of these, if the issue appears to be the same then they might do something about it.

SHARE:
+ Post New Thread
Page 3 of 3 FirstFirst 123

Similar Threads

  1. [SIMS] SIMS .net Default Username and Password?
    By jmahone in forum MIS Systems
    Replies: 5
    Last Post: 7th March 2013, 07:43 PM
  2. Vista getting slower and slower then freezing...
    By boomam in forum Windows Vista
    Replies: 5
    Last Post: 23rd October 2008, 03:23 PM
  3. Can't get mysql and PHP to play together on IIS
    By dagza in forum Web Development
    Replies: 5
    Last Post: 20th January 2008, 03:38 PM
  4. Replies: 5
    Last Post: 16th December 2007, 06:26 PM
  5. Replies: 2
    Last Post: 25th October 2007, 11: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
  •