In our current system - we have 2 Sockets, 16 cores, 32 logical CPU. So, as i understand it is 2 cpu per core? And we are planning to buy...

When i execute this command
ALTER DATABASE Test SET HADR OFF
GO
Output is as below
Msg 35220, Level 16, State 1, Line 1
Could not process the operation. AlwaysOn...

Yes, i tried...it failed that restoring can not be done.

Thanks for the reply. I hope my question was not framed correctly. 
What are we doing ? - We are replicating only once AG node to DR environment. And at...

Yes. We did installed FCI for SfB. However, as they are insisting for dedicated storage and local drives, removed FCI and we had to configure High Safety DB mirroring on...

Here you go.....
I've restarted the SQL services post business hours and intimated users prior the activity. DB is in Recovery Pending status, used drop DB command and it deleted...

Drop alone is not working and gives the same error.

Also, right click is giving this error

TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.

yes, it gives same error for 

sp_detach_db 'sample'
GO
or
Use master;
ALTER database sample set offline with ROLLBACK IMMEDIATE;
DROP database sample;

i tried that, but the alter database modify file is giving same error as mentioned above
ALTER DATABASE sample MODIFY FILE ( NAME = sample_primary_01, FILENAME = "\\XXXX\XXXX\MsSQL\sample\sample_primary_01.mdf")

no it doesn't have DISTINCT

I know, it's a kind of silly thing to ask for help without giving more info. We are unfortunate, that our secure ODC blocks all out going traffic, and access...

Thanks for the swift response. Unfortunately i cant share, as we are operating from a secure ODC.

I can say it's a select query which has condition as

where test_id in (cast(123456227...

Thanks for your suggestions. Unfortunately i can't provide/share any execution plans as we operate from an secure environment.

Answers to the questions posed

->There are no blocking, CPU and OS levels are...