I'd like to review what DBs, Tables, Queries and Stored procedures are using the most resources (mainly ram). I know that you can use the SQL profiler to see operations and such, but I'd like to know what in my SQL server is 'holding onto' memory, what's using the most, where I can tighten up, etc. And if the answer is 'read this book', then let me know the best book(s) to read and I'll do so. Thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get help! RoboHelp http://www.houseoffusion.com/banners/view.cfm?bannerid=58 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2159 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
