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...
-
A hard drive has only a few basic parts. There are one or more shiny silver platters where information is stored magnetically, there&...
-
introduction How to delete duplicate records from a SQL data table using CTE (common table expression). Specifies a temporary named result...
No comments:
Post a Comment
Thank You!!!