SQL Server is running high CPU
- or -
Post a project like this2628
$$$
- Posted:
- Proposals: 10
- Remote
- #1418591
- Awarded
** Top 5% ** - .NET | NodeJS | PHP | Shopify | NopCommerce | QA (Manual & Automation) | SEO & Marketing
Buncrana
Database Consultant (SQL Server , SSRS, SSIS, Couchbase, MongoDB, MySQL,PostgreSQL, C#)
Gurgaon
GIATICA, IT Consultant + Hosting Business .NET Framework Specialists, WCF, WPF, ASP.NET, SQL Server
Milano
✪Software Developer ✪Web Developer (Java,Python, Android, jee, JSP, JSF, Java Fx,Vue, Blue J, Nuxt) ✪ Processing ✪ Elastic Search ✪ Database
Saitama
22296236268164884978994395545910887061189697120236912441651463151
Description
Experience Level: Expert
I run a very simple Coldfusion website with an SQL Server database. I have used SQL Server for 3 years and never had a problem. In December my website ground to a halt. The hosting company diagnosed that the problem was SQL Server running high CPU. A Server restart and SQL restart (to break the SQL connections) fixed the problem for a couple of says. I schedule in a restart every day to make sure the website remains in good performance. The resource monitor continually shows SQL Server CPU usage bouncing around between 30% and 90%. Is this an issue you can investigate for me?
Chris T.
100% (5)Projects Completed
5
Freelancers worked with
3
Projects awarded
56%
Last project
22 Mar 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi
Believe me put this SQL on a blade server , it may resolve the issue.
Thanks
Tathagat ,
Project Head , The Core Team -
Chris
Did you added any new query or coding in december? -
Hi Chris, do you have remote access to the server that I can use, I would need admin rights and would want to put a trace ion SQL so we can see what activity is causing the high CPU
287993287988287932
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies