- 博客(6)
- 收藏
- 关注
原创 数据库索引使用情况
SELECT SERVERPROPERTY('IsClustered') SELECT DISTINCT OBJECT_NAME(SI.object_id) AS Table_Name , SI.name AS Statistics_Name , STATS_DATE(SI.object_id, SI.index
2013-07-19 10:03:54 535
原创 数据库动态管理视图DMV(4)
--查询tempdb中是否存在一个或多个正在获取页面锁的等待 SELECT session_id,wait_duration_ms,resource_description FROM SYS.dm_os_waiting_tasks WHERE wait_type LIKE 'PAGE%LATCH_%' AND resource_description LIKE '2:%' --查询tempd
2013-07-19 10:01:28 622
原创 数据库动态管理视图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
原创 数据库动态管理视图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
原创 数据库动态管理视图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
原创 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
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人