Continued from page 1
Set up
chart windows with an interval of 18 seconds for routine, daily desktop monitoring.
Know
tools you are working with. Don’t be afraid to experiment.
Know
terminology (“objects” are lists of individual stats available; “counter” is a single stat; “instance” is further breakdown of a counter stat into duplicate components).
A bottleneck happens when
hardware resources can’t keep up with
demands of
software. This is usually fixed in one of two ways: first, you identify
limiting hardware and increase its potential (i.e. a faster hard drive or increase
speed of
computer); second, make
software processes use
hardware more efficiently.
Five areas to watch when improving SQL performance and identifying bottlenecks:
Memory usage CPU processor utilization Disk input/output performance User connections Blocking locks

Marisa Pellegrino is a freelance writer from Montreal and is the head researcher and content manager for SQL Server Database Recovery. www.sql-recovery.com