There are some Microsoft tools that can help monitor your database performance:
networks
Get all the benefits of Microsoft SQL Server 7 with none of the headaches. in wizards, the Enterprise Manager, and the Query Analyzer. use stored procedures, save time by automating common tasks with Jobs and Alerts, import and export data to and from an SQL Server database, and keep your data secure and backed up with the tips, tricks, and techniques you'll discover inside Microsoft SQL Server 7 For Dummies. have SQL Server tools, too, including programs for automatically building multitier applications, creating SQL Server objects, friendly Visual Basic code.
toner
Microsoft Operations Manager (MOM)
He runs the local SQL Server users group in Jacksonville (JSSUG) and was on the Board of Directors of the Professional Association for SQL Server (PASS).
cheap laptops
end application tuning (not specific to SQL Server), but then very quickly move to SQL Server specifics, starting with the high level stuff like the basic server resource counters for CPU, memory, and IO, then trying to find the slow queries by looking at SQL Wait types, and using Profiler to find long running, or blocked, or otherwise poorly performing queries. We then move on to demonstrate how to "fix" the performance of those poorly performing queries.
wholesale
Performance Monitor
sqlservr.exe is the main executable relating to Microsoft's SQL Server Suite. This server application provides industry standard and flexible SQL server services. This program is important for the stable and secure running of your computer and should not be terminated. Check that sqlservr.exe is stable on your computer.
brother
(ships with Windows)
Errata Description Chapter (PDF) Table of Contents (PDF) Index (PDF) Author Information Complete. Authoritative. Practical. The only SQL Server book you need. Mastering SQL Server 2000 is the one indispensable resource for anyone working with the latest version of SQL Server. Whether you build or administer SQL Server databases or write applications that communicate with them, you'll find the background knowledge and the practical instruction you need to accomplish any task, from the most basic to the most advanced.
netvista
camera
SQL Profiler
networking
(ships with SQL Server client tools)
sharp
cheap
There are also some third-party tools:
windows
monitors
BMC DBXray
linux
computer support
BMC Patrol
used laptops
cameras
Embarcadero Performance Center
scanners
panasonic
Heorix eQ
workstation
iseries
HybridX SQL Spy
backup
information technology
Intrinsic Design Coefficient
routers
180gxp
Mercury Interactive SiteScope
notebook battery
security
Micromuse Netcool
lotus
virus
NetIQ AppManager
thinkpad t42
thinkpad 600
NetIQ DiagnosticManager
thinkpad 600e
thinkpad 570
PUREnetworking ServerMonitor
thinkpad 600x
thinkpad 390x
Quest Foglight
thinkpad a31
thinkpad x20
Quest I/Watch
bios update
laptops
Quest Spotlight
toshiba
laptop battery
SQL Server Monitor
thinkpad
(The site has a demo, but doesn't make it clear how to obtain the code/product.)
microsoft
laptop computers
Veritas InDepth
laptop computer
(formerly a product from Precise)
desktop computer
notebooks
Zero Impact SQL Monitor
lenovo
hard drive
Keep in mind that you probably don't want these products running against your SQL Server machine 24x7, since they may take resources away and actually contribute to the problem. I'm sure they are tuned to prevent that, for the most part, but it's doubtful that they could do anything useful without adding *some* resource drain.
travelstar
gateway
If you're troubleshooting a performance problem, might want to double-check configuration options against the recommended set; see the following KB articles.
laptop parts
software
KB #319942 HOW TO: Determine Proper SQL Server Configuration Settings
hard drives
electronics
KB #310834 PRB: Common Causes of Error Message 844 or Error Message 845
canon
desktop pc
KB #298475 HOW TO: Troubleshoot Application Performance Issues
desktop computers
think pad
KB #297864 INF: Performance Considerations for Upgrade from SQL Server 6.5
repair
data recovery
KB #254321 INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
cisco
keyboard
KB #243589 INF: Troubleshooting Slow-Running Queries on SQL Server
monitor
desktop
KB #243588 HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
infosys
KB #224587 HOW TO: Troubleshoot Application Performance with SQL Server
