【小5聊】sql server之查询sqlserver.exe占的内存以及快速查询表记录的总数

【查询所占内存语句】

--查看SQLServer占用内存
select  
(physical_memory_in_use_kb/1024) as Memory_usedby_Sqlserver_MB,  
(locked_page_allocations_kb/1024) as Locked_pages_used_Sqlserver_MB,  
(total_virtual_address_space_kb/1024) as Total_VAS_in_MB,  
process_physical_memory_low,  
process_virtual_memory_low  
from sys.dm_os_process_memory;

【快速查看表记录总数】

SELECT  OBJECT_NAME(ID), b.rowcnt as sumcount,b.*
  from sys.tables a
  inner join sys.sysindexes b on a.object_id=b.id
  where  b.indid<=1
ORDER BY b.rowcnt DESC

【以下方法比较靠谱 】

select 
	   object_name(object_id)    as tableName, 
       i.name                    as indexName,
       p.rows                    as rowsCount
from sys.partitions  p
left join sys.sysindexes i on p.object_id = i.id and  p.index_id = i.indid  
where object_id = object_id('输入自己数据库的表名称')