SQL Server Performance Investigation

$25-50 USD / hour

Teljesítve

Kiadva ekkor:

több mint 6 évvel ezelőtt

$25-50 USD / hour

For some reason one of our SQL Server databases seems to exhibit a performance issue where the various application components start timing out. We can go for several weeks with no problem, then for several days in a row the timeouts start to occur typically in the early afternoon and last until around 8:00pm. We need a MS SQL Server expert to investigate this and tell us what is causing the problem

Database Administration

Microsoft SQL Server

Projektazonosító: 15433446

A projektről

25 ajánlat

Távolról teljesíthető projekt

Aktiválva: 7 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@mpalgeo

Hi I am very experienced solving performance issues and i have done a lot of projects on that. I will use Profiler and other technics to find the problem and solve it. We must have full access on the db in order to create indices , statistics and alter [login to view URL] is your sql server edition and how big is your DB ?

$25 USD 15 napon belül

4,9

(69 értékelés)

6,2

25 szabadúszó adott átlagosan $38 USD/óra összegű árajánlatot erre a munkára

@sumon355

Hello, As an expert in ms sql server, i am very much interested to work to find out the reasons and improve the performance of your sql server. Looking forward to have a positive response from you. Thanks

$35 USD 40 napon belül

5,0

(129 értékelés)

7,3

@NallakumarKC

Hi, I am Nallakumar. I have more than 11 years of experience in MS SQL Server administration. This should be related to server configuration/hardware and some times due to bad indexing also. I need to monitor the load remotely during the entire time range when the issues are frequently happening. I believe, I can find the reason and fix them in the 16 hours quoted. Thanks, Nalla

$25 USD 16 napon belül

5,0

(54 értékelés)

7,0

@papon13

I am expert on SQL Server. I am interested on your project. I want to solve your sql server problem.

$50 USD 40 napon belül

4,7

(78 értékelés)

6,2

@SergioAlfaroV

I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience in SQL related projects and tasks. I am familiar with SQL audit tools and methods.

$35 USD 40 napon belül

4,9

(19 értékelés)

5,2

@intemo

Hi! I ofer you my skills. I'm working with MSSQL Server long time and hapy to help you in your problem.

$26 USD 40 napon belül

5,0

(31 értékelés)

5,2

@IMExpertEngineer

Hi, I'm expert sql server dba with over 10 years of experience in trouble shooting and fixing such issues. Can you please provide me which version of sql server you are using and also tell me if you are using sql server on a dedicated machine and what's machine cpu and ram . Please share these details and discuss further items with me. Thanks

$41 USD 40 napon belül

5,0

(7 értékelés)

4,8

@AliSafder

Hi, I can look in to the matter you are facing now and resolve it as per your satisfaction. You can see my profile where 60% of work done is about SQL Server improvement. So let me know when I can start? Thanks, Muhammad Ali Safder

$25 USD 40 napon belül

5,0

(24 értékelés)

4,6

@Splaszczyk

I may investigate your: 1 server side settings 2 server level and Database level WAITS STATS 3 Most IO consuming queries 4. Their query plans 5. Missing and redundant / unused indexes 6 Create an analyse a trace during peak period 8 Probably plenty more things i forgot to mention

$35 USD 40 napon belül

5,0

(3 értékelés)

4,3

@sopholos

Usually SQL slows down due next reasons: 1. Missing indexes (lock and seek whole tables). 2. Reading to much data (filter tables on client). 3. Slow hardware (obviously). Please specify credentials to check your server.

$78 USD 10 napon belül

5,0

(8 értékelés)

4,4

@mandalpu

I have over 20 years work experience in Oracle and SQL Server databases as DBA. I have worked with Oracle Corp and have taken training on Oracle internals. I have managed production environment for a hedge fund.

$41 USD 40 napon belül

5,0

(2 értékelés)

3,6

@AndreyBarykin

Have big experience as Senior Database Developer. Know well query optimization, performance analysis and troubleshooting on all server.

$25 USD 20 napon belül

5,0

(4 értékelés)

3,2

@arvind19821

first step checking the bandwidth for both read and write(finding the logical reads and physical reads) second step check for indexes rest processor usage, statement usage, waits

$27 USD 20 napon belül

5,0

(1 értékelés)

1,0

@Adnansayil

A proposal has not yet been provided

$70 USD 2 napon belül

0,0

(0 értékelés)

0,0

@technosystem

Project: SQL Server Performance Check Skills: VB, VB.NET, ASP.NET, MSSQL Experience: 11 Years Expertise: Desktop and webapp development Team Size: Dedicated Programmers

$41 USD 40 napon belül

0,0

(0 értékelés)

0,0

@optimatech

Hello, Experienced full time system admin here to help you investigate the SQL server performance. I bid for only 5 hours but it might takes less. It would not be fair to give you a time frame without looking at the database and see what is causing the problem. I would like to take a look at it and help you fix this problem. Please feel free to message me to discuss the details. Thank you

$25 USD 5 napon belül

0,0

(0 értékelés)

0,0

@robertmfertig

A proposal has not yet been provided

$44 USD 14 napon belül

0,0

(0 értékelés)

0,0

@kumarawgwh

I have enough knowledge about how database engine works, how SQL query execute, what are the best practices for maintain indexes and statistics, what are the best practices table partition and so on.

$41 USD 40 napon belül

0,0

(0 értékelés)

0,0

@burtonk

I can find the issue for you and help you understand what it takes to resolve it. I will put in place some custom stored procedures and jobs which will monitor the server as well as review the setup of the system to help understand what is going on. If you don't have monitoring software looking at the server we can get some set up -- your choice.

$41 USD 40 napon belül