Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What is wait state FFT_NSO_FILEOBJECT Expand / Collapse
Author
Message
Posted Friday, May 2, 2014 9:14 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 8:35 AM
Points: 3,642, Visits: 72,429
Google is just not helping me. I've been trying to access the file table shares exposed on a server (I can select, delete, update, etc via SQL) via untransacted access with no luck (the share just sits there doing something when I try to access it, no error message of any kind).

So I thought I'd look to see if there were any open file handles via

SELECT * FROM sys.dm_filestream_non_transacted_handles;

I found there were 10 non transacted handles open, and they've been open for 3 days for automated processes and the files are about 1-2Kb in size.

so I tried to kill them via
exec sp_kill_filestream_non_transacted_handles

that's normally not something that takes very long (in fact when I cleared two for a different database it took just a second or two).

so leaving the stored proc running, I figured I'd connect and fire up Adam Mechanic's sp_whoisactive.
I see the processes to kill the open file handles, with a wait state of FFT_NSO_FILEOBJECT

Googling that brings back virtually no results, so any idea what this wait state is about?




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1567078
Posted Monday, May 5, 2014 12:42 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:22 PM
Points: 11,148, Visits: 12,889
Mark,

I did some asking around and it looks like you should contact CSS to get an answer as they may need a mini-dump of the SQL Server process.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1567680
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse