SQL Server Maintenance Solutions

$10-30 USD

Completed

Posted

over 6 years ago

$10-30 USD

Paid on delivery

I want to have a Index maintenance process that include mechanisms for better logging / reporting and pick up the Index Fragmented tables. I could make things run in parallel to get better utilization of the hardware during the maintenance window and hopefully reduce the time required to perform the day to day maintenance in their database.

Database Administration

Microsoft SQL Server

SQL

Windows Server

Project ID: 15468496

About the project

12 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@mpalgeo

I can make code to find the most fragmented table and indices and automatic maintain them, also suggest the best indices according to the usage. Relevant Skills and Experience MSSQL Proposed Milestones $32 USD - My hourly rate is $27. How big is the DB.

$500 USD in 30 days

5.0

(78 reviews)

6.4

12 freelancers are bidding on average $118 USD for this job

@scsBiswas

I am interested.

$200 USD in 5 days

5.0

(28 reviews)

4.7

@CHREHAN

I have almost 5 years of experience in Business Intelligence, ETL, Database Development, Database Optimizations, Database Design and BigData. So I will provide you best possible solution. Relevant Skills and Experience Relevant Skills and Experience ETL (SSIS) SSAS Pentaho BI SUIT Database Designing Database Development Query Optimization. Index Building SQL Scripting BigData Cassandra Proposed Milestones $133 USD - Required work When you want me to start work ?

$133 USD in 2 days

4.8

(5 reviews)

2.3

@mandalpu

I can give you a index rebuild script which has options to set threshold levels, max dop, timelimits logs which can scheduled during weekends or off hours. Relevant Skills and Experience I have over 20 years experience in SQL Server and Oracle DBA activities and worked with Oracle Corp in Support and in another top hedge fund as a Prod DBA Manager Proposed Milestones $50 USD - On acceptance $61 USD - On completion

$111 USD in 3 days

5.0

(2 reviews)

0.9

@meliasdb

I could create a table for get a percentage of fragmentarion of index, when the percentage are greater or equal 30% the job execute a reorganize, if percentage are greater that 30% execute a rebuild. Habilidades y experiencia relevante I have 6 years experiences for mantenaces for sql server, obtaining improvements and best performance in the queries and index. Htos propuestos $5 USD - Create table for get information about fragmentation and historical $15 USD - Rebuild and reorganize index $10 USD - create missing , cost, unused index Servicios adicionales ofrecidos $10 USD - Get report I/O for issues in disk and queries do you want other maintenance?

$30 USD in 2 days

0.0

(0 reviews)

0.0

@mitramay

A proposal has not yet been provided

$25 USD in 1 day

0.0

(0 reviews)

0.0

@harisankarkr

Have been working in SQL server for the past 10+years; Used to do querying, database maintenance and performance tuning to get optimum result. Relevant Skills and Experience SQL Server; 10+years Proposed Milestones $30 USD - Advance $120 USD - Completion of analyze and understanding the root cause $72 USD - Post to applying the solution Hope I can have access to a replica environment for testing

$222 USD in 3 days