Go to task Manager --> processes tab -->check show process from all users --> sort on cpu,memory columns

Is it fine to just set the MAXDOP as the number of processors?

is it mandatory to use the MAXDOP query hint?

does the 2 options combinations have any impact?

as i say...

Thank you for your efforts

some how i figured it

Here is the query

Declare @login table ( Database_name Varchar(1000),Login_Name varchar(2000),Username varchar(200))

Insert into @login

exec sp_msforeachdb @command1=...

that ia a great answer thank you 🙂

there were no blocking

ours is 4 GB ram and the size of the records it returns is 2,50,000 and which is only 660MB