ScottPletcher (2/28/2013)

---

I have additional space to grow, you prevent it.

So if a task unexpectedly needs, say, 50MB more of tempdb space to complete, you abend it -- perhaps after it...

ScottPletcher (2/28/2013)

---

So if tempdb now does need to grow for whatever reason, and it causes a SQL issue because it can't, you've guaranteed that there's no easy way to recover,...

If you were successfully sizing tempdb to be the size that SQL needs, you wouldn't be using startup procs to check file sizes and be concerned about checking the files...

If you've pre-sized the...

ScottPletcher (2/28/2013)

---

Nobody is saying that proportional fill will ensure that...

ScottPletcher (2/28/2013)

---

If the temp files are growing, I don't want to allocate them smaller and force them to grow every time SQL starts: that's a waste of resources vs just...

ScottPletcher (2/28/2013)

---

So you don't use a startup proc to verify tempdb data files are all the same size and sync them if they are not?

How, then, do you become aware...

GilaMonster (2/28/2013)

---

I meant exactly what I said. No reboot necessary. A restart of the SQL Server service is very strongly recommended. A reboot of the entire server is not required...

GilaMonster (2/28/2013)

---

Did...

Yes, that was the reason for his suggestion of two files at 800MB so that together they would be about 1.5 GB. Personally, I always advocate pre-sizing your tempdb files...

ScottPletcher (2/27/2013)

---

If a tempdb data file is 1.5G when SQL goes down, won't it be 1.5G when SQL comes back up? Isn't it automatically reset to its previous size?...

NEVER manually shrink tempdb files. It can corrupt the tempdb files. Avoid shrinking files of any database if...

That's not for SQL Server. It's for the other programs (Like Exchange) that still have the on-site training as a requirement. They are re-introducing on-site training for SQL Server, but...

You're welcome. Glad I was able to help.

So the difference you're seeing is definitely the difference in collection intervals. You can adjust the collection interval if you need to for troubleshooting a particular issue, but I would...