SQL Server Performance

what alerts you use

Discussion in 'SQL Server 2005 General DBA Questions' started by avipenina, Jun 14, 2008.

  1. avipenina New Member

    Hi,
    can you share what alerts you use to monitor your SQL server from the SQL server Agent Alerts and Perfmon sides?
    THX
  2. sdavidchuk New Member

    i think one of them that a must to have is an ' insufficient permissions' alert.
  3. ctics112 New Member

    I had the same question a couple of weeks ago and after doing some research I came across this website which prove to be useful.
    http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
    -Chris
  4. satya Moderator

    I prefer mostly on error 9002 (log size) & error 1105 (primary filegroup)/

Share This Page