Skip to content

SqlProfiler is a simple and fast replacement for SQL Server Profiler with basic GUI

Notifications You must be signed in to change notification settings

sergiye/sqlprofiler

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SqlProfiler

Release Downloads Last commit

SqlProfiler is a simple and fast replacement for SQL Server Profiler with basic GUI.

Can be used with both LocalDB, Express, Development and full-functional editions of SQL Server (2005 and later). Distribution package contains standalone portable (can be used without installation) version of SqlProfiler.

What does it look like?

Here's a preview of the app's UI running on Windows 10:

preview

Also there are:

  • Auto/Light/Dark themes integrated into executable.
  • Custom themes supported from external files

To add custom theme to the app, just create a themes folder next to the executable file and place any {themeName}.json files there. Custom theme.json file content example:

{
  "DisplayName": "Custom Theme",
  "DarkMode": true,
  "BackgroundColor": "#1E1E1E",
  "ForegroundColor": "#E9E9E9",
  "HyperlinkColor": "#00D980",
  "SelectedBackgroundColor": "#4CBB17",
  "SelectedForegroundColor": "#000000",
  "LineColor": "#262626",
  "StrongLineColor": "#454545",
  "WarnColor": "#FF4500"
}

Don't forget to restart the app to scan for new theme files!

Download Latest Version

The published version can be obtained from releases page, or get the newer one directly from: Latest Version

Features

  • Tracing of basic set of events (Batch/RPC/SP:Stmt Starting/Completed, Audit login/logout, User error messages, Blocked Process report) and columns (Event Class, Text Data,Login, CPU, Reads, Writes, Duration, SPID, Start/End time, Database/Object/Application name) - both selectable
  • Filters on most data columns
  • Copy all/selected event rows to clipboard in form of XML
  • Find in "Text data" column
  • Export data in Excel's clipboard format

Command-line parameters

Can be used to set default GUI values

  • -server, -s
  • -user, -u
  • -password, -p
  • -maxevents, -m : set maximum events in event list (1000 by default)
  • -duration, -d : sets filter on duration column
  • -start : automatically start profiling

How can I help improve it?

The sqlprofiler team welcomes feedback and contributions!
You can check if it works properly on your PC. If you notice any inaccuracies, please send us a pull request. If you have any suggestions or improvements, don't hesitate to create an issue.

Also, don't forget to star the repository to help other people find it.

Star History Chart

Stargazers repo roster for @sergiye/sqlprofiler

Donate!

Every cup of coffee you donate will help this app become better and let me know that this project is in demand.

License

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

About

SqlProfiler is a simple and fast replacement for SQL Server Profiler with basic GUI

Topics

Resources

Stars

Watchers

Forks

Sponsor this project