There are the following tools you can used to monitor the performance:

  1. http watcher professional
    1. Install it.
    2. Open it by clicking View->Explorer Bar->HTTPWatcher Professional
    3. Visit a web page to watch the performance.

      (Before watching, you need to click Record button in the tool.)

  2. Performance tool built in the OS
    1. Click Control Panel->Administration Tools->Performance
    2. If want to view other performance indexes, you can right click the graph and select Add Counters
  3. Performance tools built in SQL Server
    1. Profiler
      1. Click SQL Server Profiler in SQL Server tools of the SQL Server group of Start->Program.
      2. Start new trace by clicking File->New trace, and connect to a database.
      3. In the Trace property, you can set what should be traced by clicking Events Selection tab.
      4. Click Run to start.

        (before it runs normally, you may need to change the system font to TrueType)

You can monitor the performance of a store procedure, a SQL command, etc.