{"repo":"soheilpro/sqlmon","free":true,"listed":false,"github":"https://github.com/soheilpro/sqlmon","clone":"git clone https://github.com/soheilpro/sqlmon.git","description":"Collects events from SQL Server and saves them to Elasticsearch for further analysis.","language":"JavaScript","stars":35,"topics":["sqlserver","elasticsearch","kibana","profiler","elk","profile","sql","analysis","sql-server"],"license":"MIT","category":"databases-storage","readme_excerpt":"sqlmon Collects events from SQL Server and saves them to Elasticsearch for further analysis. You can use sqltop or Kibana to analyze these data. Installation Sample Usage Trace directory sqlmon needs to write trace files to a temporary directory on the server first. Use the ---trace-directory option to specify the location of this directory: Note 1 : The SQL Server service account (usually NT Service\\MSSQLSERVER) must have Write permission on this directory. Note 2 : These files are not removed when the program ends and must be manually deleted. Duration Use the --duration or -d parameter to specify the duration that the trace must run: You can use any specifier like 30s , 10m , 2h , or 1d . The default is 60s . Max trace size By default, sqlmon limits the size of trace files to 1 GB. You can change this by using the --max-size option (in megabytes): Events to capture Use the --events parameter to specify the events to be captured: See all supported events. Fields to include Use the --fields parameter to specify the fields to be included: See all supported fields. Index name The default Elasticsearch index name is sql-YY.MM.DD which can be changed using the --index-prefix option: Collect only If you only want to collect events without saving them to Elasticsearch, you can use the --collect-only option. Importing trace files If you have a saved trace file (created by either sqlmon or SQL Server Profiler), you can import it into Elasticsearch using the --import option: Delayed ","default_branch":null,"files":null,"tree":[],"storefront":"/r/soheilpro","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/soheilpro/sqlmon/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}