Screen shots showing DIAB's assortment of tools to monitor, troubleshoot, and improve SQL Server PerformanceDBA 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.
SQL every DBA needs
DIAB's Top 10 Scorecard can help you determine what is impacting your server the most.
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.
Job History for tracking query performance
3D Realtime Charts display server performan in a whole new light. All 3D charts allow for rotate, tilt, zoom, and resizing.
DIAB integrates with SQLH2 for trend analysis and historical data.
SQL Code Checker verifies sql code for SOX compliance, security,
SQL best practices, and table and clustered index scans.
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.
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.
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.
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.
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.
CPU Analysis will quickly tell you if your CPU's are being overwhelmed.
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.
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.
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.