Inspector 2.7

#296 - Added extra control over backup thresholds, you can now add thresholds for servername/database name combination along with the relevant thresholds for FULL, DIFF and LOG

#298 - Thresholds for long running transactions can now be set based on one or more of the following:

• login_name
• program_name
• host_name

#299 - New module added to keep track of memory dumps

#300 - New module added to track enabled jobs based on a defined list

Inspector 2.6

#279 – Improved the server settings module, this now keeps tabs on your server settings and lets you know of any changes that the collection detects in addition to being able to set your own desired values for config values.

#273 – Added a new module to monitor tempDB file space used – a new percentage threshold can be found in the settings table, if tempdb usage per file exceeds this amount the file info utilisation info will be logged to the new Temdb table along with the oldest transaction spid and transaction start time.

#282 – Added a history table for the long running transactions report so that you can check previous long running transactions.

#283 – For the long running transactions module We now record the last statement executed for the session and log this to a new column called ‘Querytext’, we only log this information to table it is not included in the reports.

#278 – Made some changes to our out of date collections checks, these used to check to see if data had been logged for that day as a whole but now they check to ensure that a collection has occured since the last report run.

#275 – Replaced our old way of calculating median in the drive space module with the PERCENTILE_CONT function instead.

#276 – Backups check module has had the Diff backup threshold changed to hours rather than days, during the inspector upgrade we automatically convert your Diff threshold from days to hours.

#280 – New column added to the ModuleConfig table ‘EmailAsAttachment’ to allow reports to be sent as an email attachment. When enabled you will receive the header of the email along with the warnings/advisoryies section however the rest of the email is cut short there and you will find the complete report attached to the email as a file allowing you to open in a browser instead.

#277 – Removed linked server support, it was becoming hard work trying to maintain multiple options so for ease of development we have removed this functionality. If you are using the linked server functionality currently you might want stay on the version you are on.

#281 – Added additional server information to each server heading in the reports, this includes:
Machine type i.e Virtual, physical
Total RAM installed
CPU count
Hyperthread count
Scheduler count
CPU affinity setting

#272 – The drive space module now supports more than one collection a day, previously you could schedule it to collect more frequetly however it was hard coded to collect just once a day and all calculations were based on a per day collection.

#286 – New view added ‘ExecutionInfo’ with execution count, average/max execution time and total execution time for all executions of inspector stored procs logged to the Executionlog table.

#289 – Database growth history retention no longer uses ‘DriveSpaceRetentionPeriodInDays’ from the setting table, it now uses a new setting called ‘DatabaseGrowthRetentionPeriodInDays’ also found in the settings table.

#290 -The stored procedure DriveCapacityHistory will show capacity changes per drive per server but you need to pass the Drive and Servername in as parameters so for ease of querying we added a new view called DriveSpaceCapacityInfo that essentially does the same thing but in query form.