全文搜索自动分区方案和功能 [英] Full Text Search Auto-Partition Schemes and Functions

问题描述

我们在SQL Server 2012开发（企业）数据库上运行了一些全文搜索。我们注意到分区方案和功能正在（定期）添加到数据库中。我只能假设这些分区是用于FTS的，因为它们具有以下形式：

方案：

  CREATE PARTITION SCHEME [ifts_comp_fragment_data_space_46093FC3] AS PARTITION [ifts_comp_fragment_partition_function_46093FC3] TO（[FTS]，[FTS]，[FTS]）
  

函数：

  CREATE PARTITION FUNCTION [ifts_comp_fragment_partition_function_46093FC3]（varbinary（128））作为范围左值（0x00330061007A00660073003200360036，0x0067006F00730066006F00720064）
  

问题是我们的生产服务器正在运行SQL Server 2012标准不支持分区。因此，它增加了一个额外的管理负担，我们的模式比较（使用SSDT）每次都排除这些分区。当一个人（不可避免地）蠕动时，这是一个痛苦的消除。我们已经做了一些广泛的研究，并且还没有能够提出任何答案，为什么会发生这种情况。任何想法？

解决方案

是的，这些是全文搜索功能的内部。你无法控制它们。然而，我认为它是在模式比较中出现的一个错误。 你永远不会自己创建/修改/删除它们，并且它们完全由sql server维护，所以我将提交一份关于 http的错误报告：//connect.microsoft.com

We have some full text searches running on our SQL Server 2012 Development (Enterprise) database. We noticed that partition schemes and functions are being (periodically) added to the DB. I can only assume that the partitions are for FTS as they have the following form:

Scheme:

CREATE PARTITION SCHEME [ifts_comp_fragment_data_space_46093FC3] AS PARTITION [ifts_comp_fragment_partition_function_46093FC3] TO ([FTS], [FTS], [FTS])

Function:

CREATE PARTITION FUNCTION [ifts_comp_fragment_partition_function_46093FC3](varbinary(128)) AS RANGE LEFT FOR VALUES (0x00330061007A00660073003200360036, 0x0067006F00730066006F00720064)

The problem is that our production servers are running SQL Server 2012 Standard which does not support partitions. Thus it adds an extra admin burden on our schema compares (using SSDT) to exclude these partitions every time. When one does (inevitably) creep in it is a pain to remove. We have done some extensive research and have not been able to come up with any answer as to why this is even happening. Any ideas?

解决方案

Yes, those are internal to the fulltext search functionality. You have no control over them.

However, I would consider it a bug that they show up in your schema compares. You'll never create/alter/drop them yourselves, and they completely maintained by sql server, so I would file a bug report on http://connect.microsoft.com

这篇关于全文搜索自动分区方案和功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！