Advertisement

Should I Bother to Learn SQL Profiler?

  • Josef Finsel

Abstract

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.

Keywords

Event Class Enterprise Manager Query Analyzer Percent Usage Security Audit 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Josef Finsel 2001

Authors and Affiliations

  • Josef Finsel

There are no affiliations available

Personalised recommendations