Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation







SQL Server Health Checks

BC has developed the world's most comprehensive SQL Server health review strategy to ensure that your database meets or exceeds generally recognized performance standards.

  • Does your boss blame you for a performance problem?
  • Do you need to certify that your database is optimized?

SQL Server health Check Details

When you start your contract for SQL Server Remote DBA, we perform an exhaustive check of all SQL Server components to ensure that your SQL Server database follows industry best practices:

I/O distribution analysis - I/O details for databases and files are obtained, and for SQL Server 2008, we drill down and get I/O distribution at the object level.  We check I/O distribution using a real workload and find likely candidates for physical disk relocation or redistribution.

Hardware review - We review your complete external hardware to identify potential bottlenecks and areas of contention. This step examines disk I/O latency (seeking disk bottlenecks) and a cursory review of Network, RAM and CPU utilization.  For RAM, if pages/sec consistently high, this indicates paging and swapping activity

Windows review - We verify your release and patch levels for Windows. We also review SQL Server integrity checking. We also check SQL auditing setting.

Log Review - We also examine all logs (Windows Event Logs, SQL Server logs and SQL Agent logs) for alerts and important messages.

Transaction log inspection - We review the transaction log for optimal size and bottlenecks.

TEMP space review - We review tempdb to ensure optimal sizing (disk sorts).

Table pinning review - BC identifies heavily accessed objects that can be improved by placing them in their own filegroups, assuming separate I/O controllers exist for distinct hard drives, the best place for objects to reside will always be memory.

Table fragmentation check - We check and repair table fragmentation which  is a natural result of table usage that can cause performance degradation.

Server Configuration Options check - BC verifies that all SQL Server configuration parameters are optimized for the system workload.

Review Scheduled tasks - Review users and document all auto-start and SQL services options

Don't trust your SQL Server system to beginners, get a health check from the SQL Server experts.



Remote DBA Service

Oracle Tuning Book


Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software










BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.

Hit Counter