Trace multiple servers at once - the xSQL Profiler can be anywhere and can monitor any accessible SQL Servers simultaneously - it will create, start and stop the user defined traces on all the selected servers at the scheduled intervals and automatically collect the trace data and store in the central repository. |
|
Load data directly from network or through the temp database - xSQL Profiler offers two options for loading data to the central repository. If the folder where the temp trace files are stored is accessible to the xSQL Profiler Service, it can load data directly from this folder. Otherwise it will first load the data to the temp database of the target server and from there load them to the central repository. |
|
Use predefined events or define custom events - xSQL Profiler comes with a set of predefined events that have been defined on top of the lower level, basic SQL Server events. The user can further define his/her own events by selecting the SQL Server events to monitor, the columns of interest and defining filters on top of those. Example: to monitor DELETE statements select "RPC:Starting" and "SP:Starting" events and apply a filter on the TextData column: "TextData LIKE '%DELETE%FROM%'". |
|
Powerful filtering capability, precise tracing - one of the biggest advantages of the xSQL Profiler is its powerful filtering capability. From simple equal or like operators to regular expressions can be utilized to filer the events that will be traced providing for a very precise definition of traces thus minimizing the burden on the servers being traced - trace only what you want, nothing more, nothing less. |
|
Advanced scheduling - xSQL Profiler provides a powerful scheduling utility that allows the user to define multiple intervals during which the trace should be running on the selected servers. Those intervals can be scheduled to occur only once or recur every day, week or month. |
|
Flexible reporting interface - the view trace data capability allows you to filter the data based on event type, server, database, user, datetime, text of the event. You can further group the data based on any of the displayed columns by simply dragging and dropping a column header. In addition, xSQL Profiler gives the user the ultimate power by providing for direct querying of the xSQL Profiler database |
|
Use for performance, auditing and compliance - the flexibility of xSQL Profiler makes it an ideal tool to use for pinpointing SQL Server performance issues, auditing certain events and ensuring that you are in compliance with different sets of regulations such as Sarbanes-Oxley, HIPAA, GLBA, etc. |
|
Supports SQL Server 2000/2005/2008 - xSQL Profiler supports SQL Server 2000, SQL Server 2005 and the newest, yet to be released version, SQL Server 2008 - that likely covers the whole spectrum of versions you may be running in your organization so you don't have to worry whether you will have support when you decide to upgrade. |
|
Up and running in minutes, no agents to install - you can be up and running in no time, there are no agents to install on the target servers, it only takes a few minutes to install and a few more minutes to configure and schedule your traces and you are done, xSQL Profiler takes care of the rest - it will automatically start and stop the traces in the predefined intervals and collect the data into the central repository. |
|