Tag Info

New answers tagged


I asked for something built in back in 2007, but this was rejected for the 2008 release, and subsequently ignored. Feel free to vote and, more importantly, comment about your business need. In the meantime, for SQL Server 2005 and 2008, you should be able to pull this information from the default trace: DECLARE @FileName VARCHAR(MAX) SELECT @FileName = ...


Here's a query that should get you started on finding out the information you're looking for: select top 10 tsu.session_id, tsu.request_id, r.command, s.login_name, s.host_name, s.program_name, total_objects_alloc_page_count = tsu.user_objects_alloc_page_count + tsu.internal_objects_alloc_page_count, ...

Top 50 recent answers are included