Archives for: "May 2013"
Discrepancy by estimated TEMPDB space for CHECKDB and CHECKALLOC - WITH ESTIMATEONlY
I came around this problem (depends on SQL Server 2008 R2 jutst to SQL Server 2012) by reading Paul S. Randal's and Ana's blog posts:
How does DBCC CHECKDB WITH ESTIMATEONLY work (Paul)
DBCC CHECKDB WITH ESTIMATEONLY: Do you trust it? (Ana)
DBCC… more »
SQL Server 2012 Tempdb File Size Change tracked with Extended Events
We are using SQL Server 2012 and the tempdb is growing so fast. How do I effectively find what’s causing my tempdb growing. Can I monitor the file size change with Extended Events to find out the ... more »
