Sounds like you're talking about SQL Profiler. You can set up a trace of the activity on a certain database and then it was analyze the trace to tell you what can be optimized. You need to put some thought into trace though to get an active representation of usage on the DB your analyzing. Check out BOL read more about how it works.
~Cynthia -----Original Message----- From: Gonzo Rock [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 11:44 AM To: CF-Talk Subject: SQL Server Tuning Tools? I heard something about a MS-SQL Server tuning tool that monitors the activity on a database and then suggests what indexes on the tables might improve performance. Am I hallucinating or is such a thing available? Thanks, Gonz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199159 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
