Determine SQL Server memory use by database and object
来源:互联网 发布:报表数据分析 编辑:程序博客网 时间:2024/06/05 16:18
http://www.mssqltips.com/sqlservertip/2393/determine-sql-server-memory-use-by-database-and-object/
第一个query可以查询各个数据库使用内存的情况。
第二个query查询object,包括用户表和索引使用内存的情况。
下面这个query查询每个session使用内存的情况:
SELECT (requested_memory_kb/1024)/1024 as requested_memory_GB, *,t.textFROM sys.dm_exec_query_memory_grants mcross apply sys.dm_exec_sql_text (m.sql_handle) as tWHERE grant_time IS NOT NULLORDER BY m.requested_memory_kb desc
0 0
- Determine SQL Server memory use by database and object
- How to determine SQL Server database transaction log usage
- Caused by: java.sql.SQLException: Out of memory; restart server and try again (needed 142328 bytes)
- Pro SQL Server 2005 Database Design and Optimization by Louis Davidson
- clear sql server object by name
- SQL Server 2000 Database Design and Implementation
- Create a SQL Server Database and User for vCenter Server
- Stack----use database and link
- Pro SQL Server 2005 Database Design and Optimization
- Pro SQL Server 2008 Relational Database Design and Implementation
- How to backup and restore database in SQL Server
- Monitor SQL Server Memory
- SQL database common object type
- After restoring database in SQL Server, if you can't use diagram, execute these sentences
- How to use a SQL Server database with your PHP web site
- To upgrade the project database to use SQL Server LocalDB Express, …
- SQL Server system database
- GROUP BY, CUBE, ROLLUP and SQL SERVER 2005
- MyBatis中批量插入
- 一篇不错的SSIS性能很慢的分析
- kvm虚拟化学习笔记(二)之linux kvm虚拟机安装
- 前后台转码处理
- Android下EditText中的字体不统一问题
- Determine SQL Server memory use by database and object
- ipsec vpn 建立过程debug详解
- 给IT新人的15个建议
- 安卓分段上传文件、视频
- 转载tcp_wrappers
- 深入理解Linux进程间通信(IPC)-- Posix共享内存
- 查看Linux下每个进程的swap使用量
- hdu 4919 数论+大数
- 华为离职副总裁徐家骏:年薪千万的工作感悟