question

Server: * Host - you mean the server name? `SELECT @@SERVERNAME` might be a place to start, but that might not be the same as that returned by the appropriate [SELECT SERVERPROPERTY][1] command. * Environment - that's one for you to decide. You could have a table that matches server names to environments, or you could pull it from your naming convention (you *do* have a naming convention, right?) * Instance - see Host * Version - `SELECT @@VERSION`? * Memory - physical memory, or the memory in use by SQL Server, or the memory SQL Server is allowed to use? And if it's the memory in use by SQL Server, then what bit, the buffer pool, the procedure cache, or what? * Startup - what do you mean? The date/time at which the instance was restarted, or the server was restarted? If the instance, there are many ways of doing this with varying degrees of accuracy. Me, I tend to go with the creation date of the temp database. * Number of cores - there's a handy DMV (Dynamic management View) that contains some of this sort of thing - it's called [`sys.dm_os_sys_info`][2] - check it out. Just a thought - you might want to keep track of the Edition as well as the version, as that's where licensing snafus can get a bit expensive... Database: * database id & name - and some other stuff - look in sys.databases * space used - is that the space used inside the database, or the space the database takes up on disk? I would aim at tracking both * Last Backups - there's a load of useful information returned by [`DBCC DBINFO`][3] * Index information - oh, wait. [Another bunch of DMVs][4]. Anything else? [1]: https://msdn.microsoft.com/en-us/library/ms174396.aspx [2]: https://msdn.microsoft.com/en-us/library/ms175048.aspx [3]: https://www.google.co.uk/search?q=dbcc+dbinfo [4]: https://msdn.microsoft.com/en-GB/library/ms187974.aspx