2019 年 2月 22 日随笔档案 - stswordman

2019年2月22日

FILESTREAM feature can't be enabled if you use cluster shared volumes

摘要： Create a SQL Cluster instance. Create Cluster Shared Volume Please note. No Share storage is added into SQL Server. Open SQL Server configuration mana 阅读全文

posted @ 2019-02-22 03:29 stswordman 阅读(420) 评论(0) 推荐(0) 编辑

SQL Server does not purge row versioning records even the transaction are committed if there are other open transaction running in the databases with read-committed snapshot enabled .

摘要： This is a by-design behavior. There is only one allocation unit in tempdb that istracking the versioned records across the server. Cleanup of this all 阅读全文

posted @ 2019-02-22 02:19 stswordman 阅读(171) 评论(0) 推荐(0) 编辑