ldfs(log files) aren't in filegroups. Only data files (mdf, ndf) can be part of filegroups.

Because 1 second = 1000 milliseconds

Hmmmm the 345 seconds is a big red alarm if < 12...

Statistics are updated (with fullscan) for an index when that index is rebuilt. Not when it is reorganised.

Reference: Books Online

http://technet.microsoft.com/en-us/library/ms190397.aspx

Operations such as rebuilding, defragmenting, or reorganizing an index do not...

That looks OK. Does it run?

Move the COMMIT TRANSACTION so that it's just before the END TRY. I just noticed there's already a rollback in the catch,...

Maybe the Sage programming guide will help you. This is the first I've ever heard of the language.

http://www.google.com/search?q=sage+programming+guide

As the error says, you're asking SQL to commit a transaction that's not commitable (because the catch block was invoked). Move the commit tran into the TRY block and add...

A clustered index scan is essentially a table scan, since the clustered index has...

If you're going to query a 45 million row table with no useful index, you should expect it to...

Disk queue's almost impossible to interpret meaningfully when there's a SAN. Too many variables involved.

Check Avg sec/read, Avg sec/write and % disk idle time instead.

The values returned from perform are seconds/read. So to get to milliseconds/read, multiply the value by 1000.

What rights your account has on the local machine/domain is irrelevance. What the SQL Server Service account is may have some effect on this. Check what rights the SQL service...

In the following statement

SET @resultMessage = 'ticketID ' + CAST(@ticketID AS NVARCHAR(200))

+ ERROR_NUMBER() + '. ' +...

Try updating statistics on that table when the problem happens

In fact, it belongs in the client-side validation before the...