You can use an Extended Events session to capture login events, or you can audit logins in the errorlog.  Or you could periodically save the contents of sys.dm_exec_sessions, although there'd...

You could include the join to donor in your dynamic SQL, or you could dump the results of EXEC (@SQLStatement) into a temp table and join to that.

If the value...

I get the current SQL logon data using DMVs and one of them is using sys.dm_exec_sessions for SQL accounts. However, it does give me the information of login create...

Apologies - I thought I'd posted this link:

https://www.red-gate.com/simple-talk/sql/database-administration/building-custom-blocked-process-report/

John

Have you looked into the blocked process report?

John

There are 12 logical cpu's. We update stats on weekly basis. MAXDOP is set = 1. I don't why. But this value is there by years. so its not excessive...

I think Audit is available in Standard Edition (depending on version), just with reduced functionality.  Or you can use an Extended Events session, which I think is what an Audit...

Query your plan cache to see which queries are using the most CPU.  Are you updating statistics regularly?  If not, inappropriate, resource-intensive plans could be being compiled.  Make sure your...

(1) SSMS is just one way you can pull data into a central server.  Try some of the other ways I suggested above and see which works best for you.

(2)...

Do you have the respective RESTORE statements that you used?  If you restore with NORECOVERY, for example, you won't be able to access the database until you've recovered it.  If...

CXPACKET and CXCONSUMER waits mean that your queries are going parallel... but not necessarily that the parallelism is a problem.

How do your ETL jobs work - with stored procedures or...

As has been said above, you can't stop people from doing this if they have the necessary permissions.  Restrict who has SSMS installed on their desktop.  Make sure all databases...

Yes, it's possible.  A SELECT statement won't populate any data, though.  What exactly are you trying to do?

John

Thanks for setting up the tests and crunching the numbers, Mike!

I just wanted to take issue with this (emphasis mine):

Data can be added row by row to a page until...

Just put a PRINT @sqlquery in there and you'll see exactly what's going on.  You don't have any quotes round your date value.

Now, all you need to do is choose...