2011 年 3月 31 日随笔档案 - Fanr_Zh

公告

2011年3月31日

摘要： Below is what is collectedShows SQL Servers information Shows top 5 high cpu used statemants Shows who so logged in Shows long running cursors Shows idle sessions that have open transactions Shows free space in tempdb database Shows total disk allocated to tempdb database Show active jobs Shows clie 阅读全文

posted @ 2011-03-31 14:14 Fanr_Zh 阅读(518) 评论(0) 推荐(0) 编辑

SQL Server 2005 Logon Triggers 详细介绍

摘要： SQL Server 2005 Logon Triggers by Frederik Vandeputte as SSCLogon triggers by Cristian Lefter as Simple-talk 阅读全文

posted @ 2011-03-31 10:07 Fanr_Zh 阅读(315) 评论(0) 推荐(0) 编辑

慎用 logon trigger

摘要：当用户使用的连接如果是可串行的隔离级别 logon trigger 就会报错原文下载 The Best of SQLServerCentral.com, Vol.7The Best of SQLServerCentral.com, Vol.7 阅读全文

posted @ 2011-03-31 09:32 Fanr_Zh 阅读(243) 评论(0) 推荐(0) 编辑