October 6, 2005 at 5:38 am
HI, I have a database that is now on SQL but has come from a previous life as an access database. We are adding attional development on top of this database to meet our needs. Is there any SQL tools that you can run over a database to highlight where Best pratice has not been used or where there could be performance issuese?
October 6, 2005 at 6:30 am
This can get you started :
October 7, 2005 at 9:45 am
For performance issues, Query Analyzer's Index Analysis Wizard can evaluate existing indexes and suggest new ones. Put examples of common queries used in this database together in one script, then let the analysis wizard chew on it. If it suggests new indexes, don't automatically apply the changes. Save them as a script and review them first. Any suggestions you don't like or don't understand are either a bad idea or an indication that you need to look more closely at how those tables are used.
SQL Profiler is very useful for finding the worst-performing queries. That's a good place to start focusing your performance tuning efforts. You can also use it to capture a long period of activity into a trace file and let Index Analyzer Wizard go through that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply