OS: 64-bit Windows 2016 server, Windows 10
Database: 64-bit MS SQL 2017 server (standard edition), SQL Azure 2017
Applications (all 64 bit) : (1) Highly multi-threaded C++ windows service application writing to database (2) Web Application used for administration and monitoring (3) 3 other C++ applications also use database for reading and writing.
Problem faced:
1. Deadlock: Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Using SQL profiler (xml_deadlock_report), we have been able to track the problem to some indexes on views but removing the indexes is not the solution as it slows the performance. We need better solution to fix our SQLs.
2. Blocking: There must be quite a few Select calls that are blocking. We have observed that the performance of our C++ program slows down when web application is used.
3. SELECT SQLs: Need to understand if select sqls must always open database in read only mode for better performance.
4. FLAGS: Need to use appropriate isolation levels, and other flags / properties. Complete sanitation needs to be done.
5. Poor performance: In general, database seems to slowing down the performance of the entire application.
Need MS SQL Server database expert who is proficient with SQL profiler and other tracing options to find out the problems and suggest changes.
The expert will be provided access to a VM instance on Azure, which will have all the applications running, SQL server standard edition, SQL Management studio.
The expert will be suitably assisted with necessary support staff to run the tests, collect necessary traces, setup breakpoints, and do whatever groundwork necessary so that the expert does not have to learn the application but rather focus firmly on finding problems at the database end.
Please describe the approach you will take to solve the problem. I am looking for an expert on long-term basis whose expertise we will keep using intermittently.
If you have any questions, please let me know. I am very much available over weekends also.
Thank you for taking time reading this and responding.
With warm regards!
","employmentType":["FULL_TIME","PART_TIME","CONTRACTOR","TEMPORARY","PER_DIEM"],"jobLocationType":"TELECOMMUTE","hiringOrganization":{"@type":"Organization","name":"Toogit","sameAs":"https://www.toogit.com/","logo":"https://www.toogit.com/images/toogit_logo_initial.png"},"identifier":{"@type":"PropertyValue","name":"Toogit","value":373807},"skills":["Database Administration","Database Design","Database Programming"],"applicantLocationRequirements":[{"@type":"Country","name":"IN"},{"@type":"Country","name":"Canada"},{"@type":"Country","name":"USA"},{"@type":"Country","name":"Germany"},{"@type":"Country","name":"Pakistan"},{"@type":"Country","name":"Philippines"},{"@type":"Country","name":"Indonesia"},{"@type":"Country","name":"Sri Lanka"},{"@type":"Country","name":"Nigeria"},{"@type":"Country","name":"China"},{"@type":"Country","name":"Russia"},{"@type":"Country","name":"Bangladesh"}],"validThrough":"2024-09-15T20:21:06+05:30","url":"https://www.toogit.com/freelance-jobs/MzczODA3"}
Remote Network And System Administration Job In IT And Networking
Find more Network And System Administration remote jobs posted recently Worldwide
Work from Anywhere
40 hrs / weekHourly Type
Remote Job$9.53
Cost Looking for help? Checkout our video tutorial
How to search and apply for jobs
How to apply? Do you have more questions about the Job?
See frequently asked questions
Independent contractors only. Need not apply if you are part of an agency or company.
Candidates must be able to work independently on assigned tasks, but be able to speak English fluently and confidently as the candidate would be required t...read more
Scrape an auction website.
Create data tables for each auction.
Determine good deals with a formula.
Send good deals via email.
I want somebody to finish the framework of my CRM system. Most of the information is in there it just needs a tidy up, automations set up, a few more templates and generalised organising and sorting of products, packages, etc.
Also - will r...read more