eData Usage Analyzer
Which data do users access the most? Which applications use which data the most? If you ever ask yourself these questions, then the eData Usage Analyzer may be beneficial to you. This tool is designed to analyze all production SQL Server queries, 24×7, with the purpose of identifying data usage and response times.
More specifically, it tracks:
- End-user level statistics, such as average end-user response time, database response time, network time, rows returned, and the number of queries ran by each user.
- Frequency and time distribution of table column query usage by database, application, and end-user.
- Frequency and time distribution of table joins, and table columns used in WHERE clauses, ORDER BYs, and GROUP BYs.
- Identification of infrequently or not used data columns, tables, and views.
This information tells what data users are using, and not using, which can be very helpful when analyzing current and future use.
Sql Loopback Monitor
This tool allows you to monitor SQL code for batch processes, web servers, n-tier architectures, application servers, and telnet sessions that run on the same platform as the database server. Normally, this code cannot be captured because it is not run over the network. But the Sql Loopback Monitor has the ability to capture this code as it is being executed, for analysis by other tools in this tools suite. This product is currently available for UNIX, and will become available for Windows in 2004.
Not Just for Windows and SQL Server
Although I have described this suite of tools as Windows and SQL Server-based, this is not entirely the case. If you run in a mixed operating system or database environment, these tools are also available for monitoring client database activity on the AIX, HP-UX, AS/400, DEC UNIX or VMS, Linux, OS/390, Sequent, SCO Unix, and Solaris operating systems; and these databases: DB2, Informix, Oracle, and Sybase. The GUI component of the software runs under Windows 95, Windows 98, Windows NT 4, Windows 2000, Windows XP, and Windows 2003. The monitoring component can run on AIX, HP-UX, Solaris, Windows 95, Windows 98, Windows NT 4, Windows 2000, Windows XP, and Windows 2003.
Can This Tool Suite Really Help Me?
If you have a single SQL Server with a couple of dozen users, then the Sql Power Tools suite of tools is probably more than you need. But if you are part of a large shop with multiple platforms, running multiple database servers, have hundreds or thousands of users, and performance is critical to your organization’s success, then you should definitely investigate the Sql Power Tools suite. Find out more about these tools at http://www.sqlpower.com/.
]]>