There are the following tools you can used to monitor the performance:
- HTTP watcher professional
- Install it.
- Open it by clickingView-> explorer bar-> httpwatcher professional
- Visit a web page to watch the performance.
(Before watching, you need to clickRecordButton in the tool .)
- Performance tool built in the OS
- ClickControl Panel->Administration Tools->Performance
- If want to view other performance indexes, you can right click the graph and selectAdd counters
- Performance Tools built in SQL Server
- Profiler
- ClickSQL Server ProfilerInSQL Server toolsOfSQL ServerGroupStart->Program.
- Start new trace by clickingFile-> New trace, And connect to a database.
- InTraceProperty, you can set what shocould be traced by clicking events selection tab.
- ClickRunTo 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.