SQL Server System Report

Question

Post reply

SQL Server System Report

Viewing 15 posts - 16 through 30 (of 189 total)

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

ArthurEM SSC Enthusiast Points: 163 More actions · Answer 1

Alright.. 🙁

Thanks anyways, the sql2005 report is great.

rVadim Hall of Fame Points: 3969 More actions · Answer 2

Great script - Thank you very much!

Couple of suggestions:

1. In List Backup Set Details it seems to be reporting databases that were deleted as well as those that are currently off line. It would be nice to have ability to filter those off.

2. In the Unused Indexes it would be nice to have Schema name along with Table name.

Thank you,

--Vadim.

--Vadim R.

Sean Smith SSCertifiable Points: 5977 More actions · Answer 3

Great suggestions. For point 1 I noticed this as well but still wanted to see them for my purposes (plus they fall off the list as we do cleanups of the history tables). For point 2, there is the schema name in the drop index statement. For both points, I have added them in my "to do" list for the next release. Thanks!

James Zeman Grasshopper Points: 21 More actions · Answer 4

I'm having the same issue... did you get a response to this?

kiss.balazs Newbie Points: 9 More actions · Answer 5

kiss.balazs

Newbie

Points: 9

June 22, 2010 at 9:21 am

#1183412

Thank you, your script is much appreciate.

Andris Marte Mr or Mrs. 500 Points: 532 More actions · Answer 6

Sean, I have in my environment a partitioning database tables, and I have several file .ndf and I wonder if you can add the script to leave the file name to find out how much space is occupied each .ndf files

I'm speaking on the part of "Database Recovery Model / Compatibility / Size (Detailed) / Growth Stats"

I send you a sample in a jpg files.

Thanks a Million for this SUPER-SCRIPT!!!

Sean Smith SSCertifiable Points: 5977 More actions · Answer 7

Try adding one of these (think it should do the trick):

MF.name AS logical_database_name

or

REPLACE (RIGHT (MF.physical_name, CHARINDEX ('\', REVERSE (MF.physical_name))),'\','') AS os_file_name

Rememeber: You will need to update the @vXML_String and @vBody portions of the code as well. Let me know if it works.

Andris Marte Mr or Mrs. 500 Points: 532 More actions · Answer 8

I tried but I could not show me the error when remplace

DB_NAME (MF.database_id) AS database_name per DB_NAME (MF.name) AS database_name

can you help me on this it?

Sean Smith SSCertifiable Points: 5977 More actions · Answer 9

Try this:

The line of the code which says:

DB_NAME (MF.database_id) AS database_name

Replace it with:

MF.name AS database_name

If that doesn't work, then try replacing it with:

REPLACE (RIGHT (MF.physical_name, CHARINDEX ('\', REVERSE (MF.physical_name))),'\','') AS database_name

Andris Marte Mr or Mrs. 500 Points: 532 More actions · Answer 10

Sean, I had no error but that is not what I need, I really like to have in the report on behalf of all Filegroups belonging to that database, so I know how much of GB is that they have each of these filesgroup.

Sean Smith SSCertifiable Points: 5977 More actions · Answer 11

Unfortunately I don't work in an environment that uses partitions so I have nothing to test against. Not sure if I can help you any further. 🙁

Andris Marte Mr or Mrs. 500 Points: 532 More actions · Answer 12

Ok no problem, thanks!

I will do anything I do and let you know.

Joe Zonum SSCommitted Points: 1606 More actions · Answer 13

Hello and Thank you.. I was able to place the script on one my servers with no issues. But I get the following error on another:

Msg 234, Level 16, State 2, Procedure usp_SQL_Server_System_Report, Line 122

There is insufficient result space to convert a money value to varchar.

Can you help me correct this issue?

suggestion\request: Would it be possible to flag free space where there is less than 10% free of total disk space?

i.e. Drive E:\ size is 100 GB , total used space is 91 GB. thus the report would flag it and add red text to this line item.

Thank you for your time.

JM

Sean Smith SSCertifiable Points: 5977 More actions · Answer 14

You should see some areas of code that look similar to the following (partial code example below):

CONVERT (VARCHAR (15), CONVERT (MONEY,

You should be able to get around the error by increasing the VARCHAR size (try different values if needed and make sure to change all the sections of code):

CONVERT (VARCHAR (100), CONVERT (MONEY,

I will also add your suggestion to my "to do" list. It's a good one. 🙂

Let me know what happens or if you need more help.

amc-885860 SSC-Addicted Points: 493 More actions · Answer 15

Would it be reasonable to add server security level info and database security to this report?

I could use the visual of this in the report. Would you mind doing this? What do you think?