Search all the documentation for "log files"
of metrics as follows: Impact = log((TotalCPUTime x 3) + TotalLogicalReads + TotalLogicalWrites) What are the queries within the procedur
will see: alerts raised for the machine itself (such as disk space or memory alerts) alerts raised for all instances running on it (such
the queries which need most attention. It is calculated from a combination of metrics as follows: QueryImpact = log((TotalCPUTime x 3) +
http://www.red-gate.com/products/dotnet-development/smartassembly/features/feature-usage-reporting-data-collected. Known issues IIS path
/sm11/release-notes-and-other-versions/sql-monitor-3-0-release-notes
it to a flyway folder. If you have installed Flyway using Flyway Desktop, copy the flyway CLI folder from the installation folder (eg "C:
folder. The initial name of the baseline file will follow the pattern 001_YYYYMMDD-HHMM_username.sql. Note that you may rename the initia
These are the settings relating to database comparisons and deployment script generation for Oracle. Oracle settings table Name Required?
cog in the top right of an opened project and check trust the server certificate. OR Edit the URL property in the settings file to append
/fd/could-not-establish-a-secure-sql-server-connection-using-ssl-encryption-150700245.html
access to your PowerShell session and you'll need to download the SQL Monitor PowerShell Module. The cmdlets in this file can be used to
RedgateSQM zip file. Remove-Item $ModuleZip
file %PROGRAMDATA%\Red Gate\SQL Monitor\RedGate.SqlMonitor.Engine.Alerting.Base.Service.exe.settings.config and insert either of the foll
through the Folder Browser or File Browser, you may encounter the following error: Cannot access resource. Check that you have the correc
/display/SBU8/Cannot+access+resource+when+browsing+SQL+Servers+with+Windows+authentication
your database from the dropdown when creating a new project: image2022-1-20_13-51-29.png You can also import an existing flyway.conf file
Project's migrations folder, create a new file called afterClean__Clone-using-Flashback.sql. (CallBack scripts … with your team Save thi
of backup (full, differential or transaction log), then select the databases you want to back up. To back up all databases, or all system
scripts were generated and their names. image2021-10-28_15-53-49.png Next steps Commit the files to version control using the Version con
. Storage data (1 year) – Displayed on the Disk Capacity Planning page, the Database overview page under Files, the Analysis page, listed
/sm13/setting-sql-monitor-data-retention-policy-195789996.html
The differencing disk does not inflate except when there is a database write. Users have sometimes seen this grow very quickly when they
These are the settings relating to database comparisons and deployment script generation. Elements Name Required? Type Description filterF
, from the File menu, select New > Project. The New Project page is displayed: image2018-6-13_11-1-38.png From the Installed > Other Langu
/sca3/tutorials/getting-started-with-sql-change-automation-projects-in-visual-studio
that you're currently logged into. Or Select Specify an account, choose either Windows or SQL Server authentication, and provide the acco
, the following is displayed: monitoring-connected.png If there is a problem collecting data from a server, click Show log: connection-fai
/sm12/installation-and-setup/using-sql-monitor-for-the-first-time
to help you understand what the problem is before you log in to view details of the alert https://documentation.red-gate.com/display/~ton
/sm12/metrics-alerts-and-notifications/configuring-alert-notifications/setting-up-email-notification
will see: alerts raised for the machine itself (such as disk space or memory alerts) alerts raised for all instances running on it (such
/sm12/sql-server-performance-and-activity-monitoring/responding-to-alerts/filtering-alerts
log entries are truncated by default, but can be expanded if the full text is needed. SRP-10834 Server Overview database count could give
/sm12/release-notes-and-other-versions/sql-monitor-6-0-release-notes