Thanks for the clarification. I did not paste the actual log command of my script.

-- Sets the backup running by executing the @sql string.

set @sql = 'BACKUP...

Just stumbled into a VERY similar thread on this site:

http://www.sqlservercentral.com/Forums/Topic355924-5-1.aspx#bm482958

Yes, SAN storage. Just found out the tempdb partition and translog partition share the same physical drive. I can move the tempdb file to the larger database drive...

I finally stopped SQL and it ended the "orphaned" rollback process. When SQL started back up, I did not see the rollback continue and finish.

All is well now - So...

Thanks for all the good advice. I had been cleaning the db's and rebuilding indexes gradually all week and weekend while the system had less volume. My databases...

SkyBox (3/10/2011)

---

The exact counter average is 30.00. The max right now showing 69.00. My SAN guy is going to dig into the drives tonight.....hopefully he can some up...

My guy didn't come up with anything - except that the the I/O's are crazy high even when we don't have heavy volume on the system.

Steve Jones - SSC Editor (3/10/2011)

---

For SQL Server, for your mdf/ldf disks, free space on the disk drive has nothing to do with the performance of the disks. Why would...

Steve Jones - SSC Editor (3/10/2011)

---

The amount of space in the MDF file has zero to do with the performance of the disks. If you have high I/O, then you...

This query runs in 10 seconds on my SQL 2008 server, but is returning 0 results on my 2005 box. The 2005 box is at compat. level 80.

Should I...

Thanks for the quick response!

Steve Jones - SSC Editor (3/10/2011)

---

What command did you run? I don't like shrinkdb because you can't control it well. I prefer shrinkfile if I need to get back space...

I shrunk the entire db and it took about 6 hours. However, it did not release any drive space on the database (.mdf) file. I also restarted sql...

I am downloading the 14 day trial of SQL Diagnostic Manager as I type. Redgate will be second on my list once the trial expires.

Thanks!

Yeah - I noticed that the maint. plan cleanup uses the...