This is what I also thought, but hoped that there is some solution. I've been waiting for many hours already. Actually it is cancelling longer than was original execution. Will...

In such a case, why do they show this option at all ?

Thanks all. This works good.

And about packages which are executed via stored proc, I hope we do not ahave such, but just in case sys.sql_modules.

Thanks

Thanks for quick responses.

1. DBCC opentran shows only the oldest transaction, and it does not show it's size.

2. DBCC dblog indeed is not documented anywhere. I had just few results...

Answering for your 2nd question: Create a daily job which saves daily snapshot of sys.dm_db_index_usage_stats to another table, plus date/time of running this job.

This DMV keeps counting values since the...

She meant sp_configure configurations.

About file allocations, etc, I answered in another questions.

In the beginning, before asking any questions, she said that this is high-volume OLTP environmrnt. So I guess she expected something related to this condition.

We don't have any databases set to autoclose.

There are no restores running now.

Anfortunately, I don't have privileges to check error log (I don't have "sa" rights).

But I guess I will...

I tried it, but it does not work. It's actually a sys view, not a sys table. When I try to drag it, it changes mousepointer to prohibiting circle with...

Ninja, we are here not to argue or curse each other, but to give constructive answers. We are all here to share our experience. If you don't know the answer...

Thanks, Jessie. Finally I got some meaningful numbers to start with.

I totally disagree with you, GilaMonster.

You don't take in the account such important things as maintainability and support. Not Ola, by I will receive a call at 2:00 am if...

I am not re-inventing the wheel. I just create a script around sys.dm_db_index_physical_stats DMV with two outcomes: rebuild / reorg.

The script to optimize indexes by Ola Hallengren that you are...

Tried to download Red Gate SQL compare, but our firewall blocked it because they have some .exe file. Will try to download it at home.

Hi Sean, first it was a problem and than it appears strange. I was tasked to write two scripts: to compare stored procedures, views, triggers between databases. In one my...