SQL Server Performance

Script to capture queryies info

Discussion in 'General DBA Questions' started by chetanjain04, Jul 19, 2006.

  1. chetanjain04 Member

    I want to be able to find out the following on a SQL server database:

    - No. of Queries and Query sttements executed on the server
    - No. of records affected by each of the query
    - the CPU and IO statistics of the query

    Is there any script available anywhere which I can refer. Basically, I want to present such data to my client and I cannot use Profiler. Does anybody have suggestions??


    Regards,

    Chetan
  2. FrankKalis Moderator

  3. satya Moderator

    Server side trace is far better if you need to monitor this on daily basis.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page