摘要：We have already talked about Windows AWE mechanism on 32 bit and how SQL Server utilizes it. Today I would like to go over AWE & related mechanism on 64 bit platforms.我们已经谈过windows AWE 在32bit 中sql server 如何利用。下面是AWE在64位环境的相关性To some people it comes as a surprise that AWE mechanism is still prese 阅读全文

摘要：死锁监控一直都很麻烦，我没有找到很好的方法如果大家有好的方法，我也很想学习一下我的方法比较简单：　1.sp_altermessage 1205 修改1205 错误让他能够写入日志 这样 代理中的警告才能使用　2.当然是启动 代理中的警告。开数据库邮件，会把死锁错误发送到操作员邮箱里面。缺点就是没有详细的死锁信息。 3.使用sql server 2008 r2 自带的 扩展事件中system_health默认是开启的，里面会抓取比较多的值 你可以使用 sys.dm_xe_session_events 联合sys.dm_xe_sessions 查看 抓取了那些值 当然其中一个是死锁信息。 当... 阅读全文

摘要：Fanr Fanr 2 384 2012-08-12T11:20:00Z 2012-08-12T11:20:00Z 6 943 5377 44 12 6308 12.00 from ：http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-IAM-pages-IAM-chains-and-allocation-units.aspx false 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE ... 阅读全文

摘要：1. The CPU’s MMU locates the page directory for the process usingthe special register mentioned above.2. The page directory index (from the first 10 bits of the virtual address)is used to locate the PDE that identifies the page tableneeded to map the virtual address to a physical one.3. The page tab 阅读全文

摘要：Trace flags can be used to alter the behavior of SQL Server and they can help when diagnosing performance issues as well. During the course of days I've come across cases from where I learnt about them & their purpose; certainly do let me know for any corrections that I may have missed out.F 阅读全文