posted on Friday, September 17, 2004 7:32 AM
by
hitachi
Profiling is a Good Thing (Part 2)
In a previous blog I talked about using SQL Server 2005 Profiler to trace events that occur when you process AS2K5 dimensions and partitions. Profiler also provides some useful information about how AS2K5 responds to a query.
I started off using the Standard (default) trace template provided with Profiler. Audit Login events let you know who has accessed your database. Discover Begin events occur when a browser requests database metadata. Query and Progress Report events let you watch the steps AS2K5 goes through to respond to a query. You watch as data is retrieved from each partition and tell when data is retrieved from cache. You can rerun a query and see that it is much less work for AS2K5 to respond
I think SQL Server 2005 Profiler is going to make it much easier to optimize queries.
- Scott