Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » ITPro » Perf & Scale   (RSS)

SQL File groups and Search

This article has been a long time coming, but it is finally here.  In the post below I will cover how to configure the Search database to span multiple filegroups.  First I'll cover a little about the benefits of doing so: General references
Posted by enterprisesearch | 4 Comments
Filed under: ,

SQL Index defrag and maintenance tasks for Search

Hi all, this topic is an area that has caused me much pain and work.  My goal for this was to follow the recommended SQL guidelines while minimizing the impact that these maintenance jobs have on Crawling and Queries.  We know from the SQL Monitoring
Posted by enterprisesearch | 2 Comments
Filed under: ,

Attachment(s): DefragSearchIndexes.sql

How to: Mine the ULS logs for query latency

Tracking query latencies can be made easier through the use of the products ULS logs.   Below you will find information on how to enable the specific ULS traces as well as information for how to parse the logs.  The primary usage of this

SQL Monitoring and I/O

Hello again, the interest in the existing posts is starting to climb. As always feel free to post comments or questions to any of the posts and I will either answer your questions directly or add them as topics for the next set of posts. This week I wanted

Creating crawl schedules and starvation - How to detect it and minimize it.

Hello again, Dan Blood here.  For this post I want to discuss starvation as it relates to the Search crawler.  One of the more difficult tasks that the Search admin is going to face is figuring out how to build out the myriad of crawl schedules

SearchBeta Hardware Configuration

Hello again, Dan Blood here.  As I layout some of the lessons I have learned hosting SearchBeta  I thought it would be beneficial to let you all know what kind of hardware I am using to support this environment.  Be aware that I am not

Scale and performance lessons learned from a live deployment

My name is Dan Blood, I am a senior tester working in the product group that is responsible for Search within MOSS and MSS.  One of my responsibilities is maintaining a mirror, SearchBeta,  of the enterprise search solution that all of Microsoft
 
Page view tracker