+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, SIMS slow since SQL 2012 upgrade in Technical; Hi Everyone Since I upgraded SQL from 2008 to 2012 on the SIMS server, SIMS has been really slow. Reports ...
  1. #1

    Join Date
    May 2008
    Posts
    524
    Thank Post
    18
    Thanked 8 Times in 8 Posts
    Rep Power
    15

    SIMS slow since SQL 2012 upgrade

    Hi Everyone

    Since I upgraded SQL from 2008 to 2012 on the SIMS server, SIMS has been really slow. Reports are taking forever to run and sometimes come up with and error. There is 14gb RAM in the server (2008R2) and SQL has been capped at 8gb (6gb Minimum)

    Has anyone else had slowness since the SQL upgrade?

    Thanks

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Stupid question, you uninstalled\disabled SQL 2008? Might be worth applying the reindexing patch.

  3. #3

    Join Date
    May 2008
    Posts
    524
    Thank Post
    18
    Thanked 8 Times in 8 Posts
    Rep Power
    15
    Yep, definatly disabled SQL 2008 service. Not uninstalled though

  4. #4

    Join Date
    May 2008
    Posts
    524
    Thank Post
    18
    Thanked 8 Times in 8 Posts
    Rep Power
    15
    Apart from the 10gb database limit with 2012 SQL express, is there any other limitations for RAM or CPU? Capita said there isn't but I just want to clarify?

    Thanks

  5. #5

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,187
    Thank Post
    285
    Thanked 775 Times in 585 Posts
    Rep Power
    336
    Quote Originally Posted by techie08 View Post
    Apart from the 10gb database limit with 2012 SQL express, is there any other limitations for RAM or CPU? Capita said there isn't but I just want to clarify?

    Thanks
    Yes there are, see here - Features Supported by the Editions of SQL Server 2012

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Quote Originally Posted by techie08 View Post
    is there any other limitations for RAM or CPU? Capita said there isn't but I just want to clarify?
    Ha! 1GB RAM and 1 CPU (max of 4 cores)

    EDIT: Like @teejay said
    Last edited by matt40k; 19th June 2014 at 08:53 AM. Reason: teejay is too quick

  7. #7

    Join Date
    May 2008
    Posts
    524
    Thank Post
    18
    Thanked 8 Times in 8 Posts
    Rep Power
    15
    so where they have been getting me to increase the RAM on the server (and up the SQL cap) will have made no difference?

  8. #8

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,187
    Thank Post
    285
    Thanked 775 Times in 585 Posts
    Rep Power
    336
    No 1 lesson to learn, do your own research, don't rely on what companies say without checking from other sources

  9. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Depends, if it's a dedicated SIMS server, pretty much yes. Utter waste. With SQL, disc is often king.

    Have you run the reindexing patch? What size is the sims.LDF?

  10. #10

    Join Date
    May 2008
    Posts
    524
    Thank Post
    18
    Thanked 8 Times in 8 Posts
    Rep Power
    15
    Its on its own server as a VM. ldf is 149,660kb and mdf is 5gb

    As for research I read through all the Capita articles which only seemed to mention the 10gb database limit! Other articles only mention the 1gb RAM limit for the buffer pool.

    Also re ran the indexing patch.

  11. #11
    AButters's Avatar
    Join Date
    Feb 2012
    Location
    Wales
    Posts
    477
    Thank Post
    143
    Thanked 107 Times in 82 Posts
    Rep Power
    42
    If your database is 5GB sounds like your a decent sized secondary.

    You MUST upgrade from the express edition as the limitations as mentioned above will mean your SIMS will run likea dog permanently.

SHARE:
+ Post New Thread

Similar Threads

  1. [Windows Software] SQL 2012 for Sims
    By zag in forum Licensing Questions
    Replies: 1
    Last Post: 7th October 2013, 11:27 AM
  2. [SIMS] Sims.NET - SQL 2008 upgrade to SQL 2008 R2
    By dan400007 in forum MIS Systems
    Replies: 2
    Last Post: 30th July 2012, 03:08 PM
  3. SQL Server - running slow since putting more memory in!
    By Sam_Brown in forum Windows Server 2008 R2
    Replies: 4
    Last Post: 5th November 2011, 12:26 PM
  4. SIMS slow after migration to SQL 2008
    By teejay in forum MIS Systems
    Replies: 7
    Last Post: 21st November 2010, 07:50 PM
  5. Sims SQL 2005 upgrade on a new server?
    By zag in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 08:46 AM

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
  •