You will get an MS SQL Server Job which Rebuilds Indexes Based on Rows and Fragmentation
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!]
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 SQLWhat's included $328
These options are included with the project scope.
$328
- Delivery Time 5 days
- Number of Revisions 4
- Number of Queries 8
- Query Debugging
- Query Optimization
- Query Scheduling
- Query Analysis
- Source Code
About Kenneth
Senior Database Designer/Administrator
Las Vegas, United States - 4:35 pm local time
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.