tempdb: what is internal_object_space, versionstore and userobjects.
Jun 08, 2015 at 03:14 PM
select SUM(internal_object_reserved_page_count)*1.0/128) AS [internal object space in MB],
(SUM(version_store_reserved_page_count)*1.0/128) AS versionstore,
(SUM(user_object_reserved_page_count)*1.0/128) AS userobjects
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Jun 08, 2015 at 03:14 PM
Seen: 62 times
Last Updated: Jun 08, 2015 at 04:07 PM
Are table variables only stored in memory
Can bad joins fill up TempDB
rebuilding indexes with always on
TEMPDB LDF size is increasing
TempDB Initial Size
Splitting tempDB files across CPU cores (multi-instance server?)
need to move tempdb from c drive to g drive
Can I create another tempdb?
SQL Server 2008 R2 - Shrink TempDB Error