在SQLSERVER 2008的数据库上建了几个tempdb的数据文件，为什么只有第一个文件变大了，其他没有使用？

Question

会因为第一个文件没用满初始文件大小，而不使用其他数据文件吗？

谢谢！

Answer 1

Did you allow those files auto grow?

Answer 2

Did you allow those files auto grow?

允许这些文件自动增长了

Answer 3

Hi Tim-2009,

不会的，写入文件会按照比例对各个mdf，ndf进行分配，按照产品设计，每个文件会同时用满。你是如何发现其他的数据文件都没有写入的。 另外，在配置完tempdb之后到你检查数据文件之间，你有重启过数据库吗？

Best Regards,

Teige

---

MSDN Community Support<br/> Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:[e-mail]">[e-mail]</a>.

Answer 4

Hi Tim-2009,

不会的，写入文件会按照比例对各个mdf，ndf进行分配，按照产品设计，每个文件会同时用满。你是如何发现其他的数据文件都没有写入的。 另外，在配置完tempdb之后到你检查数据文件之间，你有重启过数据库吗？

Best Regards,

Teige

---

MSDN Community Support<br/> Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:[e-mail]">[e-mail]</a>.

不知道有没有重启过，不重启就不生效？

Answer 5

Hi Tim-2009,

不是不重启就不生效，而是重启之后原来的tempdb会被drop然后重新创建。

Best Regards，

Teige

---

MSDN Community Support<br/> Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:[e-mail]">[e-mail]</a>.

Answer 6

Did you allow those files auto grow?

允许这些文件自动增长了

Can you run 'select * from sys.sysfiles' under tempdb and post results?

Answer 7

Did you allow those files auto grow?

允许这些文件自动增长了

Can you run 'select * from sys.sysfiles' under tempdb and post results?

Answer 8

Did you allow those files auto grow?

允许这些文件自动增长了

Can you run 'select * from sys.sysfiles' under tempdb and post results?

不好意思，好像误操作，把你后面的回复删除了

Answer 9

How much space used in each data file?

Answer 10

增长的时候不是四个一起变大的

---

想不想时已是想，不如不想都不想。

Answer 11

To make all tempdb data files grow in same pace, those data files should have same initial size.

Answer 12

How much space used in each data file?

第一个文件用了70多G了吧，其他都没用。

原来的设置是第一个文件的初始文件为20G，第二个文件是500M，后面我都改成了1G，每次增长500M，不过改后还没有重启过。

Answer 13

All files should have same initial size.

Answer 14

新版本还没测试过，之前 2008r2 的版本在表现上确实是新加的文件用得少，但不是没用到

大量并发并且临时表用得多的时候，多文件明显比单文件更少出现资源等待

但文件的利用上，确实是其他文件很少涨

Answer 15

All files should have same initial size.

文件的初始大小改为一样的了，不过还没重新启动过

Answer 16

Restart sql when get chance then check file usages.

Answer 17

Restart sql when get chance then check file usages.

好的，后面重启了，再来报告一下情况，谢谢！

Answer 18

Restart sql when get chance then check file usages.

重启了，请看看现在的情况是不是正常了？谢谢！

Answer 19

That look fine, you should check again after several days.

Answer 20

That look fine, you should check again after several days.

好的，谢谢！

Answer 21

为啥你还要留两个文件在C盘

---

想不想时已是想，不如不想都不想。

Answer 22

为啥你还要留两个文件在C盘

---

想不想时已是想，不如不想都不想。

那两个C盘的文件一个是数据文件，一个是日志文件，原来的设置的，没动