I am using this to get active connections. However that looks like to be current connections, I need connection details which were 1 hour ago..is that possible?

SELECT DB_NAME(dbid) AS DBName,

COUNT(dbid) AS NumberOfConnections,

loginame

FROM    sys.sysprocesses

GROUP BY dbid, loginame

ORDER BY DB_NAME(dbid)

@Grant Fritchey : Thank you, sir, for your response and time and truly appreciate your advice. It always helps!

I learned about APPROX_COUNT_DISTINCT 🙂

Yeah! thank you!

Thanks, I was able to use the DISK Usage by Table report which I was thinking about, and it shows #record for that table.

PFA, thanks! please unzip the folder and you might have to open the anonymized plan in sql sentry explorer. Apologize for any inconvenience caused do not know any better way yet.

• This reply was modified 4 years, 7 months ago by  sizal0234.

Sorry for the inconvenience, I uploaded the zipped format of sql sentry cost explorer plan. So, I think you might need to view it.

I was able to attached the plan, please look at the actual plan and let me know your thoughts. Thanks!

• This reply was modified 4 years, 7 months ago by  sizal0234.

Thanks! I do have the sql sentry ...so let me try to anonymize the plan ....this is a great tip!. Yes, I will be downloading the book and thanks for...

Great, Thanks!! yes, I was able to do SP call in the test environment and generate the actual plan. Attached. Please let me know your thoughts, I do not want...

Yes, I selected the code generated using sp_helptext ...and then for that code, I generated the estimated plan.

So, I am actually doing the high level package review, where I want to rule out if the code snippets can be optimized in any way. So, I got the...

Also, please suggest any idea for sending an alert when sql service stops on any instance..? thanks!

Couple of good points there so great help, thank you!

Thanks guys, yeah, space issue has been discussed, however all of sudden I see someone running some query which is not using dbo prefix, having select * statements, playing with...

OK, thanks for some good tips.

From what I see we have 5 logical files of type rows and 1 log file. Autogrowth is none for primary and log has 64MB...