Report for highly used process and queries for a day

• neeraj.logix

  SSC Veteran

  Points: 287

  More actions

  December 21, 2011 at 7:12 am

  #262143

  Hi All,

  Need to create a report for top used processes and queries in same day and send out to admin. Also want to know job failed report, table space reports and backup failed report.

  Thanks,

  Neeraj

• salum

  SSCommitted

  Points: 1598

  More actions

  December 21, 2011 at 7:21 am

  #1424220

  You can use SQL server Dashboard report feature. here is nice article which will full fill your requirements.

  http://www.sql-server-performance.com/2007/dba-dashboard/

  java[/url]

• neeraj.logix

  SSC Veteran

  Points: 287

  More actions

  December 21, 2011 at 8:44 pm

  #1424551

  Thanks salum its really good

  Please let me know other custom option

  Anybody knows please share?