Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I'm using a FILESTREAM enabled database that is hosted on SQL Server 2008 Standard Ed on a Windows 2003 server and am seeing some long waits of types PREEMPTIVE_OS_%. Specifically, PREEMPTIVE_OS_GETFILESIZE when executing GET_FILESTREAM_TRANSACTION_CONTEXT(). I'm wondering if anyone can shed some light on what the PREEMPTIVE_OS_% wait types for FILESTREAM operations are.

share|improve this question

1 Answer 1

Interesting. Do you have any anti-virus software that might be attempting real-time scans on the files and delaying SQL Server from opening them quickly? That's the first thing that springs to mind.

share|improve this answer
    
thanks for the response ... anti-virus software isn't installed on this host. have you worked with filestream in a production environment? if so, what has the experience been for you? So far, it's been a mixed bag from my perspective. –  electricsk8 Jan 21 '11 at 14:05
    
I've not had the opportunity to work with filestream storage much in production yet. There's very little documentation for those new wait types, oddly. At this point, you might consider running Process Monitor on the server and watching the filesystem activity within your filestream storage location to look for anything funny happening. –  db2 Jan 24 '11 at 13:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.