+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
MIS Systems Thread, Sims server... in Technical; Been getting gradually slower the past few months, now even when one user opens a marksheet (pretty big marksheet) the ...
  1. #1
    Dom_'s Avatar
    Join Date
    Dec 2008
    Posts
    1,011
    Thank Post
    151
    Thanked 138 Times in 115 Posts
    Rep Power
    56

    Sims server...

    Been getting gradually slower the past few months, now even when one user opens a marksheet (pretty big marksheet) the server hits 100% CPU usage and the marksheet takes about 5 minutes to open. If it's like this with just one user I can't imagine what it's going to be like come september.

    Do I need top upgrade my hardware or are there any hotfixes/solutions that you guys know about?

    Currently running on an IBM XSeries 346, Intel Xeon 3GHz, 3.37GB RAM.

    Generally about 80 sims users.

  2. #2
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    966
    Thank Post
    37
    Thanked 172 Times in 137 Posts
    Rep Power
    95
    what disks and how much space

    what is the size of the MDF/LDF

    What version of SQL are you running

  3. #3
    Dom_'s Avatar
    Join Date
    Dec 2008
    Posts
    1,011
    Thank Post
    151
    Thanked 138 Times in 115 Posts
    Rep Power
    56
    IBM MAT3073N x4 in a RAID 5 setup (120GB Capacity, 54GB Free)

    MDF = 1.777GB
    LDF = 63MB

    Running SQL Server 2005 Version 8.00.760

    In Task Manager it shows sqlservr.exe running twice, each using 50% CPU, one using 1,701,500K memory, the other using 370K

  4. #4
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    966
    Thank Post
    37
    Thanked 172 Times in 137 Posts
    Rep Power
    95
    nothing obvious there and that spec looks fine, have you tried updating the SQL server to SP3?

  5. #5
    Dom_'s Avatar
    Join Date
    Dec 2008
    Posts
    1,011
    Thank Post
    151
    Thanked 138 Times in 115 Posts
    Rep Power
    56
    I haven't, is it easy enough to do? Do you think it'll have any effect?

  6. #6


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,698
    Thank Post
    352
    Thanked 803 Times in 718 Posts
    Rep Power
    348
    Running SQL Server 2005 Version 8.00.760
    Hm, isn't SQL V8.* 2000, specifically SQL 2000 SP3 in this case?

  7. #7
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    966
    Thank Post
    37
    Thanked 172 Times in 137 Posts
    Rep Power
    95
    SQL Server 2005 Version 8.00.760

    are you sure about the numbers as I thought that SQL 2005 should be a series 9

  8. #8
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    966
    Thank Post
    37
    Thanked 172 Times in 137 Posts
    Rep Power
    95
    SQL Server 2005 Service Pack 1 9.00.2047
    SQL Server 2005 Service Pack 2 9.00.3042
    SQL Server 2005 Service Pack 3 9.00.4035

    as a pose to

    SQL Server 2000 SP1 8.00.384
    SQL Server 2000 SP2 8.00.534
    SQL Server 2000 SP3 8.00.760

  9. #9
    Dom_'s Avatar
    Join Date
    Dec 2008
    Posts
    1,011
    Thank Post
    151
    Thanked 138 Times in 115 Posts
    Rep Power
    56
    Yeah - see attached
    Attached Images Attached Images

  10. #10
    Dom_'s Avatar
    Join Date
    Dec 2008
    Posts
    1,011
    Thank Post
    151
    Thanked 138 Times in 115 Posts
    Rep Power
    56
    Just noticed in add/remove programs that SQL Anywhere Studio 8 is also installed...

  11. #11
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    966
    Thank Post
    37
    Thanked 172 Times in 137 Posts
    Rep Power
    95
    check in Add remove programs, is there still a version of MSDE running on that server.?

  12. #12
    Dom_'s Avatar
    Join Date
    Dec 2008
    Posts
    1,011
    Thank Post
    151
    Thanked 138 Times in 115 Posts
    Rep Power
    56
    There are 3, Sims, sophos and WSUS

  13. #13
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    966
    Thank Post
    37
    Thanked 172 Times in 137 Posts
    Rep Power
    95
    Quick easy question
    Where on the HDD's are the LDF/MDF pair located

    ieC:\program files\microsoft sql server\etc

  14. #14
    Dom_'s Avatar
    Join Date
    Dec 2008
    Posts
    1,011
    Thank Post
    151
    Thanked 138 Times in 115 Posts
    Rep Power
    56
    D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

  15. #15
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    966
    Thank Post
    37
    Thanked 172 Times in 137 Posts
    Rep Power
    95
    ok that is the structure of an SQL 2005 database. I think that the number you are getting is looking at one of the older databases.

    I can't see any reason for the server to run slowly with the configuration that you have. I would raise with Capita as this may be a problem inside the database

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Rename SIMS server
    By cookie_monster in forum MIS Systems
    Replies: 19
    Last Post: 18th November 2009, 04:33 PM
  2. SIMS Document Server
    By Willzzz in forum MIS Systems
    Replies: 3
    Last Post: 10th November 2008, 03:03 PM
  3. SIMS Server
    By tech-man in forum MIS Systems
    Replies: 6
    Last Post: 1st August 2007, 09:49 AM
  4. sims server move
    By Oops_my_bad in forum MIS Systems
    Replies: 8
    Last Post: 4th June 2007, 12:49 PM
  5. New SIMS Server
    By GrumbleDook in forum MIS Systems
    Replies: 15
    Last Post: 3rd April 2007, 11:29 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
  •