Skip to content
/ SQLQA Public

SQL QA is a SSRS Report to look at various settings and configurations of your SQL Server Instance

License

Notifications You must be signed in to change notification settings

dokier/SQLQA

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

SQLQA

SQL QA is a SSRS Report to look at various settings and configurations of your SQL Server Instance on the fly including the following sections. It will also highlight in yellow or grey things to watch out. You will need Report Builder 2016 or SSRS 2016 to be able to use this report.

Instance Details

Instance Name, Edition, SQLVersion, ServicePack, Machine Type, Auth Mode, TCP Port, Install Date, Last Start Date

Configuration Settings

Backup Compression, PowerPlan, Xp_CmdShell, MaxDop

System Information

Server Memory, Max Server Memory, Min Server Memory and number of CPus

Drive Space

Drive Name, CapacityGB, UsedGB, FreeGB, Percentage Free

Database Options

Name, Compatibility, State, User Access Description, Recovery Model, Collation, PageVerify, ReadOnly, AutoClose, AutoShrink, AutoCreate Stats, AutoUpdate Stats, FullText, DB Chaining, Trustworthy, Owner

Database Size

Name, Size, Used Space MB, Free Space MB, Percent Free, Updateability, State

Log Size

DB Name, LogSize MB, Percentage USed

Database Files Details

DB Name, Logical Name, Type, Total Space MB, Used Space MB, Free Space MB, Percent Used, Physical Name, File Group, File Growth, Auto Growth

User Database Role Membership

DB Name, UserName, DatabaseRole, Login Name, Def DBName

Login Server Role Membership

Login Name, Type, Server Role, Disabled, Def DBName

Backups

DB Name, Virtual Full, Virtual Diff, Disk Full, DiskDiff, DiskTlog, Recovery Model State Desc, Updateability

About

SQL QA is a SSRS Report to look at various settings and configurations of your SQL Server Instance

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published