It's a useful command indeed.

However, it is not really needed here.

All you have to do is...

As I expected, I had trouble dropping one of the "extra" log files because it was in use:

alter database [DB1] REMOVE FILE LOG_3;

However, after taking a log backup I was...

L' Eomot Inversé (10/16/2012)

---

There are various ways...

Perry Whittle (10/16/2012)

---

Whats voodoo about creating a table, inserting some records...

I will probably not do that, as it seems a bit too much voodoo to me......

To find out which log files are currently in use:

DBCC LOGINFO ('DBNAME');

Output records with status=2 signify which log file is currently in use.

Multiple log files and why they're bad:

http://sqlskills.com/blogs/paul/default.aspx#p1

Artoo22 (10/15/2012)

---

Here is an excellent blog explaining the issue:

http://www.sqlskills.com/blogs/paul/post/Why-LOB-data-make-shrink-run-slooooowly-(T-SQL-Tuesday-006).aspx

And Paul Randal's Shrink Alternative:

So what if you *do* need to run a shrink? For instance, if you've deleted a large proportion...

Thanks for the advice. 🙂

I found out that this data file contains data from a text column.

Could this be the reason I am having trouble shrinking the file?

GilaMonster (10/13/2012)

---

You should be able to. As long as you just shrink the files with the TEXT it shouldn't even cause the usual fragmentation. Log pages are arranged differently than...

I use the "Disk Usage" report in SSMS to get total size and used space.

I found the reason.

This filegroup is used for a TEXT column in a table that itself...

I got it to work, but I am puzzled why... 🙂

I ran the following to disable AlwaysOn:

Disable-SqlAlwaysOn -ServerInstance "SERVER1\INSTANCE1" -force

This caused a service restart this time.

Then reran this to...

In addition to what has already been posted: include the partition_number column, output from the sys.dm_db_index_physical_stats DMV, in the list of columns you consider in your analysis.

If your database is...

Eric Mamet (9/17/2012)

---

Hi there!

I was just wondering about SQL Server Performance monitoring tools but we are a very small shop, hence free would be much better!

Since two years passed...

GilaMonster (9/27/2012)

---

No it won't, because procs marked with recompile are never cached and hence never appear in the sys.dm_exec_query_stats DMV.

p.s. You don't need a LIKE match for the procedure name....