MS SQL performance and analysis tools

Posted on 2005-05-12
Last Modified: 2011-03-23
We have a large MS SQL application.  I am looking for tools that will install on the server and intercept all SQL commands to the server, and tell me when they came in and how long they took to complete, and if possible, the amount of resources they took up - CPU and disk.  Is there anything out there?


John Barry
Question by:johnjbarryjr
    LVL 4

    Expert Comment

    and they have a free 14 day trial

    you can also get some  basic insite with the sql servers PROFILER

    LVL 6

    Accepted Solution


    Tools for SQL Server management !
    Support Tools Available For Stress Testing & Performance Analysis

    Download your Free Evaluation Copy of Coefficient and Recover Lost Server Performance

    Free Downloads Other - Tools
    1. SQL diagnostic manager (SQLdm) provides increased availability and faster time-to-recovery for database problems
    2. SQLconfig monitors database server hardware, operating system (OS), SQL Server instance and database configuration, providing both automated change notification and comprehensive reporting on changes in your SQL Server environment.
    3. DTx simplifies and accelerates the task of migrating data across databases and platforms. Whether you are implementing a new application, building a data warehouse, migrating databases, integrating data from partners or legacy applications DTx provides a powerful, cost-effective and easy-to-use solution.

    Optimizing Microsoft SQL Server Analysis Services:
    Optimization Tools: The Storage Design Wizard
    The primary focus of this series will be the introduction of optimization tools and concepts for MSSQL Server Analysis Services (“MSAS”). The series is designed to provide hands-on application of the fundamentals of MSAS optimization from multiple perspectives

    SQL Server 2005 Part 1 - Tools


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Introduction: I have seen many questions on EE and elsewhere, asking about how to find either gaps in lists of numbers (id field, usually) ranges of values or dates overlapping date ranges combined date ranges I thought it would be a good …
    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now