Closed

WINDOWS AND SQL SERVER POOR PERFORMANCE ANALYSIS/SUGGEST SOLUTIONS

We have 14 servers with Windows Server 2008 R2 operating system.

6 data base servers (SQL Server 2010), 6 RDP severs and 2 Web servers with IIS 7.0

We installed windows servers monitoring tool on all severs.

The tool collects data on all servers and identified the below listed bugs.

We required real time experienced person on windows server and SQL Server TO IDENTIFY CAUSE OF POOR PERFORMANCE AND SUGGEST SOLUTIONS.

Should know the cause for the below listed sample of errors and steps to follow to fix the errors

We have many other errors reported by our server monitoring software tool.

DB Server performance issues :-

------------------------

1. Hard Disk Complaints

a. In peak time the Disk Queue length reaching around 70

2. SQL Server Abnormal activities observed in peak time

a. Compilations reaching around 35 per second

b. Lock wait time reaching around 11.37 per mille second

c. Page Splits around 9 per second

d. Full table scans are happening around 65.33 per second

Web Severs

-----------------------

3. There are now 10.27 per second errored packets, putting the host in a warn level.

This could be caused by incorrect application backlog parameters, or by incorrect OS UDP backlog queue settings.

Skills: SQL, System Admin, Windows Server

See more: disk queue length sql, suggest poor performance, peak time disk queue length reaching around, sql server web, real time data solutions, peak 10, d&d solutions, sql server or, SQL Server Admin, db solutions, windows system admin, windows servers, windows os, windows 2012, web rdp, system monitoring software, sql software, SQL Server, sql server c, sql server c# 2008, sql data analysis, Sql 2012, solutions, server issues, real analysis

About the Employer:
( 19 reviews ) San Diego, United States

Project ID: #2443883

8 freelancers are bidding on average $36/hour for this job

codetrance

I can help you. Thank you.

$40 USD / hour
(44 Reviews)
5.2
santossystems

Hi, I am interested in your system admin project. After reviewing the details of the project I am confident that I had enough experience to do a RCA of your issues. Please check inbox for more details.

$40 USD / hour
(5 Reviews)
3.6
AliSafder

Dear Sir, I have been in databases (like Sql Server, Oracle, Microsoft Access etc.), Programming Languages (VBA used in Microsoft Office products, .Net technologies(Asp.Net, Vb.Net / C#.net, mvc, wcf, ajax, jq More

$25 USD / hour
(2 Reviews)
1.2
VishalBarot

!!!!!!Please check PMB!!!!!

$50 USD / hour
(1 Review)
1.0
kiloskan

I like help. I have experience in optimization of servers with SQL Server.

$30 USD / hour
(0 Reviews)
0.0
ayamas123

Please check PMB

$25 USD / hour
(0 Reviews)
0.0
matthewp62

This is my first bid on Freelancer, however my experience as a Network and System Administrator is large, plus 8 yrs with many different systems. The last environment that I looked after was 150 servers large with man More

$27 USD / hour
(0 Reviews)
2.0
dcialdella

experience in +250 servers in Asia/Europe & America.

$50 USD / hour
(0 Reviews)
0.0
AndrewChen09

Specialize in SQL Server Performance Tuning and Optimization

$50 USD / hour
(0 Reviews)
0.0