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