|
Enterprise-wide SQL
Server Performance Monitoring, Tuning, and Alerting
|
|
|
- Real-time & historical performance monitoring
across users & applications
- Enterprise-wide e-mail alerting (Uptime, jobs, SQL,
deadlocks, & blocks)
- Performance analysis & tuning (SQL, jobs, cache,
memory, disk, network)
- Isolate and fix performance bottlenecks, publish
web reports,
and
more...
|
|
 |
Fully-functional 7-day free trial, 3 MB (FREE
for SQL Server Express. No activation required) |
 |
$295 per server (30 day money back guarantee) |
|
"I can honestly say that if all software companies were as
knowledgeable and quick to serve their customer, no one would complain
about software functionality ever again. I whole heartedly
recommend Teratrax to anyone who manages SQL Server based applications"
Jerry Sommerville
DBA, Crown Equipment Corporation
|
Teratrax Performance Monitor allows you to significantly reduce time
spent on collecting scattered Microsoft SQL Server performance data and
user activity across your enterprise leaving you with more time to spend
on other tasks. It monitors SQL Server instances using a low-footprint
technology and collects performance information that you can analyze
with an easy-to-understand user interface. You can monitor real-time
activity or go back in history and correlate performance data over time.
Analyzing the history of key performance indicators like cache hit
ratios, slow SQL code, and system utilization (memory, CPU, disk,
network, etc...) helps you identify busy periods, eliminate bottlenecks,
and increase SQL Server throughput.
Alerting features in Teratrax Performance Monitor allow you to
monitor all your enterprise servers and get notified when any server
stops responding or when a job fails or slows down. Whether you have a
few dozen jobs or hundreds of jobs, Teratrax Performance Monitor can
save you long hours of manually checking the status of individual SQL
Agent jobs. Alerting is also available for slow SQL code, deadlocks, and
SQL Server blocks. You can easily create custom e-mail alerts and stay
updated on the status of your SQL Server operations.
|
|
Intel Pentium III or compatible 600 MHz or higher processor
256 MB of RAM
15 MB of hard disk space
|
SQL Server 2005 - All Editions
SQL Server 2000 - All Editions
|
Windows Server 2003
Windows XP
Windows 2000 (SP3 or higher; ADO 2.7 or higher)
|
Low footprint, light-weight monitoring agent with e-mail
alerting
 |
Monitors SQL Server uptime (Sends e-mail alerts when a
server stops responding) |
|
|
Monitors SQL Server instances locally or remotely |
|
Real-time and historical monitoring of SQL Server
performance counters
|
|
Real-time and historical cache hit ratios charting
(buffer/data cache and procedure cache) |
|
|
Real-time and historical charting for CPU and memory |
|
|
Real-time and historical disk reads/writes and network
traffic |
|
SQL code tracing, historical analysis, and e-mail alerting
|
|
Near real-time and historical analysis of executed SQL
batches, stored procedures and RPC events |
|
|
E-mail alerting for slow SQL events with customizable
duration thresholds |
|
|
Cost analysis and charting of SQL events (Duration, disk
reads/writes, CPU time) |
|
|
SQL code source tracking (User, process, client machine,
application) |
|
SQL Agent job execution analysis and e-mail alerting
|
|
Slow and failed SQL Agent job detection with custom
duration configuration |
|
|
E-mail alerting for failed and slow jobs (Includes
reasons for job failure and reported error messages) |
|
SQL Server concurrency reporting and e-mail alerting
|
|
Real-time deadlock detection and alerting (Reports
application and SQL code causing the deadlock) |
|
|
Real-time SQL Server block detection and alerting
(Reports block duration and SQL code causing the block) |
|
Reporting of current user connections, transactions, and
security alerts
|
|
Current activity monitoring (User connections and open
transactions) |
|
|
Security attacks monitoring (Failed login attempts with
error messages and IP locations) |
|
Web reports, data export, and database views
|
|
Web reports publishing for all areas of performance |
|
|
Exporting of performance data into Microsoft Excel (CSV) |
|
|
Built-in database views for ad-hoc queries, custom
reports, and application interface |
|
|
|
Related Articles
SQL Server Performance Counters
The most important performance counters to watch when tuning SQL
Server performance are CPU usage, memory usage, cache hit ratios, and
disk I/O. Even though CPU capacity and available memory are crucial,
disk I/O is frequently the cause of bottlenecks in most systems. Paying
extra attention to disk I/O and cached disk access is worthwhile.
Read more...
SQL Server Blocking and Deadlocks
The more blocking happens on SQL Server the less concurrency the system. A
certain amount of short blocks are unavoidable but too many blocks for longer
periods of time can degrade performance and increase the chances of SQL Server
deadlocks.
Read more...
Advantages of SQL Server 2005 (64-bit)
64-bit processors are expected to dominate the markets by the end of 2007. It is
clear that the industry is moving towards the 64-bit platform fast, especially
for server hardware. The move towards the 64-bit platform has been driven by
lower hardware prices, especially after the introduction of x64 architecture by
both Intel (EM64T) and AMD (AMD64).
Read more...
SQL Server performance tips
SQL Server performance tuning can consume a considerable amount of time and
effort. The following list is a quick guideline that you should keep in mind
when designing and developing SQL Server database applications.
Read more...
|
|
|
