I am very new to monitoring server performance. I am
familiar with setting up profiler or system monitor but
my main problem is what to track. I have tracked a lot
of stuff but then don't really know how to interpret it.
For example- I have an intranet site set up and users
access all reports from it. The reports are generated
from SQL Views. I would like to track the performance on
the views.
Also- IIS is installed on our SQL server- I would like to
track server performance over time so I can have some
hard data to present when the need to break IIS from SQL.