• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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 Oct 24, 2013, 9:04 AM

    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
    • T
      Tom Elliott
      last edited by Oct 24, 2013, 9:08 AM

      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 Oct 24, 2013, 10:28 AM

        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
        • T
          Tom Elliott
          last edited by Oct 24, 2013, 6:18 PM

          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 Oct 25, 2013, 7:32 AM

            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
            1 / 1
            • First post
              1/5
              Last post

            207

            Online

            12.0k

            Users

            17.3k

            Topics

            155.2k

            Posts
            Copyright © 2012-2024 FOG Project