SQL Server Performance Forum – Threads Archive

Indexing Service

Happy new year everyone. One of our servers has recently spat out an error of Windows delayed write failure.
A brief websearch suggested it still had indexing service running, which it did. I have now removed all drives from the indexing service via disk properties. Two questions really.. 1) While removing the drives from the indexing service, i got more error messages complaining that certain files could not be removed ‘access denied’. The filenames for these files all looked like CLSID’s. Anyone know what these are, and if the access denied message is to be expected. I suspected they might represent a volume labels, and maybe just system shell objects (recycle bin etc), but I dont know. 2) What is the impact of disabling the indexing service altogether. Id prefer to just disable the service altogether, rather than have the service running (but all drives removed from it), but I dont know if this impacts anything else. Thanks for any advice.

What was the error related when you deleted or before you found that IS is the issue? http://support.microsoft.com/default.aspx?scid=kb;en-us;317586 to optimize indexing service performance. Any warning/errors on event viewer log after you disabled the service? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

The error was just on screen when I remotely connected to the server. Looking in the event log it occurred whilst a particularly large database was being backed up. Didnt appear to be a drive space issue but I cant rule that out.
I searched the web after getting the error message, and thats when I hit upon messages relating to indexing service. Ive not disabled the indexing service yet, but I have removed the drives from being indexed. No further errors since, but the delayed write failure error was a one off, so its too early to say if this has improved anything.

Delayed write error was preceded by two identical events Event Type:Warning
Event Source:MRxSmb
Event Category:None
Event ID:50
Description:
{Lost Delayed-Write Data} The system was attempting to transfer file data from buffers to DeviceLanmanRedirector. The write operation failed, and only some of the data may have been written to the file. Im thinking this might suggest a problem with the NIC or maybe the drive controller
Thanks for any advice

These kind of issues have various causes but typically occur because of incorrect network adapters (also called NICs or network interface cards), incorrect switch settings, faulty hardware, or driver issues. Some connectivity symptoms are intermittent and do not clearly point to any of these causes. Sometimes an operating system upgrade introduces network connectivity problems. To troubleshoot further :
-Check the event logs for network-card-related entries or connectivity-related entries.
-Check whether the network adapter is on the Microsoft Hardware Compatibility List (HCL). To see the HCL, visit the following Microsoft Web sitehttp://www.microsoft.com/hcl/default.asp I presume you’re on latest SP level for Win2K, as the resolution refers to be fixed in latest SP as per this KBAhttp://support.microsoft.com/default.aspx?scid=/servicedesks/bin/kbsearch.asp?Article=293842 listed. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>