Image of DIAB Icon  Screen shots showing DIAB's assortment of tools to monitor, troubleshoot, and improve SQL Server Performance

DBA In A Box  we save you money
SQL Software for: SQL server performance tuning, SQL server performance dashboard, Query tuning, SQL server performance history, SQL replication monitor, SQL database monitoring, SQL analyzer, SOX compliance, with tools designed to: scan, alert, and investigate, SQL server failures.
About Us
Screen Shots
Contact Us
Purchase DIAB
System Requirements
SQL every DBA needs

go to

DIAB's Top 10 Scorecard can help you determine what is impacting your server the most. 

DIAB Scorecard

DIAB Analysis is the start point for problem solving. This screen shot is displaying Sessions from the DMV scripts This shows detailed information about the connections to a SQL Server. 

screen shot DIAB Analysis

Job History for tracking query performance  

screenshot showing query performance analysis

3D Realtime Charts display server performan in a whole new light. All 3D charts allow for rotate, tilt, zoom, and resizing.

Screenshot show DIAB 3D Monitoer

DIAB integrates with SQLH2 for trend analysis and historical data.

Trend Analysis

SQL Code Checker verifies sql code for SOX compliance, security,
SQL best practices, and table and clustered index scans.

Screen Shot of SQL Code Checker

The trace menu executes a fast trace on a SPID, login or application for problem analysis. Quickly identify deadlocks, find exact instructions in complex applications causing failures, freeze the trace and step through the code from the moment an application starts to the point of failure. DIAB Trace is also much easier and quicker to user than SQL profiler.   

Figure 7
Screen Shot of Trace

Analyzing the Hardware

Selecting Quick Diagnostics will give you a fast overview of what’s happing with CPU, drive utilization, memory, and network bandwidth on the server in real time. From here you can decide whether to dig into diagnosing the hardware or quickly move to diagnosing the queries. There are no refresh buttons to push and no reports to run, just fast results while they’re happening. The screen below shows the C: drive is taking a huge load and paging is being heavily used. 

Figure 8

Quick Diagnostices

Monitoring memory issues can be one of the hardest chores a DBA can encounter. There are hundreds of counters you can monitor but DIAB has the key counters right at your fingertips, Below we see a high volume of paging which could mean it's time to investigate how memory is being utilized. 

DIAB Memory Analysis

Disk diagnostics probably consumes a DBA’s life more than anything else. Without the proper knowledge of disk configuration techniques, you may quickly find yourself in trouble. Consider all the things in designing a server that affect disk performance: file groups, raid levels, temp storage, logging, replication, indexing, it’s an endless list. DIAB Disk Analysis will quickly help you determine which disks are problematic. 

Screen shot of disk transfer

Click any one of the drive command buttons and dig even deeper into what’s happening on a single drive. The screen below shows the C: drive getting hammered, disk queue is above 0 and we have a high volume of transactions. 

Screen Shot of disk analysis by drive.

CPU Analysis will quickly tell you if your CPU's are being overwhelmed. 

Screenshot showing CPU Analysis

SQL Analysis

SQL Analysis displays important counters that can be used to identify slow server performance. Notice the counter, Full Scans/sec displaying some high numbers, this may be an indicator you need some indexes.

Screen Shot SQL Analysis

Configuring DIAB

DIAB’s configuration menu is easy to navigate. Tooltips will help you with entering the information about your servers. EZ setup makes entering  information about your servers easy by automatically filling in the the information for you.

Configuration Screen Shot

Database Statistics

DIAB makes it easy to gather information about your database tables. Table statistics data can help you identify which tables need to be reindexed, archived, or normalized.

Screen Shot of Table Statistics


Home | About Us | Screen Shots | Contact Us | Downloads | Purchase DIAB | System Requirements | Sitemap