Monday, 20 April 2020
MS SQL Server Space / Memory Manegment
Execute This
SELECT SUM(unallocated_extent_page_count) AS [free_pages]
,(SUM(unallocated_extent_page_count) * 1.0 / 128) AS [free_space_MB]
,SUM(version_store_reserved_page_count) AS [version_pages_used]
,(SUM(version_store_reserved_page_count) * 1.0 / 128) AS [version_space_MB]
,SUM(internal_object_reserved_page_count) AS [internal_object_pages_used]
,(SUM(internal_object_reserved_page_count) * 1.0 / 128) AS [internal_object_space_MB]
,SUM(user_object_reserved_page_count) AS [user object pages used]
,(SUM(user_object_reserved_page_count) * 1.0 / 128) AS [user_object_space_MB]
FROM sys.dm_db_file_space_usage;
GO
Subscribe to:
Post Comments (Atom)
-
Logical operators and symbols Google can understand three logical operators: AND, NOT and OR, so Google recognizes the “OR” as the oper...
-
In one of our previous articles, we've shown how to manage your disks using the Disk Management utility. Now it's time to see how ...
-
A hard drive has only a few basic parts. There are one or more shiny silver platters where information is stored magnetically, there...
No comments:
Post a Comment
Thank You!!!