May 23, 2003 at 2:31 pm
Is there a good strategy when it comes to analyzing your database design using profiler? I have a site which is starting to get some decent traffic and I want to see if there is room for improvement with some of the main queries I use.
Would profiler help in determining this? If so, is there some instruction somewhere with info on which events to trace and what the results mean?
Thanks,
Andrew
Andrew
http://eshopsoho.com
May 23, 2003 at 7:43 pm
Profiler will help you determine what queries are being executed. You can use a trace along with the Index Tuning Wizard to get some suggestions on how to go about attacking performance issues. That'll get you started. From there you can start looking at the longest running queries (though admittedly quite a few people have posted that Profiler's times look more like a ballpark figure than a scientific measurement), figure out if you can optimize either by restructuring the query or adding indexes as appropriate.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 24, 2003 at 11:03 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply