SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2013

Looking for Buried Treasure in the Transaction Log

Lately, I’ve been finding more and more reasons to look in the transaction log for investigative purposes. Questions come up quite regularly asking how to determine who performed some action such as deleting data, changing logins, or disabling jobs. The first reaction may be that if you aren’t auditing for…

Read more

Bug: sys.dm_db_session_space_usage Reporting Extremely High Tempdb Allocations

A little more than a year ago while working at Idera, I was consulted on reports from a few clients using the Idera monitoring tool SQL diagnostic manager (SQLdm). SQLdm was reporting very high numbers for internal object allocations (internal_objects_alloc_page_count) and very low numbers for internal object deallocations (internal_objects_dealloc_page_count) to…

Read more