为什么Sql服务器将100个文件写入系统卷信息(全部使用相同的名称)

我注意到SQL Server对\System Volume Information\{guid1}{guid2}的写入数量惊人地多,

当这样的事情发生时,Sql Server是做什么的?

在这里输入图像说明

在上面的图像中,我写的sqlsevr.exe的一半IO用于系统卷信息写入。

这是在Windows 7 Profressional中运行。


这里是vssadmin list shadows的输出

 vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool (C) Copyright 2001-2005 Microsoft Corp. Writer name: 'Task Scheduler Writer' Writer Id: {d61d61c8-d73a-4eee-8cdd-f6f9786b7124} Writer Instance Id: {1bddd48e-5052-49db-9b07-b96f96727e6b} State: [1] Stable Last error: No error Writer name: 'VSS Metadata Store Writer' Writer Id: {75dfb225-e2e4-4d39-9ac9-ffaff65ddf06} Writer Instance Id: {088e7a7d-09a8-4cc6-a609-ad90e75ddc93} State: [1] Stable Last error: No error Writer name: 'Performance Counters Writer' Writer Id: {0bada1de-01a9-4625-8278-69e735f39dd2} Writer Instance Id: {f0086dda-9efc-47c5-8eb6-a944c3d09381} State: [1] Stable Last error: No error Writer name: 'ASR Writer' Writer Id: {be000cbe-11fe-4426-9c58-531aa6355fc4} Writer Instance Id: {6584bb82-094c-4896-9be2-880ff9fb4d80} State: [1] Stable Last error: No error Writer name: 'System Writer' Writer Id: {e8132975-6f93-4464-a53e-1050253ae220} Writer Instance Id: {669bba38-6066-4bf6-99af-8d312f66648d} State: [5] Waiting for completion Last error: No error Writer name: 'SqlServerWriter' Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a} Writer Instance Id: {48de0d7f-b7a0-457e-8bab-fefe2089286e} State: [1] Stable Last error: No error Writer name: 'MSSearch Service Writer' Writer Id: {cd3f2362-8bef-46c7-9181-d62844cdc0b2} Writer Instance Id: {d5c4ab16-b67e-4476-976b-4dba610084d8} State: [5] Waiting for completion Last error: No error Writer name: 'WMI Writer' Writer Id: {a6ad56c2-b509-4e6c-bb19-49d8f43532f0} Writer Instance Id: {5e334911-6049-4d29-8d33-d9b230b46ec2} State: [5] Waiting for completion Last error: No error Writer name: 'COM+ REGDB Writer' Writer Id: {542da469-d3e1-473c-9f4f-7847f01fc64f} Writer Instance Id: {e9dde2da-5cee-4d65-ac50-45387be4b600} State: [1] Stable Last error: No error Writer name: 'Registry Writer' Writer Id: {afbab4a2-367d-4d15-a586-71dbb18f8485} Writer Instance Id: {9825b95f-94a0-438b-a359-4111aa308a60} State: [1] Stable Last error: No error Writer name: 'BITS Writer' Writer Id: {4969d978-be47-48b0-b100-f328f07ac1e0} Writer Instance Id: {d23d67d3-c421-4e9a-9965-123ec802bfcc} State: [1] Stable Last error: No error 

这里是 vssout list shadows 的输出 (在这里过长)

这是Windows做你的电子驱动器的影子副本。

(这在SQL服务器的数据/日志驱动器上使用是不正常的,它会极大地增加I / O)。

编辑:或者,至less安排好时间,比如每个人上class前一个小时。

闻起来像VSS快照。

你有软件(可能是备份)告诉SQL Server创buildVSS捕捉?

我的猜测是,您正在对服务器本身进行备份,或者使用支持VSS的备份程序(Windows备份,SQL维护计划或SQL数据库备份作业或第三方支持VSS的备份软件)备份SQL Server数据库。 。

您还可以禁用数据库文件的文件夹上的卷影副本: http : //msdn.microsoft.com/en-us/library/aa819132(v=vs.85).aspx