Should I Bother to Learn SQL Profiler?
Reluctant database administrators (DBAs) often feel like they’re on the receiving end of that “sledgehammer.” Performance issues can come back to haunt us, almost with a vengeance, and all too often it’s not for lack of proper planning. After all, we frequently build databases based on unrealistic or even nonexistent specifications. Still, we try to simulate what we believe the load characteristics will be like, such as the quantity of data to expect, the type and diversity of queries, and so forth. But human nature is unpredictable, and when we’re working with an Internet audience, the diversity is exponential.
KeywordsEvent Class Enterprise Manager Query Analyzer Percent Usage Security Audit
Unable to display preview. Download preview PDF.