sqlstatscollector

Project for collecting statistics on a SQL Server instance

The current full code version works on SQL Server 2012 and forward.

• SQL Server 2008/2008 R2 see the code in the Legacy folder.
  • The xevent functionality in [status_of_collectors] doesn't work.
  • Physical RAM in server_properties is not compatible with 2008(R2)
• SQL 2005 and before is likely to never be implemented.

Project parts

sqlstatscollector - the database

This is the folder of the instance database. This database should exist on all SQL Server instances that should use data collection.

To install the database you have the option to run

• setup.cmd - Will install the database on the local server if you don't edit the file and change the variable on line 4 SET sqlserver=.
• setup.ps1 - Will by default install to the local server but can be changed by the parameter SQLServer that takes server names in an array .\setup.ps1 -SQLServer 'server1','server2'

The agent job to collect data is created disabled. To collect data you have to enable the agent job

dataconsolidation

The code in this directory is installed on the central server, where the sqlstatsmain database is located. Currently there is a Powershell script that connects to all

Project parts to be created

• the central database - a database that collects all instances data
• the web UI - lets you add instances for collection to the central database
• the reports - a view of the statistics and potential issues in the database

old project parts (to be removed)

• database
• helperscripts
• scheduling