Report on the entire SQL Server environment for a newcomer

Question

Post reply

Report on the entire SQL Server environment for a newcomer

VoldemarG

Hall of Fame

Points: 3883
More actions
May 7, 2019 at 2:34 pm

#3637186

Is anyone aware of a script/SP somewhere that would produce in one big result-set or report the overall information on a given SQL Server?
I mean all database sizes, users, security, server configurations, replication, etc. etc. , etc., and EVERYTHING that a newly hired DBA would be interested to see and learn about each particular SQL Server during his first couple of days on the job?
Something that he could look through and say 'OK, now I see what I am going to deal with/be responsible for'.
Likes to play Chess

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Andrey SSC Eights! Points: 840 More actions · Answer 1

try this one:

https://github.com/ASamykin/PerformanceReports/blob/master/Report%20Project1/QuickOverview.rdl

this is SSRS report which connects to a SQL instance under current user (should have sysadmin rights to get all info)

to avoid KERBEROS issue it's better to run the report from SSRS server

also,

- it is possible to amend username and hardcode it in the report properties to avoid double-hop issue (kerberos)

- if it doesn't ask for a SQL server to connect to, check Parameters section and make SQLServer parameter visible w/o default value

Another thing I would mention is sp_Blitz by BrentOzar

https://www.brentozar.com/blitz/

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 2

Search for Brent Ozar's sp_Blitz. I consider it to be a gold standard along with many of his other "Blitz" scripts. The cool part is you can dump the output to a table so you can keep track of stuff you've fixed or still need to fix and it's searchable when you put it in a table.. And, no SSRS required.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)