Find Jobs
Hire Freelancers

Troubleshoot Poorly Performing MS SQL 2008 database _BUG44372

$10-25 USD / hour

Closed
Posted almost 6 years ago

$10-25 USD / hour

We have web application: * IIS * Custom ISAPI filter handling web ui * MS SQL 2008 DB - back end Over time we have been noticing sluggishness...We have used profiler in the past to analyze and create indexes that have helped. Now it it time to revisit the indexes as some of the db request are taking too long and the web ui components are timing out and or consuming all available threads. We need someone who can hit the ground running with MS SQL Profiler and help us to determent which indexes we should keep, rebuild and or refine.
Project ID: 17287013

About the project

15 proposals
Remote project
Active 6 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
15 freelancers are bidding on average $22 USD/hour for this job
User Avatar
Dear Employer, Hope you are doing great..!! I have hone through your job posting and found our skills perfectly matching with our expertise. Our team having highly experienced developers with number of experience on Databases, SQL. Kindly ping me on the freelancer chat box so that we can discuss the project scope in more detail. I am eagerly looking forward fro your reply. Warm Regards Nisha
$20 USD in 48 days
4.9 (102 reviews)
8.3
8.3
User Avatar
Hi There, Yes, I can definitely help you with fixing the issues with very badly performing MS Sql Server database. I must not only be the index that need to be checked and fixed, there are many other factors also that need to be checked to optimize the performance of the Database. Myself along with my team has extensive knowledge and more than 10 years of experience in handing many versions of MS Sql databases. Let us discuss it in more detail. I am online. Regards, Sunil O.
$23 USD in 40 days
4.6 (81 reviews)
8.1
8.1
User Avatar
Greetings, I here by offer my services to index your database and improve its performance. I am expert software developer with hands on experience and knowledge on database development and administration. I also have expert DBA in my team. Can you please share more details and discuss the Bug or laziness of the database? Looking forward to discuss this case in detail. Best Regards.
$20 USD in 40 days
5.0 (26 reviews)
6.8
6.8
User Avatar
Hello, I can help with you in your project Troubleshoot Poorly Performing MS SQL 2008 database _BUG44372. I have more than 5 years of experience in Database Administration, Software Architecture, SQL. We have worked on several similar projects before! We have worked on 350+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$20 USD in 40 days
4.9 (57 reviews)
6.5
6.5
User Avatar
Hello, I can help you to refine your indexes we should kept and rebuild & to be revised on Mysql. as per your given brief on project post. Let me know when you available to discuss more in detailed. Regards Rina
$22 USD in 40 days
5.0 (15 reviews)
5.4
5.4
User Avatar
Skills : .Net Core 2, Angular CLI, Angular 5, Angular 4, Angular2, Angular Js, C# .Net, MVC , HTML5, CSS3, Bootstrap, Typescript, Javascript, Jquery, ASPBOILERPLATE, Twilio, Kendo UI, Google API, Mobile Jquery,WPF, WCF,WEBAPI, Telerik ************************* Database Language : Entity Framework, Entity Framework Core, MSSQL, Oracle, MySQL, Microsoft Access ************************* Reporting Langauge : Crystal Reports, RDLC, Syncfusion View, Pivot, Chart Reports , DevExpress, SSRS ************************* Reporting Tool : MIS Reports, Chart Reports, Stock Reports, Inventory Reports.
$20 USD in 10 days
5.0 (33 reviews)
5.3
5.3
User Avatar
Hi, Are you looking for a database administrator who can optimize your ms sql database to improve your website? I have enough experience work with indexing of the database and optimizing query so that I can finish this within short time. Please let me know and let us start. Regards.
$20 USD in 40 days
4.8 (10 reviews)
5.0
5.0
User Avatar
I am certificated .NET/C# programmer working with .NET 17 years. I was working with Microsoft and Borland software before switching on .NET. Different versions of MS SQL server I am using since 2000. Custom ISAPI filter and SQL 2008 says me that your database is large, old and is filled with entries that are rarely needed but use server resources. Partitioning can help you to solve the problem but Microsoft included this tool into most expensive configuration only. SQL Server WEB edition has no this feature. Verify your SQL server and contact me even your SQL server has no partitioning. Knowing Delphi, Borland CC Builder and Microsoft C++ I can help you but solution will not be easy if your application does not use ADO.NET.
$16 USD in 40 days
4.6 (2 reviews)
3.9
3.9
User Avatar
Hello, SEGES Creater. Thank you Sharing your job to me. I have read you requirement document carefully and fully understand what I have to do. Here are my questions for your project: --In terms of your schedule, this project has been developing from 1st Feb. Do I have to start your project and accomplish within middle of April? Let my know progress state of your project. -- Have you already built backend service? Your caculation logic have already built? If you want speed optimization, I recommend you to implement calc logic in front end. But else I can implement good code quality for calc logic. ------------------------------------- I am ready to right start away and can provide fulltime service on your timezone. It'll be comfortable for you to work with me as you will get daily reports about the work done, plans for the next day and questions if appear, it's really helpful for remote collaboration. I am very excited to get an interview from you and discuss this job here or on Skype. If you hire me for your project, I would guarantee that best quality, accurate-timeline, free and polite after-service, real-communication, fluent-conversation. Looking forward to discussing about your project soon with you. YOU WILL GET MY BEST!!! Best Regards Cui
$20 USD in 40 days
3.6 (5 reviews)
4.7
4.7
User Avatar
I worked for over 7 years at Microsoft as a Support Escalation Engineer for SQL Server. My specialty while I was on the team was SQL Server Performance and Tuning. I have tools available to me that would capture data in which I can analyze to determine the top bottlenecks on the server. I can both give you direction on what needs to be done to alleviate the immediate issue and perform a Health Check on the server to assist you in preventing potential pitfalls in the future.
$55 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
- Heavy troubleshooting of SQL related systems and processes. Creation of SQL scripts and custom work flows for specialized data. - Provide sensible solutions and feasibility for large scale concerns. - Troubleshoot processes, internal systems and databases. - Optimizing the codes for better performance
$16 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have done a lots of optimization work earlier for real time transactions processes mostly. I will definitely help in optimizing this project by rebuilding or refining or creating indexes. After winning this BID, I would be required answers of couple of questions regarding your requirement which will help me to fulfill your req: - 1) What is your database size 2) How many indexes are there currently? 3) How many Stored Procedure or SQL queries are being used in your projects? 4) Which fields are using mostly in the queries or Stored Procedures? Regards, Akshay Pitale
$16 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Buford, United States
5.0
3
Payment method verified
Member since Apr 15, 2010

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.