Yes. Those jobs are running sp ( Not one particular job)

We are not allowed to run the profiler

I am not sure what happened exactly. I think dbs stand 2-3 hr on that node after the issue start. Then we failover to Node B. It started working fine.

I...

Those are hypothetical indexes. Is it better to keep or drop those hypothetical index?

I am not sure those are created by DTA or some other tool but the description is

nonclustered, hypothetical located on PRIMARY

index name is IX_SQLdoctor_8_5_95f565ef22664301a95c1840be217031

After the failover I can SQL Server automatically did the DBCC.

We have 3 disks. 1 for quoram and 1 logs and 1 for data

I see an error The run-time environment...

I am running from the local machine and we didn't upgrade the instance. Also I refreshed the db & Tables

But we restored the database from SQL 2005 to this instance...

I am able to test in lower environment.

Looks even though if you have dbowner permissions in the user database to create and drop the tables if you don't have permissions...

How to know the information about the user created one?

Hallengren script rebuild/reorg the indexes based on the Index fragmentation %. It has to run everyday

For standard edition doesn't have the option to rebuild the indexes online. So we are...

If you are not using enterprise edition, I think it would be ok with rebuild indexes weekly using maintenance plans

Now it started the new hostprocess.

From Resource Monitor I can able to see that PID and the image is showing SQLBackup.exe.

For the same PID, I can see one Image...

Thank you.

I check those tables.

select distinct software_name from backupmediaset = Microsoft SQL Server.

When I check the SQL Server error logs

I found sequence of error msg logged different times

BACKUP...

2008r2 with SP2

Thank you.

I am creating extended events like this. I want to capture like only drop, delete, truncate statements. How to add that predicate in addition to the db_id=5?

Create event session...

So you have to put the limit of the file size and depends upon the date appended you manually delete them?