VS2012，未打开任何项目，每秒持续读取SQLite.dll的本地用户配置文件副本 [英] VS2012, no projects open, continually reads local user profile copy of SQLite.dll every second

问题描述

在调查TFS项目的缓慢开放时，我发现(与procmon一起)，安静"的解决方案是安静的". VS2012实例(未打开任何项目)正在不断创建线程，打开并读取AppData \ Local \ Temp \ {guid} \ System.Data.SQLite.dll文件.更多的 而不是每秒一次.不间断.

While investigating slow opening of TFS projects, I discovered (with procmon), that a "quiet" VS2012 instance, no project open, is continually creating a thread, opening and reading an AppData\Local\Temp\{guid}\System.Data.SQLite.dll file. More than once a second.  Nonstop.

我有一位同事检查了他的VS2013及其所做的事情(至少在打开一个项目的情况下).

I had a colleague check his VS2013 and its doing the same thing (at least, with a project open).

有什么想法吗?

这是procmon输出的一部分:

Here is part of the procmon output:

1:49:22.3308169 PM  devenv.exe  10348 线程创建 成功 线程ID:20680
1:49:22.3320818 PM \ devenv.exe  10348  CreateFile  C:\ Users \ mjandrew \ AppData \ Local \ Temp \ {09cb146c-5648-4005-8975-2a539d50b846} \ System.Data.SQLite.dll  SUCCESS 所需访问:通用读取，Dis，选项:顺序访问，同步 IO非警报，非目录文件，属性:不适用，ShareMode:读取，分配大小:不适用，OpenResult:已打开
1:49:22.3325389 PMdevenv.exe 10348QueryStandardInformationFile C:\ Users \ mjandrew \ AppData \ Local \ Temp \ {09cb146c-5648-4005-8975-8975-2a539d50b846} \ System.Data.SQLite.dll分配大小:905,216，EndOfFile:904,704，NumberOfLinks: 1，DeletePending:False，目录:False
1:49:22.3326448 PM \ devenv.exe  10348  CreateFileMapping  C:\ Users \ mjandrew \ AppData \ Local \ Temp \ {09cb146c-5648-4005-8975-2a539d50b846} \ System.Data.SQLite.dll 文件已锁定仅限读者SyncType:SyncTypeCreateSection，PageProtection:
1:49:22.3327141 PM \ devenv.exe  10348  QueryStandardInformationFile  C:\ Users \ mjandrew \ AppData \ Local \ Temp \ {09cb146c-5648-4005-8975-2a539d50b846} \ System.Data.SQLite.dll分配大小:905,216，EndOfFile:904,704，NumberOfLinks: 1，DeletePending:False，目录:False
1:49:22.3329663 PM  devenv.exe  10348  C:\ Users \ mjandrew \ AppData \ Local \ Temp \ {09cb146c-5648-4005-8975-2a539d50b846} \ System.Data.SQLite.dll  SUCCESS SyncType:SyncTypeOther
1:49:22.3333764 PM  devenv.exe  10File  C:\ Users \ mjandrew \ AppData \ Local \ Temp \ {09cb146c-5648-4005-8975-2a539d50b846} \ System.Data.SQLite.dll  SUCCESS 
1:49:22.3339787 PM \ devenv.exe  10348  CreateFile  C:\ Users \ mjandrew \ AppData \ Local \ Temp \ {09cb146c-5648-4005-8975-2a539d50b846} \ System.Data.SQLite.dll  SUCCESS 所需访问:通用读取，Dis，选项:顺序访问，同步 IO非警报，非目录文件，属性:不适用，ShareMode:读取，分配大小:不适用，OpenResult:已打开
1:49:22.3343621 PMdevenv.exe 10348QueryStandardInformationFile C:\ Users \ mjandrew \ AppData \ Local \ Temp \ {09cb146c-5648-4005-8975-8975-2a539d50b846} \ System.Data.SQLite.dll分配大小:905,216，EndOfFile:904,704，NumberOfLinks: 1，DeletePending:False，目录:False
1:49:22.3344621 PM \ devenv.exe  10348  CreateFileMapping  C:\ Users \ mjandrew \ AppData \ Local \ Temp \ {09cb146c-5648-4005-8975-2a539d50b846} \ System.Data.SQLite.dll 文件已锁定仅限读者SyncType:SyncTypeCreateSection，PageProtection:
1:49:22.3345329 PMdevenv.exe 10348QueryStandardInformationFile C:\ Users \ mjandrew \ AppData \ Local \ Temp \ {09cb146c-5648-4005-8975-8975-2a539d50b846} \ System.Data.SQLite.dll分配大小:905,216，EndOfFile:904,704，NumberOfLinks: 1，DeletePending:False，目录:False
1:49:22.3346740 PM \ devenv.exe  10348  CreateFileMapping  C:\ Users \ mjandrew \ AppData \ Local \ Temp \ {09cb146c-5648-4005-8975-2a539d50b846} \ System.Data.SQLite.dll  SUCCESS SyncType:SyncTypeOther
1:49:22.3348697 PM \ devenv.exe  10File  CloseFile  C:\ Users \ mjandrew \ AppData \ Local \ Temp \ {09cb146c-5648-4005-8975-2a539d50b846} \ System.Data.SQLite.dll  SUCCESS 

1:49:22.3308169 PM devenv.exe 10348 Thread Create  SUCCESS Thread ID: 20680
1:49:22.3320818 PM devenv.exe 10348 CreateFile C:\Users\mjandrew\AppData\Local\Temp\{09cb146c-5648-4005-8975-2a539d50b846}\System.Data.SQLite.dll SUCCESS Desired Access: Generic Read, Dis, Options: Sequential Access, Synchronous IO Non-Alert, Non-Directory File, Attributes: n/a, ShareMode: Read, AllocationSize: n/a, OpenResult: Opened
1:49:22.3325389 PM devenv.exe 10348 QueryStandardInformationFile C:\Users\mjandrew\AppData\Local\Temp\{09cb146c-5648-4005-8975-2a539d50b846}\System.Data.SQLite.dll SUCCESS AllocationSize: 905,216, EndOfFile: 904,704, NumberOfLinks: 1, DeletePending: False, Directory: False
1:49:22.3326448 PM devenv.exe 10348 CreateFileMapping C:\Users\mjandrew\AppData\Local\Temp\{09cb146c-5648-4005-8975-2a539d50b846}\System.Data.SQLite.dll FILE LOCKED WITH ONLY READERS SyncType: SyncTypeCreateSection, PageProtection:
1:49:22.3327141 PM devenv.exe 10348 QueryStandardInformationFile C:\Users\mjandrew\AppData\Local\Temp\{09cb146c-5648-4005-8975-2a539d50b846}\System.Data.SQLite.dll SUCCESS AllocationSize: 905,216, EndOfFile: 904,704, NumberOfLinks: 1, DeletePending: False, Directory: False
1:49:22.3329663 PM devenv.exe 10348 CreateFileMapping C:\Users\mjandrew\AppData\Local\Temp\{09cb146c-5648-4005-8975-2a539d50b846}\System.Data.SQLite.dll SUCCESS SyncType: SyncTypeOther
1:49:22.3333764 PM devenv.exe 10348 CloseFile C:\Users\mjandrew\AppData\Local\Temp\{09cb146c-5648-4005-8975-2a539d50b846}\System.Data.SQLite.dll SUCCESS 
1:49:22.3339787 PM devenv.exe 10348 CreateFile C:\Users\mjandrew\AppData\Local\Temp\{09cb146c-5648-4005-8975-2a539d50b846}\System.Data.SQLite.dll SUCCESS Desired Access: Generic Read, Dis, Options: Sequential Access, Synchronous IO Non-Alert, Non-Directory File, Attributes: n/a, ShareMode: Read, AllocationSize: n/a, OpenResult: Opened
1:49:22.3343621 PM devenv.exe 10348 QueryStandardInformationFile C:\Users\mjandrew\AppData\Local\Temp\{09cb146c-5648-4005-8975-2a539d50b846}\System.Data.SQLite.dll SUCCESS AllocationSize: 905,216, EndOfFile: 904,704, NumberOfLinks: 1, DeletePending: False, Directory: False
1:49:22.3344621 PM devenv.exe 10348 CreateFileMapping C:\Users\mjandrew\AppData\Local\Temp\{09cb146c-5648-4005-8975-2a539d50b846}\System.Data.SQLite.dll FILE LOCKED WITH ONLY READERS SyncType: SyncTypeCreateSection, PageProtection:
1:49:22.3345329 PM devenv.exe 10348 QueryStandardInformationFile C:\Users\mjandrew\AppData\Local\Temp\{09cb146c-5648-4005-8975-2a539d50b846}\System.Data.SQLite.dll SUCCESS AllocationSize: 905,216, EndOfFile: 904,704, NumberOfLinks: 1, DeletePending: False, Directory: False
1:49:22.3346740 PM devenv.exe 10348 CreateFileMapping C:\Users\mjandrew\AppData\Local\Temp\{09cb146c-5648-4005-8975-2a539d50b846}\System.Data.SQLite.dll SUCCESS SyncType: SyncTypeOther
1:49:22.3348697 PM devenv.exe 10348 CloseFile C:\Users\mjandrew\AppData\Local\Temp\{09cb146c-5648-4005-8975-2a539d50b846}\System.Data.SQLite.dll SUCCESS 

推荐答案

嗨Mickan，

为了进一步研究此问题，请向我们提供更多信息:

1. 此问题仅在您打开从Source Control添加到TFS版本控件的Visual Studio项目时发生资源管理器?我不太了解"TFS项目".您可以打开一个
2. 哪个您是否打开过"TFS项目"(我假设您是从VS打开TFS项目的，如果没有，请说明)?
3. 您正在使用哪个版本的TFS?
4. "TFS项目"是否可以成功打开慢吗?
5. 您计算机中打开的项目或其他项目是否使用了SQLite数据库?

1. did this issue only occur when you open Visual Studio projects which are added to TFS version control from Source Control Explorer? I don’t quite understand ‘TFS projects’. You can open a local Visual Studio Project from VS to check the speed and whether the same issue will occur.
2. How many Visual Studios are installed on your machine? From your post, maybe there are both VS2012 and VS2013.
3. Which version and edition of VS did you open ‘TFS projects’(I assume that you open TFS project from VS, if no, please clarify)?
4. Which version of TFS are you working with?
5. Whether the ‘TFS project’ can be opened successfully even though it was slow?
6. Whether the opened project or other projects in your machine used SQLite database?

为了解决当前问题，我的建议如下:

1. 重新启动PC以释放一些资源
2. 从以下位置清除客户端TFS缓存: C:\ Users \ {您的帐户} \ AppData \ Local \ Microsoft \ Team Foundation \ {version}(删除缓存文件夹)
3. 基于此博客清除VS和TFS用户缓存:

1. Reboot your PC to release some resources
2. Clear client TFS cache from : C:\Users\{your account}\AppData\Local\Microsoft\Team Foundation\{version} (Delete cache folder)
3. Clear VS and TFS user cache based on this blog: If you have problems with TFS or Visual Studio flush the user cache … or not?

Best regards,

这篇关于VS2012，未打开任何项目，每秒持续读取SQLite.dll的本地用户配置文件副本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！