Try experimenting with trace logs, there you should also be able to see how much cpu different actions/access takes. It can be hard to wade through all though.
Some info here, for instance, or try google or the MSSQl help. http://www.databasejournal.com/features/mssql/article.php/10894_2239461_ 1 -- Hugo Ahlenius ------------------------------------------------------------- Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone: +46 8 412 1427 UNEP GRID-Arendal Fax: +46 8 723 0348 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no Skype: callto:fraxxinus ------------------------------------------------------------- ########################################### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.f-secure.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235848 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54