Results 1 to 5 of 5

Thread: Similar to statspack/AWR report

  1. 12-13-2007, 07:06 AM #1
    malay_biswal
    malay_biswal is offline Registered User
    Join Date
    Dec 2007
    Location
    Bangalore
    Posts
    3

    Similar to statspack/AWR report

    Is there anything similar to AWR/statspack report in SQL Server 2005.
    Reply With Quote Reply With Quote
  2. 12-13-2007, 10:42 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    What's AWR/statspack report?
    Reply With Quote Reply With Quote
  3. 12-13-2007, 01:48 PM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    No. You will have to write your own script. SQL Server provides many dynamic performance views, which you can query to get the similar result.

    There are third party tools that capture the information and show the historical trends, etc. There is one called Indepth (it is owned by Symantec now)
    Reply With Quote Reply With Quote
  4. 12-13-2007, 04:32 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Microsoft has performance dashboard for sql2k5, download it and check out.
    Reply With Quote Reply With Quote
  5. 12-14-2007, 02:20 AM #5
    malay_biswal
    malay_biswal is offline Registered User
    Join Date
    Dec 2007
    Location
    Bangalore
    Posts
    3
    Thanks for the info.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules