• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    SQL Help!!!

    Scheduled Pinned Locked Moved
    Tutorials
    2
    5
    2.2k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • D
      Darren George
      last edited by

      So sorry to post this on the Fog forum but im hoping theres some SQL gods out there who can help, Recently one of our Server 2003 SP2 SQL 2005 boxes has begun running dog slow with the CPU being pegged at 100%, Ive tried turning on named pipes and turning off Shared memory in SQL config manager afew tips that i found whilst googling but our clients are really struggling to get any sort off work done due to the servers performence. Has anyone had any experience with this and found a cure?

      Sorry again for bumping this post with a non fog issue but given the amount of great techs on here i couldnt resist

      1 Reply Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott
        last edited by

        Simple as it sounds, have you tried rebooting that system?

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

        1 Reply Last reply Reply Quote 0
        • D
          Darren George
          last edited by

          Hi tom

          cheers for your reply, yes we have rebooted and although it does improve slighlty it then will start to gradually degrade to the point of connections being dropped, Im seeing a lot of tweaks mentioned on the web which scare me so just hoping someone has that golden fix

          cheers
          Darren

          1 Reply Last reply Reply Quote 0
          • Tom ElliottT
            Tom Elliott
            last edited by

            Then I would recommend looking at what is happening on your SQL Server System them. It sounds, to me, like some other service is running and stealing the resources of the system.

            Is this server by chance on a VM? If it is, maybe try adding more resources, such as another CPU and maybe a little bit more RAM.

            If it’s not on a VM, you will need to dig into what’s eating your resources and stop those services (as necessary) from running or using the amount of resources.

            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

            1 Reply Last reply Reply Quote 0
            • D
              Darren George
              last edited by

              Hi Tom

              Yes its virtual box, we wondered if it was hard disk related on our SAN so we have migrated it to its on Raid 5 Host to see if that improves performence on the box. Its a noodle scratcher deffo but thank you for answering Tom i need all the help i can get lol

              1 Reply Last reply Reply Quote 0
              • 1 / 1
              • First post
                Last post

              221

              Online

              12.0k

              Users

              17.3k

              Topics

              155.2k

              Posts
              Copyright © 2012-2024 FOG Project