数据库开发
文章平均质量分 68
最爱午夜
这个作者很懒,什么都没留下…
展开
-
POVIT行转列
CREATE TABLE [Study].[Student]( [Sno] [varchar](10) NOT NULL, [Sname] [nvarchar](20) NOT NULL, [ClassID] [varchar](10) NOT NULL,PRIMARY KEY CLUSTERED ( [Sno] ASC)WITH (PAD_INDEX = OFF,原创 2013-07-18 09:10:52 · 641 阅读 · 0 评论 -
数据库动态管理视图DMV(1)
--优化查询计划花费时间SELECT * FROM SYS.dm_exec_query_optimizer_info WHERE [counter]='OPTIMIZATIONS' OR [counter]='ELAPSED TIME'--查询状态SELECT * FROM SYS.dm_exec_query_stats--等待任务SELECT * FROM SYS.dm_os原创 2013-07-19 09:27:53 · 897 阅读 · 0 评论 -
数据库动态管理视图DMV(2)
SELECT * FROM SYS.dm_os_memory_clerks WHERE [TYPE]='MEMORYCLERK_SQLBUFFERPOOL'SELECT * FROM SYS.dm_os_ring_buffers--缓冲池消耗内存总量SELECT sum(multi_pages_kb+awe_allocated_kb+virtual_memory_committed_k原创 2013-07-19 09:58:12 · 592 阅读 · 0 评论 -
数据库动态管理视图DMV(3)
--查询引发io最多的前10位查询或批处理SELECT TOP 10 (total_logical_reads/execution_count) AS AVG_LOGICAL_READS, (total_logical_writes/execution_count) AS AVG_LOGICAL_WRITES, (total_physical_reads/execution_cou原创 2013-07-19 10:00:19 · 478 阅读 · 0 评论 -
数据库动态管理视图DMV(4)
--查询tempdb中是否存在一个或多个正在获取页面锁的等待SELECT session_id,wait_duration_ms,resource_description FROM SYS.dm_os_waiting_tasksWHERE wait_type LIKE 'PAGE%LATCH_%' AND resource_description LIKE '2:%'--查询tempd原创 2013-07-19 10:01:28 · 622 阅读 · 0 评论