Lukket

DBA required to determine root cause analysis as to why SQL Server Windows NT 64 Bit takes up 100% CPU and fix it.

Good day,

I require a detailed report as to why SQL Server Windows NT 64 Bit will take up 100% CPU and how to fix it. What quires cause the issues, etc.

Things to know before you bid:

This is a SQL Express DB that is going to be moved to Azure.

The software is a POS system.

TeamViewer will be the software used to access the server.

I can replicate a spike in the CPU by performing a task that takes up to 30% CPU.

Ensure that the CPU consumption issue no longer exists once quires are fixed.

Update the DB on Azure with the new one.

Work will need to start at 9PM MST on Monday March 12th.

The fix will need to be implemented either the same day or March 13th between 8AM-9AM MST.

If you have an example report of the analysis you will provide this would be preferred.

Only bid if you are able to perform all the task above and perform the work during the specified times above.

Thanks,

Steve

Evner: Azure, Database Administration, Microsoft SQL Server, SQL

Se mere: sql server cpu usage per query, sql server 2012 high cpu usage, sql server high cpu usage when idle, how to find cpu utilization in sql server, sql server cpu usage 100 percent, sql server 2008 r2 high cpu usage, sql server high cpu usage query, sql server 2014 high cpu usage, windows server 2008 cpu 100, sql 2008 cpu 100, cpu 100, swap cpu 100, nbx 100 tapi bit, sql server 2008 cpu 100, iis cpu 100 fix, compiling x64 bit driver windows, sql server 2008 cpu 100 slow, nopcommerce cpu 100, diablo cpu 100, setting windows radius server sql

Om arbejdsgiveren:
( 1 bedømmelse ) Airdrie, Canada

Projekt ID: #16467594

14 freelancere byder i gennemsnit $25/time for dette job

dotnetsqlCoder

Hello Can i know what is the task that causes CPU to rise to 33% ? If you are doing massive inserts for instance then you would just need better hardware . If that is read only then sure there is something to be Flere

$38 CAD / time
(74 bedømmelser)
7.0
$22 CAD / time
(48 bedømmelser)
5.2
itIndia2

Hello Steve, Greeting of the Day from Yudiz. We can help you with determining the root cause by analysis why SQL Server takes up 100% CPU Performance and then fix it. We have a team of .net Developers with an av Flere

$17 CAD / time
(2 bedømmelser)
4.7
murtaza1981

Hi, A SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) expert here. I would like to have a detailed document of your requirements s Flere

$20 CAD / time
(2 bedømmelser)
4.0
alexpuche1970

Hi Mr. Steve: I am a 20 years experienced Computing Professional. I've been working with SQL Server since version 7. I suppose the problem you have is because the lack of Indexes in some critical tables. Flere

$15 CAD / time
(1 bedømmelse)
2.7
Ramamaddileti

Overall 7+ years of experience as System Administrator with a track record of producing extraordinary results. Energetic self-starter with excellent analytical, organizational and creative skills. Strong perseverance Flere

$22 CAD / time
(1 bedømmelse)
0.8
raajasekarm

Vast experience in root causing the production database (both MS SQL Server and Oracle) issues related to application (SQL), configuration, environment, etc., and given the resolution.

$27 CAD / time
(0 bedømmelser)
0.0
bbenea

A proposal has not yet been provided

$25 CAD / time
(1 bedømmelse)
0.0
jclf11

A proposal has not yet been provided

$27 CAD / time
(0 bedømmelser)
0.0
chakridba

I have strong 8.5 + years of experience working with MS SQL server DBA across various versions from 2008 to 2016, including installation, configuration, database design, database creation, development, performance tuni Flere

$17 CAD / time
(0 bedømmelser)
0.0
uguryorulmaz

I have 20 years of SQL Server experience with all versions and editions. I'm also very good at optimization.

$15 CAD / time
(0 bedømmelser)
0.0
ellislax23

Hi I am a software engineer with a strong expertise in sql. I write queries, stored procedures and reports using SSMS and SSRS everyday at my day job. Let’s talk more about what all you have and what you need to so I Flere

$55 CAD / time
(0 bedømmelser)
0.0
$22 CAD / time
(0 bedømmelser)
0.0
davorsvw

Dear Sir, I've been working with SQL server for past 10 years, with SQL Azure for past 3 years. In company where I work we have ERP that had about 300 users with about 2000 working places. First we installed SQL serve Flere

$24 CAD / time
(0 bedømmelser)
0.0