More than just setting up DBCC jobs

I want to cover Optimization more as an end to end task rather than a piece meal – setting up DBCC or Index Rebuil-ReOrg etc.

Database optimization should encompass all aspects of a Relational Database – including Hash Plans on Tables/Indexes/Pages etc.

Few of us in the industry are aware Statistics are important even when a table has no indexes – figure that.

I have seen that at multiple sites where previous DBA’s have setup Index maintenance plans thinking they were covered, but that was not the case.

Table with stale or old Statistics can cause immense delays in processing.

More on this in my next blog.

Read More

PROMO!

* Free for the first 5 new customers, only $499 for others.

What is included in this promotion:

• DBCC (database consistency check) commands
• Disk corruption identification and reporting
• Index allocation and corruption identification
• Index defragmentation % analysis

 

What is not included in this promotion:

• Resolution or solution to any error reported by above scripts
• Resolution or solution to any performance shortcomings or configuration changes pointed out by above analysis

 

Of course we can surely and efficiently provide and implement solutions for only $549.00. All charges and promotions quotes cover one SQL Server with 10 or fewer databases.

Read More