Tuesday, September 3, 2013

[SQL 2012] Two languages for full text search.

[SQL 2012] Two languages for full text search.

Two languages for full text search.

Posted: 02 Sep 2013 08:30 PM PDT

Hi,we have a column in a table in wich data is stored in a varbinary(max) field.The data is stored in different laguages. Is it possible to use the full text search with two languages? Your help would be appreciated,thanks a lot.

Minimum Active Directory required for SQL Server 2012 Enterprise

Posted: 02 Sep 2013 05:49 PM PDT

I have had a request from our Network Admin as to "what is the minimum level of Active Directory required for SQL 2012?"Note that I am not asking for the minimum Windows Server level that SQL Server 2012 is installed on, but rather the minimum level for the network's Domain Controller. Fal.

Understanding messages about long checkpoint

Posted: 02 Sep 2013 08:48 PM PDT

Hi all Lately I've seen some messages about long checkpoints in our server. The messages look like this:FlushCache: cleaned up 311 bufs with 275 writes in 100497 ms (avoided 7 new dirty bufs) for db 4:0average throughput: 0.02 MB/sec, I/O saturation: 3139, context switches 6607last target outstanding: 2, avgWriteLatency 627I understand parts of this message. I do understand that the checkpoint had to write 311 pages and it did it by issuing 275 reads operation. This took 10004.97 seconds. The throughput was 0.02 mb/sec (kind of shocking, I think that hand writing can be quicker). What I don't understand is the other parts of this message (e.g. I/O saturation: 3139, context switches 6607 last target outstanding: 2, avgWritLatancy 627). Any explanation about this part would be greatly appreciated.Adi
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog