You will get an MS SQL Server Job which Rebuilds Indexes Based on Rows and Fragmentation

Kenneth M.
Kenneth M.

You will get an MS SQL Server Job which Rebuilds Indexes Based on Rows and Fragmentation

Kenneth M.
Kenneth M.

What's included $328

  • Delivery Time5 days
  • Number of Revisions4
  • Number of Queries8
    • Query Debugging
    • Query Optimization
    • Query Scheduling
    • Query Analysis
    • Source Code
5 days delivery — Aug 22, 2022
Revisions may occur after this date.
Upwork Payment Protection

Fund the project upfront. Kenneth gets paid once you are satisfied with the work.

Project details

Are you having problems keeping up with index maintenance? Do you wonder why your application is running soo-o-o--o.. slowly? Let me take a look at your MS SQL Indexes. Lack of proper index maintenance or indexing are primary causes of web or application performances. But wait! (Pun) You've got so many of them! How do you keep up with the ones causing the problems?
I'll check your MS SQL indexes and (if necessary) create a routine maintenance job based on fragmentation and table row sizes. The routine will determine if an index rebuild or reorganize is necessary. I'll also suggest "Fill-Factors" and provide an "on-Demand" or scheduled report to view index information in an SSRS report.

I'll …
- Work with your assigned person to determine which indexes need attention
- Analyze your index structure
- Build and test an index maintenance routine within your UAT environment
- Produce SQL Script which will create and schedule an SQL Agent job for production
- Identify HEAPs!

You'll get Scripts, Jobs, Workflow Diagrams and Reports... (onto your SSRS Server). Maintenance wizard is an option, but its a wizard! [...and you know WIZARDs!]
 
Database Type MS SQL
What's included $328 These options are included with the project scope.
$328
  • Delivery Time5 days
  • Number of Revisions4
  • Number of Queries8
    • Query Debugging
    • Query Optimization
    • Query Scheduling
    • Query Analysis
    • Source Code

About Kenneth

Kenneth M.
Senior Database Designer/Administrator
Senior Database Designer/Administrator
Las Vegas, United States - 8:08 am local time
I'm an MS SQL Server Database Developer offering 10+ years database installation, configuration and maintenance experience with 6 of those years as a developer inclusively. My experience includes data transformation, integration, as-well-as backup and restore. Additionally, my current and past experiences include:

Creating data processes using SQL Databases, SSRS and SSIS (VB.NET);

I've a talent for problem analysis, an imagination for project organization/implementation, and an ability to absorb and apply IT related information accordingly.
 

Steps for completing your project

After purchasing the project, send requirements so Kenneth can start the project.

Delivery time starts when Kenneth receives requirements from you.

Kenneth works on your project following the steps below.

Revisions may occur after the delivery date.

Analyze Current Index Maintenance Window and Workflow

I'll do this by checking the index maintenance window and schedules. Once completed, I'll give you a VISIO presentation on what your new routine will do.

Inventory Table-Rows, Index-Sizes, and Fragmentation-Growths

I'll use a query to count the number of rows in each of your MS SQL Tables and get the names and sizes of those table's indexes and fields being indexed.

Review the work, release payment, and leave feedback to Kenneth.