You don't need to correct the situation where one of more of the files has expanded because on restart of SQL the files will be back to their defined size....

What was the initial, defined size of the first file before you ran that?

Robert Davis (2/28/2013)

---

GilaMonster (2/28/2013)

---

No reboot necessary. Not SQL agent though, restart SQL...

Should work.

TRy a shrinkfile with emptyfile, then remove the second file.

The certs don't expire (well, not the MCTS/MCITP ones). The exam is retiring...

However bear in mind that anyone who is an administrator on the machine that runs SQL can remove the TDE and decrypt any column encrypted by key or cert and...

No server options that could cause this. Probably CheckDB or index rebuilds that move a huge amount of data through the cache.

You'll only be able to remove it if all the VLFs in that log file are inactive (not needed for anything). If they're not, you'll have to wait and run...

stehoban (2/27/2013)

---

Regarding point number 3 above. How to i reduce the size from 1.5gb to 800mb or 1gb ? Would this be by using the ALTER database command with the...

SQL Pizza (2/28/2013)

---

I just asked myself, if there is a point, where you can't optimize queries and indexing anymore, cause it's just to much workload for the cpu to handle...

ScottPletcher (2/27/2013)

---

GilaMonster (2/27/2013)

---

ScottPletcher (2/27/2013)

---

Then, set up a start up proc to shrink both tempdb files ... I'd say to 1G each, so you have some cushion. You really don't...

ScottPletcher (2/27/2013)

---

Then, set up a start up proc to shrink both tempdb files ... I'd say to 1G each, so you have some cushion. You really don't ever want...

You either have auto_shrink on or you have a scheduled shrink job. Get rid of the shrink and the file will stay at the specified size (or will grow if...

Basically this on a weekly, bi-weekly or monthly basis.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/