Find Jobs
Hire Freelancers

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

$15-25 CAD / hour

Đã đóng
Đã đăng vào khoảng 6 năm trước

$15-25 CAD / hour

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
Mã dự án: 16467594

Về dự án

14 đề xuất
Dự án từ xa
Hoạt động 6 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
14 freelancers are bidding on average $25 CAD/giờ for this job
Avatar người dùng
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 done about it . ______________ Are you using Express 2017 ? thanks
$38 CAD trong 40 ngày
5,0 (74 nhận xét)
7,0
7,0
Avatar người dùng
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 so that we can discuss the each and every point in details. Thanks, Murtaza
$20 CAD trong 40 ngày
5,0 (2 nhận xét)
4,0
4,0
Avatar người dùng
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. This problem you have we could solve it by monitoring this process that consume 30%. We'll get from there all Queries executed and then monitor each one so we could identify where is the bottle neck. After that We could add necessary indexes and It should solve this problem. The Recommendation after that is to analyze the entire database structure and add as much indexes as is needed. Optionally, of course. We don't need to do this on Production environment. We could do a copy of database and test on a testing computer. Let me know if you want me to help you with that. Thanks for the opportunity.
$15 CAD trong 20 ngày
5,0 (1 nhận xét)
2,7
2,7
Avatar người dùng
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 and diligence towards attaining challenging goals and effective time management.
$22 CAD trong 40 ngày
5,0 (1 nhận xét)
0,8
0,8
Avatar người dùng
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 trong 40 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
A proposal has not yet been provided
$25 CAD trong 8 ngày
5,0 (1 nhận xét)
0,0
0,0
Avatar người dùng
A proposal has not yet been provided
$27 CAD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 tuning, query optimization, Backup, restore, disater recovery & High availability setup and resolving issues And also working on (Logshiping, Mirroring, Replication, Clustering and Always On).
$17 CAD trong 30 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
I have 20 years of SQL Server experience with all versions and editions. I'm also very good at optimization.
$15 CAD trong 40 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 can get started for you.
$55 CAD trong 40 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của CANADA
Airdrie, Canada
5,0
1
Phương thức thanh toán đã xác thực
Thành viên từ thg 9 21, 2014

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.