Find Jobs
Hire Freelancers

After restarting the SQL server, response gets fast for couple of hours, and then extremely slow!!

$10-30 USD

Completed
Posted about 8 years ago

$10-30 USD

Paid on delivery
Hi Freelancer, Read the info carefully, and please be noted that we'll only contact those who provide detailed description explaining the ability to fix this issue not a general desc. We have new users for our mobile app, that streams videos from server and call some URL functions from php server side, We noticed some delay after sometimes on calling some URL(response time:5 sec instead of 0.5) like: [login to view URL] and after investigation, we noticed: 1) when restarting the SQL server from the server, the response speed comes back to 0.5 sec, but after couple of hours, get back to slow 5 sec. 2) As you see in the attachment, when I call the URL, I noticed that php task on the (top) server reaches 90% *) attached solution diagram *) Top CPU percentage when running slow. *) cnf
Project ID: 9432078

About the project

16 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
there was my description but now it isnt I dont know why but Ill write thiis one "1- give me urls that are slow 2- Ill view top 3- Ill view [login to view URL] 4- Ill view mysql-database structure and indexes 5- Ill view if slow query log present. If not, its bad and Ill turn it on and we have to wait some hours "
$56 USD in 3 days
5.0 (31 reviews)
5.6
5.6
16 freelancers are bidding on average $63 USD for this job
User Avatar
Hi, I think after restart your SQL server consume some resources/reserves(which available at beginning) and after some time some php functions related on some sql queries produce calculations which affect on CPU load, I probably may look at it but not sure if you want solve it quick or ready to wait. I once deal with similar behavior for client in past.
$246 USD in 11 days
5.0 (285 reviews)
7.0
7.0
User Avatar
Hi, I have more than 7 years experience in setup and management of different Linux web hosting servers like CentOS, RedHat, Ubuntu, Debian etc. I have expert level knowledge in web hosting panels like cpanel, plesk, webmin , ispconfig, zpanel, Direct admin etc. Initial server setup steps:- Install LAMP dns name server Install Postfix for sending the mails Install Dovecot to receive the mails Install vsftp etc. Install squirrelmail GUI panel for email management All linux flavours supported Services Support:- Apache,IIS, Tomcat, DNS, Nginx, varnish ASP.NET, PHP, Java, AWS, MSSQL 2008/2012, MySQL, Postgresql Exim, Postfix, sendmail, Mail Enable, smarter mail, powermta etc. Server Log Monitoring:- Techs will be monitoring the Server Logs Restart Services if necessary and required Fix issues if any of the services have problems Basic Server Security:- Server Securing and Hardening CSF Firewall Installation & Configurations LFD Alerts on Brute Force Attacks SMTP Tweaking PHP Hardening (SUPHP, SUHOSIN ) Mod_security Setup and Configurations Root Login Email Alerts Thanks
$45 USD in 1 day
4.9 (232 reviews)
6.7
6.7
User Avatar
Hello! I have right skills and great experience for begin working on your project just right now! You may show good reviews at my profile.
$150 USD in 5 days
4.8 (245 reviews)
6.9
6.9
User Avatar
Hi, We help customers do business better by leveraging our industry-wide experience and deep technology expertise. These technology includes setup and management of different Linux web hosting servers like CentOS, RedHat, Ubuntu, Debian etc. We have expert level Of knowledge in web hosting panels like cpanel, plesk, webmin , ispconfig, zpanel, Direct admin , virtualmin ,vestapanel etc. Initial server setup steps:- Install LAMP dns name server Install Postfix for sending the mails Install Dovecot to receive the mails Install vsftp etc. Install squirrelmail GUI panel for email management All linux flavours supported Services Support:- Apache,IIS, Tomcat, DNS, Nginx, varnish ASP.NET, PHP, Java, AWS, MSSQL 2008/2012, MySQL, Postgresql Exim, Postfix, sendmail, Mail Enable, smarter mail, powermta etc. Server Log Monitoring:- Techs will be monitoring the Server Logs Restart Services if necessary and required Fix issues if any of the services have problems Basic Server Security:- Server Securing and Hardening CSF Firewall Installation & Configurations LFD Alerts on Brute Force Attacks SMTP Tweaking PHP Hardening (SUPHP, SUHOSIN ) Mod_security Setup and Configurations Root Login Email Alerts Thanks..
$45 USD in 1 day
4.8 (193 reviews)
6.4
6.4
User Avatar
which is this snapgoal ? is it your default apache username ? i believe exact issue can be addressed if you can attach last 24 hours http access_log file
$15 USD in 1 day
4.9 (254 reviews)
5.6
5.6
User Avatar
I an American living in the United States and I speak English! I'm a highly experienced web application developer with extensive experience in WordPress and PHP development. Additionally, I worked full-time as a Network Engineer for a large software development company. I've developed over 100 themes and plugins including some popular plugins listed on the WordPress Plugin Database. I also have extensive experience with Ecommerce platforms including Magento, OpenCart, Xcart and WooCommerce. Additionally, I have extensive experience with Google AdWords and SEO. Additionally, I provide quality assurance services on both a functionality and coding level.
$29 USD in 1 day
4.7 (32 reviews)
4.5
4.5
User Avatar
Can you give me access to sql server DB. it seems like few queries stuck the high CUP usage in sql server . I can tune these queries
$25 USD in 1 day
5.0 (3 reviews)
4.0
4.0
User Avatar
Dear Sir I am a software engineer from Sri Lanka with a degree in Information technology from the university of Colombo. I have experienced in web application development using ajax, php And mysql . and also have a experience with android application development With java and standalone app development in java. I take great pride in my believe I could produce exactly what you are Looking for. Look forward to discussing this opportunity with you further. Kind regards Asanka
$25 USD in 1 day
5.0 (6 reviews)
2.7
2.7
User Avatar
Might have your source code php and login to your server? I would like to check few things. no. of concurrent connection is your php only using persistent connection, etc. any slow query need to distinguish slow at php or mysql
$55 USD in 1 day
5.0 (3 reviews)
1.7
1.7
User Avatar
With ssh access there are MySQL checks that can be done to verify the problem is with MySQL and help tune it to your needs. The max_connect_errors in your configuration will allow just one or two machines to tie up your MySQL server. This should be a very low number but and it is rarely ever triggered. But if it is triggered with this high of a number it does nothing to protect your server.. There are a few other adjustments that I'm guessing are also required but access to the server is required to verify.
$30 USD in 1 day
5.0 (2 reviews)
1.3
1.3
User Avatar
Hi, I can have it done for today or tomorrow, or at least determine the root cause and possible solutions; I have more than 10 years of Linux experience (lots of troubleshooting) including LAMP environments . Best Regards.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a Senior Database Administrator with 13+ years’ experience, which includes working on Analysis, Design, Programming, and Maintenance of Databases & Software applications in Client Server Technology, cluster environments, performance tuning and optimization projects for high transactional systems and migration projects with size of 5TB+. I also have 10+ years’ experience as Core SQL DBA Administrator and 4+ years’ experience in leading a DBA team. During my career I worked on project for US, UK, Switzerland, Germany based clients with SQL Server Technology – right from version 7.0 to its latest form (SQL Server 2014). Installed and configured alwayson in SQL Server. I am very much committed in providing Fast and Quality Results and looking forward for having a long term professional relationship with my Clients. I am a fantastic worker knowledgeable about my fields of work. I believe I would comfortably fulfill all the duties and job requirements for this position with procession and efficiency.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, As per the description, I need check what is the root cause of the issue. This may due to poor configuration of memory,tempdb etc.. To find out the root cause I need 1 hour and to fix more 1 hour is required. You could share the screen using skype or teamviewer so I can look this. Please let me know feasible time(with timestamp) to fix this problem. Thanks, Nikhil
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PALESTINIAN TERRITORY
Ramallah, Palestinian Territory
5.0
92
Payment method verified
Member since Aug 6, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.