I was thinking for building a consolidated Script to to identify performance bottlenecks, where I wanted to looks at following information : SQL and OS Version information for current instance Hardware information System Manufacturer and model number and processor description SQL Server configuration File Names and Paths for TempDB and all user databases Recovery model, [...]